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:
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?
Smartsheet just started adding date stamps when fields are blank. As far as I can tell, this started around August 3, 2026. I have several sheets set to date stamp based on when another field is changed to any value. For example, on one sheet the Trigger is "When rows are added or changed", when BPO# changes to any value.…
Hello Community! My team experienced the following issue in the past 2 weeks: in Calendar View we can't anymore open Forms from the upper menu. We can only open Forms from the side menu, clicking on the Workpace icon. Anyone else experiencing the same problem?
I was wondering if this was actually happening or if something weird was going on with my automation. But, after 3 days, my approval requests will auto-deny and wreck my workflow, marking things as denied, even when I haven't gotten to them yet. I have a formula and a helper column that documents when an approval has gone…
