Move Row to Another Sheet Once Everything is Filled In
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")
Best Answer
-
Try this instead...
=IF(AND([Latest Claim Status]@row = "Denied", [Claim Denial]@row <> "", [To Date]@row <> "", [From Date]@row <> ""), "Complete", "Missing")
Answers
-
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... :(
-
Try this instead...
=IF(AND([Latest Claim Status]@row = "Denied", [Claim Denial]@row <> "", [To Date]@row <> "", [From Date]@row <> ""), "Complete", "Missing")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!