Sign in to join the conversation:
How would I calculate the time between two dates (start and finish) in Weeks and Days
"8weeks 4days"
https://app.smartsheet.com/b/publish?EQBCT=dcf71ecb7f184467ab8f5debb68a04da
I've got it set up for days not weeks, but it shouldn't be hard to adjust. just pick which input strategy you want, rename your column names in your sheet to my column names, copy paste the formulas over, then name the columns back to what you want.
or if you want less precise ( no hours minutes) you might try something like:
=ROUND(NETDAYS([Start Date]1, [End Date]1) / 7 - 0.5) + " Weeks and " + (NETDAYS([Start Date]1, [End Date]1) - (ROUND(NETDAYS([Start Date]1, [End Date]1) / 7 - 0.5)) * 7) + " Days"
https://community.smartsheet.com/profile/L_123
(ROUND(NETDAYS([Start Date]1, [End Date]1) / 7) itself will round off to the whole number right, what is the purpose of - 0.5 in your formula?
It's a crude version of a rounddown() from before that function existed. Just round() might round up, and add a week to the total if the extra number of days was more than 3.5. So you take .5 away, and it can't round up.
Hi all. I'm trying to do something that I'm not sure if it's possible or not. We have a sheet that we are importing where the first column lists areas within our factory. Each column after that has a column name of a date. So 12/15/2025, 12/16/2025, 12/17/2025, etc. In each of the date columns is a target production…
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
Hello, I have a checkbox column that I would like to be checked when comparing 2 columns. I would like it to be checked if the 2 columns are not equal or if one of the 2 columns has an error. It's important to note that both columns are numbers. My original formula was: =IF([COLUMN A]@row <> [COLUMN B]@row , 1, 0) However,…
