0

I'm trying to create a way to keep track of our jobs by creating a Google spreadsheet. We can only order our final product when the digital and hard copy proof is approved and we have an order from purchasing. I have columns created for digital proof approval, hard copy proof approval and order received. Is there a way to out fill a 4th column called Ready to Order after all of the other columns have something entered in them?

migrated from superuser.com Jan 11 at 20:15

This question came from our site for computer enthusiasts and power users.

  • yes, look into COUNTA – Scott Craner Jan 10 at 22:12
0

=ARRAYFORMULA(IF(COUNTIF(IF(A2:C<>""; ROW(A2:A)); ROW(A2:A))=3; "YES!"; ))

6

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy