Column Formulas


I am putting column formulas on a sheet, which I'm excited about.

However, we had a top row that had some explanations for users i.e. whether a column was Required, Admin only, and this one that has been super helpful to find people what RYGB stand for rather than having them interpret for themselves.

"Status" convention:

Red – Task is off track, without a plan to get back on track

Yellow – Task is off track, with a plan to get back on track

Green – Task is on track

Blue – Task is complete

However, with column formulas, it adds the formula to ALL cells in the column.

I know I can add in under i for a column but it's less easy to see.

Does anyone else use explanations? and how do you do that? Looking for any and all suggestions.

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!