-
Dynamic "UNIQUE" Function
Is there any type of function similar to the UNIQUE function in Excel that I can use? I have a Master List on one Sheet (called "QMS Transformations Common List") and I want to use links for the first column on another sheet ("named "QMS Metrics Calculation - Workstreams"). In excel I could use the UNIQUE function, and it…
-
"Invalid Data Type" Error - Need Formula Help!
I am trying to add 3 years from the "Date Completed" column; however, I'm getting the "INVALID DATA TYPE" for the cells where "Date Completed" are blank. I'd like for the "Date of Renewal" to stay blank if the Date Completed is blank. =DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date…
-
COUNTIFS
Good afternoon all!! First time poster on here and still learning my Smartsheet. Stumped on the formula and looking for some assistance. I'm trying to count the checkboxes in the 2 columns on the sheet below, SUG Scheduled and SUG Completed. What I am trying to do is count it each column for each similar column for the…
-
Cross sheet formula to pull in value
I am trying to write a formula that looks at another sheet, looks at 1 column if the column is NOT equal to 0 then it would pull in a different column's cell information. =IF(INDEX({Job Intake Form - Fence Range 1},1){Job Intake Form - Fence Range 2}>0) This is what I was thinking {Job Intake Form - Fence Range 1}…
-
Formula to calculate a total of how in a column year to date
I want to count how many have been hired A220 in the below year to date The formula I used: =COUNTIFS([Date of CJO]:[Date of CJO], @cell <= TODAY(), [Date of CJO]:[Date of CJO], @cell > TODAY(-157), Fleet:Fleet, "A220") and =COUNTIFS([Interview Date]:[Interview Date], @cell <= TODAY(), [Interview Date]:[Interview Date],…
-
How to count how many are in the last 7 days
I am trying to count how many cells are in the last 7 days The formula I used is: =COUNTIF([Avature Application]:[Avature Appication], AND(@cell<= TODAY(), @cell > TODAY(-7)))
-
Divide by Zero Help
Hello all! I'm trying to calculate an average processing time when certain variables are met. Please see below: =AVG(COLLECT({Support Processing Time}, {Created}, "2023", {Crew Ops Support Team Member}, "Trenton Graf", {Agility Number}, ""), COLLECT({Support Processing Time}, {Created}, "2023", {Crew Ops Support Team…
-
Cross-Sheet Formula for Average of Column Excluding Blanks
I have three columns that are populated by column formulas. I need to calculate the average of each column and exclude blank cells in a different sheet. I appreciate your help! Thank you, Lori
-
Help with an Index/Match formula please
Hi All, Looking for some help with an Index/Match(if) formula please. Basically, if the value of a cell in column 1 = the value of a cell in column 2, then return the corresponding value which is situated in column 3. Please see attached screenshot for reference, I am working with dates across sheets. if a cell in DATE ID…
-
Trying to determine if all children have N/A Status
I'm working on a formula for summary rows to look at the % Complete of the row as well as the statuses of the child rows. I have the % Complete portion handled: =IF([% Complete]@row = 1, "Complete", IF(AND([% Complete]@row > 0, [% Complete]@row < 1), "In Progress", IF([% Complete]@row = 0, "Not Started"))) I want to add in…
