populate a cell with todays date if its blank


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".


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!