Sign in to join the conversation:
Hello SmartSheet community,
I would like to add bankholidays under a "depencies disabled" mode.
It this possible ?
I take it that with a "dependency enabled" mode, that's already feasible.
https://help.smartsheet.com/articles/516392-defining-working-non-working-holidays-on-a-project-sheet
Best
Hello,
At this time, dependancies must be enabled in order for non-working days or holidays to be excluded in the duration calculation.
As a workaround, you could create a formula using the NETWORKDAY function to calculate the number of days between two dates, adding 1 day to the result if the start date is a non-working day.
The NETWORKDAY function allows you to enter the dates you would like to exclude. More information on this function can be found here: https://help.smartsheet.com/function/networkday
Has anyone had an issue where collaborators have lost their editor access to a worksheet? If so, how was it corrected? I have tried removing and resetting, clearing history cache, ensuring Publish:Read Only is OFF, etc. I could rteally use some help.
Like the title says. I wanted to send an email to all shared users of a sheet. I checked the box for 'cc myself' and it cc'd me on each individual email it sent to each user. I received hundreds of emails in seconds all with the same subject.
One of my team member is facing a repititive bug while entering comments on Smartsheet tracker. He has full permission on the tracker and doesnt have any internet or version issues. He is faccing this Smartsheet bug for some time where the comments are created after long set of empty pages and its hard to know how many…
