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!
I have a dropdown containing multiple values and I need to extract only the values like [CDB0040] [CDB0038]
I'm trying to combine multiple invoice #'s while referencing a daily/weekly record ID #'s. I tried using the Join/Collect function and could pull some of the invoices if there is only 1 daily/weekly record ID #, but can't pull the invoice # if there are multiple daily/weekly record ID's in that column. Is there a way to…
Hi All, I need to calculate the MAX of the blank entries in a timecard for any 24 hour period. For example: Start counting the first row from 00, then it has 12 empty fields under each hour column, and results with 12 hours of non-work.. Next step is to check how many hours of non-work is present starting from first row's…
