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.
I was able to create a Smartsheet column with time included with the date (Thank you @Paul Newcome & @Akblevins ). I want to add another column that just shows the time - I used the AI Smartsheet feature to create a formula but receive an error message. Any ideas on how to correct? TIA!
Is there a way to automatically notify an operator as they are updating a form and hit submit that their entries do not match and it's a failed audit other than email notification? ex. Audit is for ensuring batch numbers match from 2 items. If the operator enters a batch that doesn't match, we would like them to be aware…
I used the AI chat to help create a formula to multiply PPU by STOCK and apply the sum to the entire INVENTORY VALUE $ column. =[PPU] * [STOCK] Why is the sum not populating in the "INVENTORY VALUE $" column? I have the properties set to American $… I think. The AI chat said there may be an issue with the sheet set up This…
