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)

Travis

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?