Sign in to join the conversation:
Please share the formula that will auto populate the current date or "Todays Date" in the Completion Date column when the checkbox is populated in the "Done" field.
Hi Lazina,
The TODAY function will always update to the current date so tomorrow it will show that date so to get the date to stick you'd need to use a third-party solution like Zapier or the Smartsheet API.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I need to know how to write the formula that will populate into the completion date field? example formula: =If(Done), 1=(Today()). I understand how to populate todays date field "Today()" I want todays date to ONLY populate when the "check box" is populated in the "Done" field for that row item. I'm not able to use outside solution such as Zapier, How do I use Smartsheet API?
Try something like this.
=IF(Done@row = 1; TODAY())
The same version but with the below changes for your and others convenience.
=IF(Done@row = 1, TODAY())
Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.
Here's some more information about the Smartsheet API: https://developers.smartsheet.com/
Did it work?
Andrée
Great! Thanks, I was able to get it to work. I had to create a separate date column because my initial date column titled "Completion Date" was used in schedule calculations. Thanks for the guidance on developing the formula. I'm learning more and more about developing formulas to automate my work and others.
Excellent!
Happy to help!
Hi there, I've created a sheet to where my team is tracking information received. In one column, we are logging the date and time information came in (ie: November 21, 2025 8:30 AM). I would like to add a checkbox column, with a formula specifying that the box be checked if the logged time is AFTER 8:30 AM, and left…
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
