Column formulas

Erik Schlemmer

Can I assign a formula to an entire column so I don't have to keep copying the formula to the next row?

Genevieve P.

Hi @Erik Schlemmer

Our Product Team implemented your Enhancement Request! This week we released Column Formulas, where you can set one formula for the entire column.

See our Help Center for more details: https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Cheers,

Genevieve

Andrée Starå

Hi @Erik Schlemmer

Unfortunately, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment to have your vote added

I hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help 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! 

Genevieve P.

Hi @Erik Schlemmer

Our Product Team implemented your Enhancement Request! This week we released Column Formulas, where you can set one formula for the entire column.

See our Help Center for more details: https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Cheers,

Genevieve

Morgan Frost

@Genevieve P Very cool! Unfortunately I haven't been able to upgrade most of my formula-using columns to the new format because of its limited functionality. Where do I send feedback?

My main issue is that sometimes I need to override a cell's formula with a manual entry. Once a "column formula" is used the whole row is LOCKED to that formula, no manual overrides. Thus I end up still needing to use the classic drag formula down method and also keep 3 blank locked rows at the top of the sheet so new form entries pick up the formula.

Genevieve P.

Hi @Morgan Frost

It's good to hear about your use-case and why column formulas aren't the best solution in this instance. You can provide feedback through the form that Andrée linked above, here.

Thank you!

Genevieve