IF, THEN forumula

Jennifer Flanagan

I want the date column to = today if the checkbox is checked in another column The below formula is not working

=IF([Done]6 = 1, =TODAY())

Connor Hartford

Hi Jennifer,

For the TODAY() formula to output a date for you, it needs to be in a Date type column. You'll want your formula to look something like this:

IF([Done}6 = 1, TODAY(), "")

If your formula and the checkbox are on the same row, you'd benefit from using this formula instead.

IF([Done}@row = 1, TODAY(), "")

Connor

Connor Hartford

Hi Jennifer,

For the TODAY() formula to output a date for you, it needs to be in a Date type column. You'll want your formula to look something like this:

IF([Done}6 = 1, TODAY(), "")

If your formula and the checkbox are on the same row, you'd benefit from using this formula instead.

IF([Done}@row = 1, TODAY(), "")

Connor

Jennifer Flanagan

Thanks!

David Joyeuse

Watchout when using TODAY() in formula, because the date will change everyday within the cell.

In your formula, =IF([Done]@row=1, TODAY()). Will display 01/01/20 if it is done on the 01/01/20. But on the 02/02/20, it will display 01/02/20 even if it was done on the first.

That's because the value is TODAY() and not 01/01/20.

Andrée Starå

Hi @Jennifer Flanagan

Have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!