-
SUM more results from more IF conditions
Hi All, image differentย questions (1 for each column) with 3 possible drop-down answers (Yes, Maybe, Not). Every combination question/answer generate a different score. Ex: Question 1 * Yย - 3 points * Mย - 5 points * Nย - 8 points I need to have in a single cell the sum of the score of a gruop of question. Have you any tipsโฆ
-
Cell References
I'm trying to reference a sheet using a cell value, but it doesn't seem to be working. Is it possible? Cell Value: "Test Sheet" I want to reference different rows based on the first cell value, basically retrieving different cells from that one "Test Sheet" -- the reason why I want to do that is so I can just copy/pasteโฆ
-
Unparseable Error in IF(And formula
I'm trying to create an IF statement that relies on the data in 2 cells. Basically, if one cell is checked off and the other is empty, I want to create a formula on a new cell (which I will hide) so I can ultimately send an update request to the user to fill in the notes field. I haven't used the AND formula nor have Iโฆ
-
If(AND) across a range
I have a hierarchy of checkboxes. I am trying create a IF(AND) formula to at the Level 1 checkbox to be checked once all the Level 2 boxes are checked. I am able to make it work when I reference each of the cells , for example: =IF(AND([Map Complete]18= 1, [Map Complete]19 = 1, [Map Complete]20 = 1), 1, 0). When I do itโฆ
-
RYG formula based on % Complete
I'm trying to create a formula that will automate the RYG balls (red, yellow, green) based on the project's % Complete. Green = 100% Yellow = 50-99% Red is = 0-50% Below is how I wrote the formula, but I'm getting aย Unparseable errors. **Note, I'm trying to enter the formula into the Status column on row #5, figuring Iโฆ
-
If cell is empty or blank, I want to automatically enter a 0.
I'm not sure how to automatically enter a value of zero if a cell is empty. Is this possible? I tried to enter the formula below (and various iterations of it)ย but I get errors. The error for below wasย "unparseable". =IF([% Complete]1:[% Complete]17, ISBLANK, ("0")) Anyone know if this is possible? Thx, Deb
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell'sโฆ
-
COUNTIFS Using And as well as Or
Hello everyone, I am looking to have an information sheet that is looking for several criteria with "and" and "or". For example, I want the formula to count if the other sheet has "Priority 1" and "John Doe" and a status of either 1 or 2 or 3. I will have another cell on the information sheet for "Priority 2" and "Johnโฆ
-
Multiple references to another sheet
Hi, so obviously if I want to have a given cell in one sheet reference another cell in a different sheet, this is easily achieved. But let's say I want cell A1 in one sheet to reference A1 in a different sheet, followed by B1 referencing B1 and so on... do I have to set these up one cell at a time??? If I try to grab theโฆ
-
Formula for most recently modified among checked items only
Hello, I'm working within a sheetย andย want to be able to show the most recently modified date onlyย from a set of tasks that haveย also been checked. So far I have =MAX([Modified Date]:[Modified Date]) This should show the most recently modified,ย but I'm not sure how to filter out the unchecked items (IF statement?). Anyโฆ