Apostrophe in formula

darkmatter

Aim:

I am running a helpdesk in Smartsheet and am trying to autopopulate 'ticket closed' fields for Year, Month, and Week according to a 'date closed' field. E.g. YYYY column: =IFERROR(YEAR([Date Closed]@row), "TBC"). Once a ticket is closed, the YYYY cell should display '2021'.

Context:

The sheet is a local sheet (for a local office) which is being populated from a central form, stored within and triaged via a workflow on the central sheet. I.e. if a user selects a local office, the central workflow will 'move row' to the appropriate local office's sheet, and display the ticket.

Issue:

It seems that the workflow is preventing the formula from auto-filling on the local sheet, despite all other rows in the local sheet having the same formula. The workflow currently results in text appearing instead of the formula being applied, due to the added apostrophe E.g: '=IFERROR(YEAR([Date Closed]@row), "TBC").

Context:

The auto-fill works fine without the triage from one sheet to another.

Failed attempt:

I've tried using the 'change cell' workflow in the local sheet to remove the apostrophe, to no avail.

Any advice would be much appreciated!

Andrée Starå

Hi @darkmatter

I hope you're well and safe!

Not sure I follow.

Unfortunately, you can't use the change cell action to add or change the formula, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!