Forumla to add a date


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!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!