-
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…
-
Return Current Month in Cross Sheet Formula
Hi all, I need to pull counts of events related to account #'s for the current month. On the raw data sheet, I have the row calculation working with this formula: =COUNTIFS([Event Date]@row, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), [Event Date]@row, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) However, that will just return…
-
Losing hair from index:match
Hey All. I've read through every post I can find on index match but my formula is still coming up unparsable no matter what I try. I am trying to reference columns across 2 sheets. I've created references in the end sheet under Manage References. Here's the latest version of my formula and then a list of things I've tried…
