Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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 working on a formula that is evaluating three columns of data: 1) EOY Target Weighted MWh 2) Forecast Weighted MWh 3) Increase/Decrease (to determine if the goal for the year is to increase or decrease the MWh) Here is my current formula: =IF([Forecast Weighted MWh]@row = [EOY Target Weighted MWh]@row, "On…
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
I am trying to find a way to look at text fields and automatically remove date and time stamps plus employee names. Any recommendations on identifying and removing text strings that meet the below formats: YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] YYYY-MM-DD HH:MM:SS.SSSSSSS ####### [Employee Name] We have a…
