Decimal Rounding + Adding letters to formula

@SPark

Hello!

I'm trying to have this formula round + add a "w" to the end but I cannot seem to figure it out. 

The formula is:

=(Due1 - Due@row) / 7 + "w"

I would like it to say 12.9w but it keeps saying 12.85714w and I've tried using the "Decrease Decimal" option and it does not work. 

Due1 = 2/24/20

Due@row = 11/26/19

90-day variance that I'm trying to calculate out in weeks rounded to the nearest tenth decimal. 

Mike Wilday

Try this... 

=Round(Due1 - Due@row / 7, 1)+"w"

Did that work? 

@SPark

Kind of... I did this:

=ROUND((Due1 - Due@row) / 7, 1) + "w"

Just needed an extra parenthesis there! YAY thank you!!! You rock! 

Mike Wilday

Oh yeah! That makes sense! I am glad I could get you pointed in the right direction! Happy Smartsheeting!