Formulas
Discussion List
- I am trying to COUNTIF range 1 is yes then range 2 meets any of 3 criteria. A single criteria works =COUNTIFS([Current Status]:[Current Status], "Active", [Milestone/Deliverable Name]:[Milestone/Deliv…
- Need a revised formula, which is in the Certification Complete column. This worked great. However I was just made aware of something. Okay, @dojones provided a perfect solution. However, as we are all…
- I have a request sheet that people will be submitting information into. Based on that information, I want one core column to be cross referenced into other sheets. Essentially that column will just be…
- Hello, Our dept's role is to facilitate visitors (overseas medical faculty), who are invited by the respective clinical departments chairs to our hospital. There is a lot of paperwork involved between…
- Hi everyone, I would like to get help with a formula related to index matching. I have two sheets, for the purposes of this discussion - Sheet A and B Sheet A (only has these two columns) Sheet B is a…
- My formula shows average of .3625 (rounding up won't even help) The sheet shows average of .97 (which is correct). The values outlined in blue are MS
- In my metric sheet, I am receiving the #INCORRECT ARGUMENT SET error on code I made trying to only count the child rows in my reference sheet. =COUNTIFS({Is it implemented?}, 1, {evidence attached 1},…
- Can someone help me with this? I have a formula which works but it's finding NO MATCH for two lines but I don't know why as the formula has no problem finding a different line on the same sheet… This …
- Hi everyone, I am looking to have a auto sequential number column that keeps sequential numbers even after moving the rows. For example before moving the rows: After moving the first row to the bottom…
- Hello I am working on this new formula where are trying to calculate the verification due date. The original way we were getting the value was when the date format was in a MM/YYYY but now the dates w…