-
Count unique suppliers active / not active
Hi, I'm trying to count the number of unique Third parties on a contract tracker sheet. I want to be able to count the unique numbers of Third parties by Contract Group So in the snip below: Supplier 3 and Supplier 4 would equal a count of 2 Not Active. Active would equal a count of 1 Requested would equal a count of 2…
-
what is the best way to combine contacts from children rows into parent row?
In a contacts column, I would like to combine email addresses that are in 2 children rows into their parent row. I have a helper column that checks a box of the children rows using the formula: =IF(COUNT(ANCESTORS([Protocol ID]@row)) > 0, 1)
-
Formula needed to count occurrence of a field value across multiple sheets
Scenario: Sheet A contains a field : Value Proposition. There are 8 rows in Sheet A. VP1 VP2 VP3 etc Sheet B and Sheet C have long lists of tasks, each task is assigned a Value Proposition (in field Value Proposition) In Sheet D (which is a Metrics Sheet) I need a formula to count the number of times that a Value…
-
Help with COUNTIFS
Hello. I am trying to set up a part of my metrics sheet that will count using a COUNTIFS function. I will need the conditions to be Approve and Deny, and I will need them to be able to accept each condition by year. I will attach pictures of what I mean. So I will cross refrence this sheet using the date column which will…
-
Can't Covert to Column Formula
I am trying to convert some formulas to column formulas, but the feature is greyed out and will not let me. Is this because of the way it is written, or the type of formula being used? Two specific scenarios are as follows: Target Duration - formula is: =IF([Project Type]@row = "Quote", 10, IF([Project Type]@row =…
-
Error with Formula (Divide by Zero)
Hey Everyone, Want formula to calculate the average duration for only distinct project name. I have two columns, one with project name and another one with duration. Now wanted to calculate average for only distinct project name. Currently using this formula, which is showing me Error (Divide by Zero) Formula :-…
-
Calculating a date 45 days from Start Date
I have a sheet that has a Start Date that is called Start Date #1. I need to create a new date that is 45 days from the Start Date that populates a new column. Can someone help me create a formula to do so. 😏
-
COUNTIFS with DISTINCT/COLLECT
Hello all, I've been searching for an hour and I can't seem to find the proper solution. Here's an example : I need to count the number of DISTINCT Clients if Rep is John and Renewed and Refused are both unchecked. There are several rows for the same client as there are different type but here, we want to count the number…
-
I'm receiving an unparseable error with this formula? What do I need to adjust here?
=IF({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "3. Moving Along", "Green", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "2. Needs Monitoring", "Orange", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "1. Needs…
-
Smartsheet forms and non-users
I use Smartsheet forms a lot with non-users. I just created a new form and shared it via a QR code with a non user on their mobile device, and it came up with a prompt to login into Smartsheet. To my knowledge this is the first time this has happened for me. Has there been a change? Can non-users fill out forms without…