Not sure what to do here. I inherited this sheet and the countm formula will not stay. If you remove the apostrophe it reverts back within a minute. How can I keep the formula?
@Laz It looks like they were using the apostrophe to keep the formula from running, and so Smartsheet displayed the formula as text in the cell. If you remove the apostrophe, then the formula would execute and return a number.
What are you trying to accomplish?
Darren Mullen, smartsheetguru.com
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
@Darren Mullen It keeps reverting back to the apostrophe. How do I keep it apostrophe free?
I hope you're well and safe!
Try copying the formula without the apostrophe and then pasting it and converting it to a column formula.
Did that work/help?
I hope that helps!
Be safe, and have a fantastic weekend!
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, Awesome, 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
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi there, I'm building out a new sheet where I utilizing the system's "Last Modified" date column. I tried to trigger a workflow off of this column that sends an update reminder if it hasn't been modified in 2 days, but the column is not showing up as an option (presumably because it's system generated). With that in mind,…
Hey All! Currently, I have a formula that if it is the Parent row (helper column shows 0) then Index multiple sheets using the SSI column. If it is a children row, use the parent SSI column to Index multiple sheets (pulling the same result). The only issue is if I have a child within a child, then the PARENT(SSI@row) no…
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
©2024. All Rights Reserved Smartsheet Inc.