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
Hello, I created a Smartsheet Project yesterday (trial 30 day user). I input all relevant information including due dates, status, priority, etc. I returned from work just now and logged in to update something on the sheet and all info is missing. I can see the Project Folder but all rows are empty. I tried troubleshooting…
I have a portfolio with 1 project template. I created 2 projects from the project template. I realized I need a Project Metadata sheet to facilitate the portfolio reporting I need. So I added a Project Metadata sheet to the project template and manually to the 2 projects previous created from the template. I've confirmed…
Hi Smartsheet users. We have a number of users who are being labelled in the "Seat types and true up" screen as "External". They all have the same email domain, which is different from the domain of users who are not flagged as External, however both domains belong to our company and are listed as verified under the…
