Sign in to join the conversation:
Greetings,
I have the start day and the duration. Is it possible to calculate the end date using these two entitites such that only working days are included (only monday through friday and not the weekends)?
Thank you
I would take a look at the WORKDAY function.
WORKDAY()
WORKDAY(date, num_days, [holidays])
Used in a Date column to return a date from a specified number of working days. Optionally excludes holidays outlined in a range.
Hmmm. You might also try turning on dependencies. It will set up a start time and a finish time column if you don't already have one and calculate the finish time for you. When you edit the start date or the duration, the end date will calculate for you automatically.
That might be a better way of doing it rather than using custom formulas.
Another added benefit of turning on dependencies is that you can also make the end of one task determine the beginning of the next one.
Thank you very much.
It worked!
Happy to help!
I would also suggest looking into dependencies as Mike suggested below. I don't use them for various reasons, so I never think about them as a solution.
Can this be done without using a function?
Greetings- I have a drop-down column where a staff member is emailed (request an update) if a row is marked as "assigned". If row 1,2,3 are assigned to the same staff member within a few mins, that staff member receives 1 email rather than 3 separate emails. We want each row to be a separate email so they can mark that row…
All of the automation workflows on all our sheets are "missing". This is what we see when we click "manage automation workflows" We're also unable to create new workflow. Smartsheet Gov Status shows no issues with workflows. Is anyone else experiencing this issue?
Hi. I have been the System Admin for the past 2 years. When I came into this role, I added our logo under the setting in Branding & Personalization. Our logo has now changed and I need to update it. However, when I go to Branding & Personalization the only options I have are Profile Visibility and Working Days. Did…
