Hello out there, attaching a screenshot for reference. I'm trying to get the far right column ("Completely Processed") to check under a series of different circumstances:
- 'Check Cut to Vendor' box MUST be checked for all cases
- If none of the 'outside $$' boxes are checked and 'Check Cut to Vendor' is cut, then the 'Completely Processed' cell gets checked
- This is what has been done so far (and works for step 2): =IF(AND([Check Cut to Vendor]@row = 1, [1 is Outside $$]@row = 0, [2 is outside $$]@row = 0, [3 is Outside $$]@row = 0), 1)
- This is where I'm stuck: If any of the 3 'X is Outside $$' boxes are checked, then the corresponding 'Funding Code X Reimbursement Received' cell must have a date put into it before the 'Completely Processed' box gets checked. If more than 1 code is outside funding, then all appropriate cells need to be dated.
Any help would be greatly appreciated, thanks!