-
count open days
I need to count how many days have passed since an answer appeared I have the date column I have been reading on using the WORKDAY formula But I get the wrong argument = WORKDAY ([DATE] 11.5 How can I do to count the days? they work 5 days a week regards
-
At Risk formula help
Hello, I need help with creating a 'At Risk flag' when End Date is reached and Status is not complete. I have tried multiple combinations, can someone please review and help me correct this formula I am entering on Row4, End Date and Status are columns and Complete is a drop down under the status column. =IF(AND[End Date]4…
-
Identifying Duplicates within a column
Does anyone know how i can do this? it seems that SmartSheet does not have the ability to do this as in Excel.
-
Nested Crtiteria
Hi, I'm trying to write a formula that would give me the total Number of request by person, that does not include Completed or abandoned. I used the following formula and it come up as nested criteria. =COUNTIFS({Status}, @cell <> $[Primary Column]7, {Owner}, @cell = "Erica" + COUNTIFS({Status}, @cell <> $[Primary…
-
Status for At Risk tasks due in 7 days
I have 4 status categories for my project with respective RYGB balls: * Complete (blue) * At Risk (red) * Requires Attention (yellow) * On Track (green) My current formula in the Health column automatically changes the RYGB balls when the status is changed manually: =IF(Status2 = "On Track", "Green", IF(Status2 =…
-
Help with Auto-populating dates
Hi All, I have been trying to figure out how to auto-populate dates. I've figured out that if I enter a date, type in the desired duration of when I'd like the task due, it populates the due date for me. All of that seems like it's project in the future and I'm running into this particular problem. Let's say I need to…
-
Calculating a column based on date
I'm trying to total up the job value column based on weekly totals. Can I have the formula calculate the weeknumber or do I have to create a helper column?
-
Change Status to "Submitted for Approval" or ""Returned to Action Party"
1. I have Action Items that can be reviewed by up to 3 Reviewers (Reviewer 1, Reviewer 2, Reviewer 3) before being Submitted for Approval. Reviewers are identified by Name. Reviews are done in parallel. 2. Some Action Items are reviewed by all 3 Reviewers, others by just 1 or 2 Reviewers. 3. After review the Reviewer uses…
-
SUMIF on Cross Sheets
Hello, I've been trying to create a roll-up based on "Region" from another sheet and I either get "0" or invalid argument. On inventory sheet I have multiple columns with Budget, Actuals, ect and would like to sumif based on Region. The formula below returns "0" =SUMIF({Inventory Range 1}, {Inventory Range 2} = "ProServ…
-
Automatic RollUp of data from multiple projects
Hello everyone ! I could use some help with some dashboard 101. I've been trying to find a way to roll up data for a while without success. Let me explain the situation: I've created a "project folder template" (including sheets, report and a dashboard) that I can easily copy for every new project I'm creating (please…