IF, THEN forumula

Jennifer Flanagan · 07/18/20

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 · 07/18/20

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 · 07/18/20

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 · 07/19/20

Thanks!

David Joyeuse · 07/20/20

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å · 07/20/20

Hi @Jennifer Flanagan

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

More info:

Lock or Store Date/Value Solution without using Zapier

Andrée Starå

May 24, 2020

Hi all,
I hope you're well and safe!
I've developed a solution that lets you store the date or value.
You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work.
We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it back to the main sheet in another so-called helper column. As long as you have a unique id/value that we can use, it will work.
Also, this opens up more options with auto-numbering and similar.
Depending on other workflows, you could reuse one sheet for multiple workflows.
I hope that helps!
Let me know if you have any questions!
Stay safe and have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD

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!

Formulas and Functions

Formulas and Functions

IF, THEN forumula

Best Answer

Answers

Lock or Store Date/Value Solution without using Zapier

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Is there a way to make a field in a form auto populate street address as its being entered?

IF formula for INDEX/MATCH across sheets

NETDAYS Formula Question