Embed "If" statement to entire column

Cory Truett

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?

Andrée Starå

Hi @Cory Truett

Here's more information.

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

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