Workflow Defaulting with apostrophe infront of equation

CC_ADSK

Hi Team,

I have a workflow in my smart sheet that populates " '=IF([Completion Date]@row <> "", [Completion Date]@row - [Received Date]@row)" after a date change. However, the ' is not supposed to be there and is forcing me to manual change each box every time the workflow takes effect. Is there a way to fix this issue?

Thanks,

CC

Matt Lynn ACT

@CC_ADSK you cannot do this with an automation. Here's a another post about the same topic with some ideas for dealing with this, but an automation "paste" won't work.

https://community.smartsheet.com/discussion/124007/formulas-in-automations