Change Cell Value Automation - Can I add a formula to the cell?

cjbill8872

It's ridiculous that this functionality doesn't exist already. Prefacing the text with a double-equal (==) would be enough to tell Smartsheet it's a formula and not text. This is what annoys me about Smartsheet… so many simple things that could make it so much more powerful and customizable that continue to be ignored by the developers.

Tony Platts

Smartsheet - For when you absolutely want to spend your time finding a workaround for functionality which should already exist.

auream00

Has anyone found a creative workaround to this challenge? I tried doing a simple find and replace, hoping I could remove the obnoxious ' from cells, but no joy.