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!
Hello, This might be somewhat of a long/confusing one. I am trying to figure out how to better automate categorization for blood pressure categories when being placed into a sheet. For example, in the image below the column "BP" is where the initial number is input. I then put a LEFT formula in the column "Sys formula" to…
I’m trying to set up an automation rule in Smartsheet where the “Status” column automatically changes to “In Progress” when the “% Complete” column is updated to a value between 1% and 99%. I noticed that there isn’t a “between” function available when setting conditions in the automation workflow. What is the correct way…
Hi all, I need support by set up of a formula. The case is: - If column 'Team' = Security AND column 'T-shirt size hours' = L = 2 days THAN column Days_Sec = 2 - If column 'Team' = Development AND column 'T-shirt size hours' = L = 2 days THAN column Days_DEV = 2 - If column 'Team' = Basis AND column 'T-shirt size hours' =…
