Embed "If" statement to entire column

Cory Truett
Cory Truett ✭✭
edited 10/15/20 in Formulas and Functions

I saw a new product feature toast that said it is possible to embed a statement to an entire column. Is anyone familiar with this function?

I am using an if statement based on Ancestor count to capture what phase of a project a task falls under (and then populate subsequent reports). When I add a new line, the ancestor count is auto-populated, but the if statement is not.

Does anyone know of a way to embed an if statement (and other formulas) to be auto-populated within a column when a new row is added?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!