-
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)) /…
-
Status Column to Flag Red Or Green - (different rows have different range)
I am having an issue and need some assistance. I have 3 columns A, B and C Column A- Lower range (a number) Column B - Upper range (a number) Column C - Status Column (Red, Amber and Green dots) I have several rows with different upper and lower ranges I want the status column to flag 'Red' if its above or below the ranges…
-
Top 10 Formula Error If there are Less Than 10 Results
Hi. I am using the following formula to check a box for the top 10 results. However, in some of my Smartsheets there may be only a top 2 or top 7. In those cases I am getting an #INVALID OPERATION error. How can I adjust the formula below so that it doesn't throw an error if there are less than 10 results?…
-
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…