Decimal Rounding + Adding letters to formula

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.

Find more posts tagged with

Formulas

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!

SUMIF function not working
=SUMIFS({GM Compliance Trained}, {GM Compliance Training Dept}, Department@row , {Compliance Training Date}, MONTH(7, 8, 9)) GM Compliance Trained is the number of employees trained. I am trying to sum the number of employees trained in each department during 3rd quarter (July 1-Sep 30). Thinking I need an IFERROR in there…
Prevent due dates from falling within the same calendar week?
Hi. I am working on a (roughly) annual document review system, in partnership with another team in my organization. They have requested that they receive one document to review per week. But there are more documents to review than there are weeks in the year. So I need to figure out a method for ensuring that I don't send…
How to record date without time
I would like to use automation on a sheet to record the Open and Closed date for a given RAID item. I don't want to record the time, however. Is there a way to exclude a time stamp from the automation? If it is not possible to exclude the time stamp, what formula would I need to use to extract the datae and time into…