Sign in to join the conversation:
Are you able to provide a formula that will for for the following: to start counting the number of work days up from a [Start Date] column, but ending it when the job is completed (whether is be an action or another date is reached)?
Much thanks
=NETWORKDAYS([Kick Off Date]@row, IF(ISDATE([Live Date]@row), [Live Date]@row, [Projected Live Date]@row))
Give this a shot...
Bingo! Much thanks for your help with this formula.
Happy to help.
Eeeek sorry to come back to this, I must have lost something in translation.
My goal was to have the "Number of Days" column be a counter, counting number of work days (NETWORKDAYS) starting from the Kick Off Date but not going on forever, but ending on the "Live Date" when that date is entered. OR if a date has to be entered for the counter to stop, then I can make that date the "Projected Live Date"
*please don't throw anything at me :S
If I am understanding what you are saying then the formula above should work. It basically says to calculate the NETWORKDAYS starting with the Kickoff Date and ending with the Live Date if one is entered. If there is no Live Date entered, it will display how many days between the Kickoff and the Projected Live Dates.
Is that not quite it?
I think I am try to accomplish something a bit different.
to calculate the NETWORKDAYS starting with the Kickoff Date and ending with the Live Date if one is entered. If there is no Live Date entered, it will display how many days from Kickoff an the present day (so I can see how far along it is) Not to display the number of days between the Kickoff and Projected live.
=NETWORKDAYS([Kick Off Date]@row, IF(ISDATE([Live Date]@row), [Live Date]@row, TODAY()))
Got it. Sorry about that. Try this one.
No need to apologize. Thank you so much for working with me (who is new with SS) to develop a formula that works for the task - more learning is required on my part. Much thanks!
No worries at all. Happy to help.
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
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,…
