Combine formulas referencing the same cell without running into a circle reference

MarcRNelson
MarcRNelson ✭✭✭
edited 12/09/19 in Formulas and Functions

Is it possible to combine multiple formulas referencing the same cell without running into a circle reference? Similar to passing an object to a function.

I would like to combine the 3 formulas below for efficiency sake rather than creating additional columns.

=SUM([column name]24/ 1000)

=ROUND([column name]24, 1)

="$" + [column name]24 + "M"

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!