Sign in to join the conversation:
I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it is, I need it to check the box.
I meant to remove the INDEX portion of the formula and use ONLY the MATCH portion. If that returns a #NO MATCH error, then it is not finding the data in the range on your source sheet that matches the data in your [Property Info] sheet.
Typing this out I realized the problem. When you adapted the formula, you switched the ranges.
The first range should be the range you want to pull from and the second range should be the range you are matching against.
gotcha. makes sense. i appreciate your help!
Have a great day!
SGF
This discussion was created from comments split from: Can't Edit or Delete "Send as Attachment" Recurrence.
I'm the admin of a workspace which contains 2 sheets: 1) "Source Dropdown Sheet" which should function as master dropdown list to feed other sheets (sample a US State dropdown column), and 2) "Source Sheet 1" in which I'm attempting to link the State column to reduce copy/pasting. However, after going through the process…
Hi there. I am working on several sheets that have a column called "Hours" which holds an hour estimate for task rows. I'd like for their parent rows to have a sum like "=sum(children())" so I can see how many hours are estimated for each project. My problem is that while I can manually set this for the rows, these sheets…
