Decimal Rounding + Adding letters to formula

@SPark ✭✭✭
edited 12/09/19 in Formulas and Functions


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. 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!