-
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…
-
Formula Help!!!!! PLEASE
I have a data set with a bunch of dates 09/03/19 09/04/19 08/19/19 07/01/19 You get the idea.... Im trying to get a count of "incidents" by month... but I cant get the formula to work!!! July = 10 Ive tried... (below) and many others... =COUNTIF({(NEW) Support Request (USER) Range 10}, MONTH({(NEW) Support Request (USER)…