Sign in to join the conversation:
All of my tasks are skipping over and not including this date (yesterday) in their calculations. I do not have this set as a holiday in the main settings. Is there a holiday/day off setting for the specific sheet?
Hi Jennifer,
There is! If you right-click any column header and select Edit Project Settings, then select Dependency Settings. Click the Edit button under Working Days and edit holidays here.
If you don't have holidays in the sheet, then you may have formulas that have holidays in their calculations. More info on different date functions can be found in our help center: https://help.smartsheet.com/functions
A few date functions that come to mine which allow you to include holidays are NETWORKDAY, NETWORKDAYS, and WORKDAY.
Shaine - thank you, thank you. There was an incorrect holiday in there. It fixed it. I love this forum!
Glad to help!
We are creating a three part learning series for HCP's and want to use one form to capture information presented during each visit. Is it possible to use a logical sequence only shows once each visit is entered? (Ex. Date 1, xyz presentation, then Date 2 is available to populate to enter xyz presentation) Or would I need…
I have a sheet that collects information relevant to multiple people, think of these items as task assignments. I would like to have this integrated into each individual's Outlook calendar, but I want to filter it only to what pertains to them, is this possible? I understand it can't be done from a report. I also…
I have a weird situation. I have a hyperlink to a SharePoint site in a column. Each line has a different link. When you click the link, it does not work. When you copy the text and paste it in the browser, it works. I confirmed that the link text and the display text are the same. Any suggestions?
