Nested if/then/and/or???

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:

  1. 'Check Cut to Vendor' box MUST be checked for all cases
  2. If none of the 'outside $$' boxes are checked and 'Check Cut to Vendor' is cut, then the 'Completely Processed' cell gets checked
  3. 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)
  4. 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!

Gary



Answers

  • Danielle Arteaga
    Danielle Arteaga ✭✭✭✭✭✭
    edited 05/21/20

    Are you looking to automate entry of a date into the Funding Code n cell, or will that be manually entered?

  • Hi Danielle, the only thing to be automated is the "Completely Processed" cell, all others are manually entered (or left blank as appropriate). So there are a few different points where the "C-P" cell could be checked, depending on the number of outside reimbursements required (0-3). Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!