Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Append Text before Formula
J Tech
✭✭✭✭✭
I have a formula like below:
=ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) / 7) + 0.49, 0)
How do I append "ETA Week Number" before the result of the formula.
I have tried the below, but it comes up as UNPARSABLE
=“ETA Week Number “ + ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) / 7) + 0.49, 0)
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
Tags:
Comments
-
It looks like your quotes are both 'left side' quotes. I removed your quotes and typed in new ones and the formula worked:
="ETA Week Number " + ROUND(((([Finish Date]22) - DATE(2015, 1, 1)) / 7) + 0.49, 0)
Did you paste the formula into Smartsheet from another application?
This discussion has been closed.
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