I need to make one weekend as working days in my project. I don't want to create a parent task with sub tasks. I want to force the weekend to be a working days.
I appreciate your help
If you just want to include one weekend from your entire project (versus always making Saturdays or Sundays working days), then you can use elapsed time in your project.
In your Duration column, add an e before your number of days for that row. Ex. e7. This would count all 7 days as "working days" without skipping over weekends. (See here for more information.)
Let me know if this works for you!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
I am trying to write a formula based on two sheets. One sheet, Team Members, that has the following columns: Column 1 - Region Column 2 - Industry Column 3 - Contact The other sheet has many columns, but it has matching columns of the same Column 3 - Region Column 4 - Industry Column 10 - Contact I've tried a bunch of…
Hello! I'm looking for some help with the Netdays formula. I am trying to create a helper column that tracks the number of days between a date column titled "Start Date" (when a project began) and a date column titled "Completion" (when a project is completed). My current formula, which is just a start, is this:…
Hi, I have a sheet with ranges identified as SUBJECTM and FLAGM. On my summary page, I have a list of all variables, with the column identified as Metric. In the main sheet, the subject field is a series of checkboxes with the ability to select multiple options (think : maths, english, french, art). I want to count the…
©2024. All Rights Reserved Smartsheet Inc.