Move Row to Another Sheet Once Everything is Filled In

Automations 1

Hi Community,

I am trying to make a work flow that moves a row when the Latest Claim Status is Denied. However, I only want the row to move once all the columns are filled in for that row. I don't want any specific cell to be the trigger as the information might not be filled out in column order and I don't want the row to move until all the data is collected and filled in. I want that once the claim status says denied and ALL the columns are filled out, only move the row then.

I was thinking of making a formula in a hidden cell that calculates if all the cells are not blank, and then the trigger will be if that cell changes to "complete". I believe I am looking for a formula that says the following: "if column A is Denied, AND column B is not blank, AND column C is not blank, AND column D is not blank, then return "completed" to Column E, otherwise leave blank. I will then make a work flow where Column E is the trigger.

I tried the following formula, however "Complete" is returned if just one column has information in it and not all of them!

=IF(AND([Latest Claim Status]1 = "Denied", [Claim Denial]1 = "", [To Date]1 = "", [From Date]1 = ""), "Missing", "Complete")

Paul Newcome

Try this instead...

=IF(AND([Latest Claim Status]@row = "Denied", [Claim Denial]@row <> "", [To Date]@row <> "", [From Date]@row <> ""), "Complete", "Missing")

Automations 1

I realized that if I do the above formula I will have a problem with the formula auto filling being that the data may not be filled out in row order as well... :(

Paul Newcome

Try this instead...

=IF(AND([Latest Claim Status]@row = "Denied", [Claim Denial]@row <> "", [To Date]@row <> "", [From Date]@row <> ""), "Complete", "Missing")