-
SUMIFS excluding criteria
I am trying to sum the amount awarded to programs that have been won by all clients except Client X, Client Y or Client Z but my formula below is coming up #UNPARSEABLE. What am I doing wrong? =SUMIFS([Amount Awarded]:[Amount Awarded], [Customer Name]:[Customer Name], <> ”Client X", <> ”Client Y”, <> “Client Z”,…
-
Multi-Select Formulas
First.....Im so happy the Multi-select feature is now available - so thank you. This leads me needing some assistance. I have played around with a LOT Of different formulas trying o find a way to capture this information. I am needing help with trying to find a formula to do a count of selected options that were placed in…
-
Checking a box in a sheet when searching a person and if they are checked in another sheet
Hello, We have a data input sheet where we would like to signify who are key personnel using a checkbox (star). In the data input sheet, we have staff names (Person) as well. We also have a rollup sheet in which I would like to have a box checked if the staff (Person) is checked in the data input sheet. I know I need to do…
-
Formula for Parent/Child based on how it is answered
Hello, I am trying to use a formula that can be used for data validation. So if a grandchild is selected as "In Review" but the other grandchild rows are still in "Not Reviewed" I want the child and parent to reflect that overall section as "In Review" How would I set this up? I know I can use the =SUM(CHILDREN()) for…
-
Formula
I Have a sheet that collects, via form, all the diesel issued to our equipment. I have a column that needs to look at the previous hours for the specific equipment number, but my formula only looks 1 entry back, and should continuously look back. My formula looks like this; =INDEX(COLLECT([km/Hour]:[km/Hour], [Job #]:[Job…
-
Index Match is pulling correctly and then starts duplicating wrong values in cell
Hello, I am trying to pull in the email address from a master contact list into a different contact list with pay rates. I am using this formula: =INDEX({EMAIL}, MATCH([Full Name]@row, {FULLNAME})) and initially it is pulling the correct email address to the correct individual, then further down the page it starts…
-
Formula to get sheet summary to update percentage complete based on any value in a specific column
Hello Community! I am very novice to data formulas and have tried a combination of a few to try to get a result. Any guidance will be appreciated! Here's the formula where I get an #INCORRECT ARGUMENT SET error: =100 * COUNTIFS([Primary Practice Area]:[Primary Practice Area], ="Aquatics", NOT(ISBLANK(Decision:Decision)) /…
-
Formula - Adding count of parent and children rows
Hi! I am trying to add the sum of the parent row that has "2024 in the years active + the children row that has "2024". The current formula only counts children, but would like to add the parent row's active year too: =COUNTIFS(CHILDREN([AM/PM Years Active]@row), HAS(@cell, "2024"))
-
Collect Data and Join
Hi There I have a sheet which is populated by a form (Booking Form) where the user selects a date, and enters her/his details and the number of people, As these people select dates randomly, the Smartsheet list is not in chronological order. I have successfully created another sheet (Summary Sheet) where I use the date and…
-
Looking to take a parent row on the pulled column and put a percent complete of the children rows.
