Forumla to add a date

Michelle Martinelli

Hello - I'm trying to write a formula to add a date in a cell if a checkbox in another cell is not checked, like the image below. If there is a check in "transfer to tier 2" I want closed to be blank, if there is not a check, I want it to have the date the row was entered. Can anyone assist? I've looked at automations to add a date but I am not sure that is exactly what I am looking for. Thank you!

Andrée Starå

Hi @Michelle Martinelli

I hope you're well and safe!

You could add the System Column, Created Date, and then reference it in a formula that would show it if the checkbox is empty or make the cell blank if it's not.

Make sense?

Would that work/help?

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 support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Peggy Parchert

Hello @Michelle Martinelli

Would this work?

Closed column formula: =IF(ISBLANK([Transfer to tier 2]@row), "", [Created date]@row)

I added a system column "Created date" to provide the date the row was entered.

Hope this helps.

Peggy