-
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.
-
Adding "Months" to a Date (Column)
I have a Column [Planned FPI] 01/02/23 that I want to ADD a # of Months [Estimated Duration (Months] to and I can't get the formula to return a Date.
-
Index Match Issues - #NO MATCH
I have 2 sheets. In sheet 1, I am trying to output the project names based on matching PO# values between sheets 1 and 2, sheet 2 has corresponding project names. I am getting a #NO MATCH error. My first thought is that this is happening because there are multiple lines in sheet 2 with that PO# and Project names. My…