Convert text '=Count([Field ID]:[Field ID]) to formula
Is this possible?
Answers
-
Hey Melody, a screenshot may be helpful here. Not sure exactly what you're trying to accomplish.
Is
'=Count([Field ID]:[Field ID])a value in an existing cell on your sheet? And you're wanting to get it converted to a formula somehow?
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
-
adding ' before an = sign converts a formula to text, I want to reverse this.
-
It looks like "=" cannot be converted back to = (begin formula) once it is in text format with the ' in front of it. Smartsheet sees only two things, numbers and text, there is no general formatting or =Format() function to general.
-
Hi @MelodyD
I hope you're well and safe!
I think I might have a workaround to make the formula work again.
I'll get back to the post.
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.
-
@Andrée Starå you will be a life saver!
-
@Andrée Starå The suspense is killing me. What are you cooking up for this one?
If this answer answers your question, please press "Yes" above - it helps the community (and those random Googlers out there 👀) find solutions like yours faster.
Love,
Brett Wyrick | Connect with me on LinkedIn.
------------------------------------------------------------------------------
2023 update: I'm no longer working on Smartsheet stuff. I started working at Microsoft in 2022, plus I have 1-year-old twins at home and frankly, I don't have enough time to do Smartsheet anymore. It's been real, Smartsheeters!
-
I'm still at the edge of my seat
-
@Andrée Starå I came across this thread and it's exactly what I'm trying to do. Did you ever figure out a way to convert text into a formula?
Inside a field called [Start Date], I have a formula that says [End Date]8. However, I want to control the row, in this case the '8', via another cell.
Index won't work as it creates a circular reference.
Does that make sense?
-
@Andrée Starå I'd love to see if you've come up with anything too. I haven't quite figured it out other than manual copy/paste or manually removing the apostrophe. I wonder if the API can handle that?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
