Apostrophe in formula
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!
Answers
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!