Decimal Rounding + Adding letters to formula
Options
@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
90day variance that I'm trying to calculate out in weeks rounded to the nearest tenth decimal.
Tags:
Comments

Try this...
=Round(Due1  Due@row / 7, 1)+"w"
Did that work?

Kind of... I did this:
=ROUND((Due1  Due@row) / 7, 1) + "w"
Just needed an extra parenthesis there! YAY thank you!!! You rock!

Oh yeah! That makes sense! I am glad I could get you pointed in the right direction! Happy Smartsheeting!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!