Decimal Rounding + Adding letters to formula

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

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. 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!