Initiating newly created rows

Michael Culley
Michael Culley ✭✭✭✭✭
edited 08/16/22 in Formulas and Functions

So I'm trying to setup some way of automatically initiating a blank row.

I want to do this because I have a formula in a contact list column that pulls the email of the parent row. However, I also want the blank rows to have that same contact person. The way it looks now, no matter what column formula you have, a newly inserted row does not get anything initiating it unless something is typed. Is there a way around this?

Even the column types such as autonumber, date created, etc. skip blank rows.

There must be a workaround.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!