If then formulas

Tammy Parker

I am trying to create my own easy work around to capture the date when something is completed.

IF the Completed Box is checked AND I have a last modified date column

Can I create a date completed box and say

IF the Completed Box is checked, then copy last date modified?

=IF(Completed1,1, [Last Modified Date]1, "")

Does not work... LOL

I am new to smartsheet and need an easy work around to lock this date completed, if possible.

Sorry, I have asked this question before but the answers were too elaborate for me to understand how to do it. Preferably without having to create a new second sheet.

Andrée Starå

Hi Tammy,

Yes, and maybe it was my answer that was to elaborate.

I’ll get back to the post and try to describe it in another way.

I hope that helps!

Be safe and have a fantastic weekend!

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!

Paul Newcome

Without creating a new sheet you would need to either use the API or a 3rd party tool such as Zapier.