populate a cell with todays date if its blank

Options

I'm using smartsheets for tracking a sales pipeline and I want to set the "date created" to today if its blank. I have tried a formula but I get a circular reference if I try to check the cell of being blank and populate it with "today". like


If (IsBlank([Date Created]@Row]), Today(), "")


I get a circular reference


I tried using automation to update a cell, but once I pick "created date" and check if for being blank, the action won't let me choose the same cell to update.

I'm wanting users to fill in a form, and they "can" pick the created date, but if they leave it blank I want it to be populated with "today".

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!