-
Partial Days Dependencies Disabled
We have combined a progress tracking system with a simplified scheduling formula to allow us to run multiple scenarios quickly in SmartSheet. To do this we needed unenabled dependencies from our project. Now we need to have start dates take into account partial days but cannot.
-
How do I create a formula when the complete date is entered, it will trigger the next start date?
I am trying to figure out a formula that when I actually complete something, it will trigger the next start date task. Example: I have start date, due date and complete date. Start date would be 2/1/21, with a due date of 2/10/21. I'm then filling in when the task is actually completed, 2/15/21, I would like the next startβ¦
-
If not blank then change contents of another cell
How would I do this formula? In column "Status" on row 3, I need to change it to "Completed" when column "Assigned To" on row 4 is not blank. I started with =IF([Assigned To]4) and was kind of stuck after that. TIA!
-
Need formula to look for Evening hours and Early morning hours
Good Morning, I have an excel spreadsheet that I have imported into SS. I am trying to create a rollup sheet to add to a dashboard. One of the items that I want to pull is is the number of offices that have "Evening hours" and "Early Morning Hours" based on the office hours provided. All office hours are located in oneβ¦
-
Date Range = NetworkDays
Hello, I am currently using the formula =NETWORKDAY(TODAY(), [Requested Due Date]@row) , my goal is to capture the days "today" and the requested due date. When the requested due date, is the same as today it is stating 1 instead of 0. How do I fix this? It seems to be counting today, as an active day.
-
Trouble with SUMIFS formula across multiple sheets
Hi Geniuses - I am trying to summarize a sheet ("All Staff Reports") on another sheet ("Monthly Comparisons"). In the Monthly Comparison sheet, I want to sum a column (ERTS - how many) from the All Staff Reports sheet according to the Month and Year columns (both also on the All Staff Reports Sheet). I've tried a number ofβ¦
-
How do I prevent my sheet from "updating all my formulas across the sheet
so i have 4 "Tables" in A Sheet - 2 use a SUMIF( using quantities and one using %%) and 2 use a ERRORIF ( 1 uses qties and 1 uses %%) But when i fix a formula in one cell it updates the whole sheet to be the same as i have just done I have even tried retyping the formula into a new cell but the same thing happens all theβ¦
-
IF AND formula using ANCESTOR
Hello! I am trying to automatically check a checkbox to a cell based on these conditions: The task's parent is "Releases" (task column is named Category) Status = green (RYGB symbol). Here's where I am and it's stating it is unparsable: =IF(AND([Status]@row ="green", PARENT([Category]@row="Releases"),1,0)) Any help isβ¦
-
Update Status & Have % Complete Auto Update
If I update the project status to either not started, ongoing, or complete, how can I get the % complete to automatically update to 0% (not started), 50% ongoing, and 100% complete?
-
COUNTIFS using OR nested within 1 of the criteria sets
Hello Smart Smartsheet People, I have a sheet with a Status column and an End Date Column. I need to get a count of the number of rows that have a Status of (Not Started or In progress or On Hold) AND where the End Date is in the past. Here's what I've tried: =COUNTIFS({1-Project Plan Status},OR(@cell="Notβ¦