How to autofill a single cell when a new row is added?

rapach · 03/21/22

Our team uses a sheet to track our projects. One of the columns in the sheet is an Award Status column with dropdown options. When a new row is added, I want the default to be set to Pending. How would I go about doing that?

Andrée Starå · 03/21/22

Hi @rapach

I hope you're well and safe!

You can add a Workflow combined with the Change Cell Action.

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!

rapach · 03/21/22

https://community.smartsheet.com/discussion/comment/323418#Comment_323418

I thought it would be that simple, but it doesn't appear to be working.

Yanis Kyr · 03/21/22

@rapach I usually map this kind of workflows against system generated columns to prevent any accidental triggers. In my example the Created Date is auto populated:

Andrée Starå · 03/21/22

@rapach

How are the new rows added?

How to autofill a single cell when a new row is added?

Answers

Categories