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'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
Hello, I use Smartsheets in a Higher Education setting. I have one sheet (Sheet A) for a list of students this sheet contains their student id numbers, email addresses, as well as other helpful information. I built a If Yes/If No check column on this sheet as well. My next sheet (sheet B) is a form that is asking is the…
