populate a cell with todays date if its blank

Grant M Davies · 07/15/21

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

Nic Larsen · 07/15/21

Why not make it a required field on the form? Could always add direction for user to input todays date if unsure.

Grant M Davies · 07/15/21

I can do that, but I'd prefer to have to auto filled.

Andrée Starå · 07/15/21

Hi @Grant M Davies

I hope you're well and safe!

To add to Nic's excellent advice/answer.

Another option could be to add it to the sheet automatically after the submission.

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Formulas and Functions

Formulas and Functions

populate a cell with todays date if its blank

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Counting occurrences of a string in a row

Rounding to nearest Thursday in the past or current day if it's Thursday

JOIN function in a Sheet Summary