- VLOOKUP plus a Dropdown selection???
I don't think this is possible, but thought I'd ask here. I have a situation where I would like to look up a value in another worksheet if the the value in a column adjacent to the lookup contains "DMP". I know how to write that formula, but if the value does not contain DMP, then I don't want the lookup at all, but want…
- COUNTIFS results in Zero (and NOT for same reason as in rsmith's question)
Why am I getting no errors, but a 0 (expressed as a percent as formatted) when using the following formula? Please note that I am NOT the person who named these columns or the list of values therein, but you've gotta work with what you're given, right? Here's the formula: =COUNTIFS([SF Phone decom'd/removed]2:[SF Phone…
- Parent % Complete should not be 0%
Hi Community, Can anyone offer an explanation for why the parent % Complete value in the image shared is 0%, and not a rollup of the three underlying (subordinate) values? The only non-standard variable I can think of is that the subordinate values are pulled into those cells via link, but I haven't located anything in…
- Move files attached to a row
I am making several adjustments to the structure of a project plan. Some of the records in the plan are to be deleted, but have files attached to them. Rather than downloading them, and then reattaching them to another row, I am wondering whether there is some hidden functionality somewhere that would allow me to simply…
- #INVALID OPERATION - Apostrophe catastrophe
Hi Community, I'm trying to convert some numbers expressed in KB into GB so I can sum all in GB. To do this I had to use the LEFT function to pull everything appended with "KB" from a column. That was no problem. I then took the result of that function and did a copy/paste special, so I would no longer have the formula,…
- #Boolean Expected? #Invalid Operation? I can't win for losing
I thought I was quite brilliant when I figured out that the reason a formula I created in a checkbox only column returned a #BOOLEAN EXPECTED error. I solved the problem by appending +"" to the end of my formula, and celebrated with a fun sized Snickers. Imagine my disappointment, when I tried to create a new formula that…
- Is it normal to count empty rows when selecting the entire column?
I have a formula that looks like this: =SUMIF([Request Status]:[Request Status], "5-Complete", [Est Days to Scan]:[Est Days to Scan]) I've noticed that in each of the two columns referenced in my formula, the selection includes 10 rows of blank cells below the last populated cell. Is this normal?
- Auto-Number creating duplicates!
我用汽车-Number column in my sheet to generate a new Request ID with every entry. I noticed this morning that there are duplicates of the same Request ID in the sheet. This is a concern because the RQID needs to be unique for each record. There are two ways a record is created with the sheet. One is if a user…
- Auto-fill an overwrite-able value
Hi Community, I have a worksheet with a column (let's call it "FPD Factor") for calculating how many files can be scanned per day by a process. I would like for every new record created to have that column auto-populated with "70,000", but want it to be overwrite-able by someone. I plan to use the FPD Factor value in a…
- How Nested IF can I get?
I have a desire to change a Status column based on whether (or not) certain separate (other) columns are populated with a date. Is this supposed to work? All of the Nested IF examples I have seen tend to look at just a single column to evaluate against, and I'm wondering if I'm going to be able to make this work, and using…