-
Formula question for Month Data
I need some help figuring out a formula. Wanting to sum up the amount of trainings each person enrolled in the month of April. Can't seem to figure it out. Here is what I am trying: =SUMIF([Trainings/KPL]:[Trainings/KPL], [Assigned OBC]:[Assigned OBC], "Gladys Risling", ([Start Date]:[Start Date], MONTH(@cell)4)
-
Formula help
From my sheet I need to populate a checkbox based on these criteria VDate is less than WDate AND Status = Live This formula is working to accomplish the first criteria but I can't get the status part to work. =IF([VDate]@row < [WDate]@row, 1) Thanks for the help, I am horrible at formulas!
-
Average of column if dates meet certain criteria
I'm looking for help on a formula to calculate an average of a column if the date in another column falls between the nominated start and end date. I tried a few different formulas which came up with #UNPARSEABLE, and this one: AVERAGEIF({Date Completed}, AND(>=[Start Date]@row, <=[End Date]@row, {Number})) resulted in…
-
Updating current formula from counting days to counting business days
Hello! I have been tasked with creating a formula that looks at the request type (drop down) and based on that, adds a certain number of business days to the request submitted date to give a completion date. There's 6 options, I was able to make the formula just with regular date counting, but now I need help in adding in…
-
INDEX/MATCH with a HAS Function for Multi-Select Column
I am trying to create an INDEX/MATCH where the INDEX is a Checkbox column and the MATCH is a multi-select column. I am not sure how to incorporate the HAS function for the multi-select column. I would like the High Priority flag marked if any/1 or more of the Sites Under Consideration are flagged a High Priority in the…
-
Combine 2 sheets into one
I have 2 sheets, one with customer location data and one with parcel attributes. I would like one sheets that has the data from both sheets using the parcel number to match the information. (It is listed as Parcel # on one sheet and External System Link on the other sheet.) I am not even sure how to attempt this. Is it…
-
IF Index/ Match Return Yes or No
Hello, I am using the below to return Yes or No as true or false matches. I am looking to Confirm if the Contact listed in [Requestor Contact] is also listed in range {Covered Persons List Range 3}. However, It is returning Yes across the board. My range covered 2 columns both in text. Do I need the range to be formatted…
-
Use countifs to count all projects with a quarter date and year from a date column
my current formula is =countifs({sheet reference}, ROUNDUP(MONTH(@cell)/3) = "4", {sheet reference}, Year(@cell) = "2022" I have ensured the column from the reference is a date column, however I am given invalid data type as an error
-
Countif Formula in Sheet Summary not giving results
Hi, Just wanted to check with the community if there was any change to the criterion selection under the "COUNTIF" function. I have a column formula for a checkbox column in a Smatsheet that flags if I get a result and the sheet summary calculates if the box is checked using "COUNTIF". I was seeing the results in the past…
-
Help with a formula based on conditions
Hello, I need assistance with creating a formula for the following: In the Annual $ cell, I would like the salary to automatically appear when two conditions have been met: the user provided the region (either US, CEMEA, LATAM, ASIA) AND the user has provided the Job Level. The salary should come from a different sheet (I…
