I've created a sheet that we use to track our projects.
For each project there could be one invoice we need to pay, or multiple, as the project progresses when the invoice is processed and the checks are sent out to our partners there is a column that indicates the date the invoice processing is complete. I've created a verification column as a check box that populates when the completion date is populated.
So we have 4 columns Project Number, Invoice Number, Completion Date, Completion Date Verification.
The goal we're trying to reach is for each project line, if ALL invoices per project have a completion date, return true, else return false.
If we added another verification column to achieve our goal would we need to use an index to accomplish this? A vlookup wouldn't work as we could have anywhere from 1-X amount of invoices per project, would we need to use an array? does that functionality exist in SmartSheets?
Project Number Invoice Number Completion Date Completion Date Verification
239009 308557 05/15/2019 True
239009 308558 False