Formulas
Discussion List
- 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…
- 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 bla…
- 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 shee…
- 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 - …
- 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), F…
- 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)))
- 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…
- 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
- 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 situ…
- 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", I…
