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
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)