nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Smartsheet Community

Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.

Welcome!

Need Formula to auto populate todays date when box checked

Lazina_carter89151

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.

Find more posts tagged with

Formulas

Project Management

Comments

Andrée Starå

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

Lazina_carter89151

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?

Andrée Starå

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?

Best,

Andrée

Lazina_carter89151

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.

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

Need formula that converts HH:MM:SS to total seconds
HI, Seeking formula assist. I have to collect monthly stats that inlcude HH:MM:SS, however I am unable to average a full quarter in smartsheet becasue this format, HH:MM:SS is deemed text. 1- What is the formula needed in the helper column to convert HH:MM:SS shown in column labeled JAN into seconds in the helper column 2-…
#BLOCKED in sheets created from template, but sporadically
We use a template (built by Smartsheet) for our Project Plan. We are seeing #BLOCKED errors in SOME project plans but not in others. The formula is identical! The columns referenced are definitely present in the sheets with the error. Any idea what could be going on? Here is the formula =INDEX(Description:Description,…
Automations have stopped for ALL smartsheets?
Greetings, I have multiple smart sheets created close to 50 and all the automations have stopped running or being delivered to people's emails. For example, anytime a new row is added please email the person who's in charge of the sheet. I'm the IT guy for the organization and have not changed anything in regards to the…