-
Questionaire with yes/no responses
I need to count "Yes" from multiple columns and divide it by any cell in those columns which have text. It also needs to be sorted by multiple criteria. This is the formula I am using but it is giving me a invalid data type error. I don't believe my OR function is being used correct but I'm not sure how to correct it. This…
-
How do I display counts of all of the dropdown options used on one sheet and possibly multiple?
Long story short, I'm building a system to track pending legislation, and for each bill that posts, team members are assigned it to one (or more) categories in a CATEGORY dropdown column. I'm working on a dashboard of high-level views, and I'm trying to figure out the most efficient way to roll-up and display how many (and…
-
SUMIF formula help
My question is will the SUMIF formula work if the cells I want to sum are in 3 adjacent columns? Here is my formula: =SUMIF([Corner Y/N]@row, 1, [B-1 QTY-Andy]@row:[B-3 QTY-Andy]@row) I am trying to sum 3 cells if the meet a checkbox criteria but it is not working. Can anyone see anything wrong? Here is what the sheet…
-
Countifs Criterion referencing other columns
I am trying to count data based on a completion date being after the request date (data error checking). "=COUNTIFS(Completed:Completed, >Requested@cell)" This give me and #Unparseable error
-
VLOOKUP for form options
Hi, I have 5 Programs of work, each with multiples projects in each (3-24). When a user is completing the associated form and selects a particular Program, I want to use a VLOOKUP on a different grid (or something) to present dropdown options of projects for just that Program in the form. I currently have 5 separate…
-
What formula to use to count all instances of a value across multiple columns.
Hello, My colleagues have set up a sheet to help them track sustainability actions in their department. They've asked me to help with setting up reports and a dashboard that summarise and calculates the types of actions across the 4 Action type columns, as well as summarising further by team. As you can see there's been an…
-
“Task Status” Formula
This discussion was created from comments split from: Task@Risk.
-
Request cancellation
Hi, I create a smartsheet project for user to request an refund purposes process. In this smartsheet, first the user will fill out the form, and it will go to the HOD for approval and then to Finance for approval. My question here is: when the process ongoing is being cancelled by a tick box, how do I make the whole…
-
How can I set up a formula with the star symbol if 6 different conditions are met?
I am trying to set up a formula that looks at 6 conditions and if met, the star will light up. I don't know where to begin. Right now I have =IF(AND([BG Results]@row = "PROCEED", [Poly]@row = "PASS", [Chief Approval]@row = "YES",[Drug]@row = "PASS",[Medical]@row = "PASS", [Psych]@row = "PASS"), 1,0))))))
-
#Invalid Operation with MATCH formula
=MATCH([Program Unique ID]@row, [Program Unique ID]:[Program Unique ID], 0) I am trying to use this formula to return which row # the first match is in so that I can automatically mark the first one and differentiate it from following duplicates, but my formula is returning #invalid operation. Open to ideas on how to fix…