@exceldictionary: How to add an automatic timestamp to a checkbox in Excel ✅ Typing the date and time by hand every time you tick a box is slow, easy to forget, and full of typos. One IF formula does it for you: =IF(C4=TRUE,IF(D4="",UPPER(TEXT(NOW(),"mm/d/yy | h:mm AM/PM | dddd")),D4),"") The moment a checkbox is ticked, the cell next to it stamps the date, time and day automatically, and the stamp stays put. Just turn on iterative calculation first (File > Options > Formulas), since the formula refers to its own cell. I used Scribe to capture every step as I built it, so it's ready to share as a step-by-step guide. It's perfect for task trackers, approval logs, attendance sheets, order status lists and any checklist where you need to know when something was done. 👉🏼 Download this free step-by-step guide I created using the link in my pr0file. I'm teaching people how to actually use AI and Excel to automate their workflows and become the most productive version of themselves at work. Follow @exceldictionary for daily Excel + AI tips. #excel #exceltips #scribehow #scribepartner #checkboxes

Excel Dictionary

Open In TikTok:

Region: US

Tuesday 06 October 2026 22:37:56 GMT