-
Formula issue showing 0-5 Stars
Can anyone identify the error in this formula - it should show "Three" stars in the column as it's counting 3 true checkbox cells. However it will only return the "Empty" stars result. Obviously the number of stars formula result is based on how many boxes are checked.
-
Check inventory in two columns and change symbol column.
Hello all ! I have a challenge for you guys. I have a sheet where we book groups for a venue. Some of those groups will also book a space for a cocktail before the show. There are 3 spots available per day for a cocktail. I would like to have a column that tells me if the cocktail area is available for that date. I guess I…
-
Counting blank cells when other criteria is met
Hi, I need to add on top of a formula that counts tasks that are in progress or not started that are past due. The formula below works for that, but now I also need my total to include cells in the target completion date that are blank. =COUNTIFS(Status129:Status144, OR(@cell = "In Progress", @cell = "Not Started"),…
-
Formula to auto assign based on request number series?
Is there a formula that could be used to assign staff automatically based on request number series? The sequential request number will be auto generated when the form is submitted. For example, if one location has three staff that get assigned requests in the order they are received, I would like to automate it so that:…
-
AVGIF Formula Based on Date Range
Hello everyone, I'm trying to get a average of a column if the cells in another column are within 90 days of today. My current formula is =AVERAGEIF([Pick-up Variance]:[Pick-up Variance], [Pick-up Date]@row>TODAY(-90)). I tried using AVG(Collect) as well with no luck. =AVG(COLLECT([Pick-up Variance]:[Pick-up Variance],…
-
Results and expressing as percentage
In my forms, I have several questions that can result as either PASS, FAIL or N/A. I want to express only the FAIL cells as a percentage over the entire row results. I've been using this formula: =COUNTIF(CellName1@row:CellName2@row, CONTAINS("PASS", @cell)) / 7 The only way I've been able to make this work is by counting…
-
Set up correct function (IF, CONTAINS)
Hi, community. I need some help) Here is example. I need function that works like that: 1) take text from List 2) compare to Main 3) if text in Main have on of the word from List, return "yes" Thanks all😊
-
Nested IF Statement with OR and AND functions
Hello, I am trying to create a nested IF statement. The formula is fed by two columns Status and End Date. The formula should return that IF status is one of "Completed" or "Adoption/Sustain" AND the end date column has a date (any date) then return "Yes" if true. I keep getting Unparseable or Circular Reference errors.…
-
Is TODAY() supported as a Sheet Summary Field?
I am trying to get a sheet summary field on my project plan to count the number of tasks which have fallen behind plan. However I do this, I am using the TODAY() function, either in a sheet column or in the summary field itself. Here is one example of something I tried in the sheet summary field: =COUNTIFS(Status:Status <>…
-
Find and Highlight duplicates in column
Hi, I'm trying to find a formula to highlight duplicate values in a column in Smartsheet. I think I have tried every formula that I can find online and in this Community, but all come back with #unparseable error. The column "Duplicate" in checkbox type is created and waites to be used. Similar formulas as mentioned below…