I have finished my workflow and now need to integrate two additional steps: a count function and a comment check.
This is my final output
| OrderID | Payment status - Comments |
| 147852 | Y |
| 236598 | - |
| 125478 | Advance Done |
| 857496 | Not Yet |
| 126987 | To be adjusted from Previous Pending |
| 987321 | Y |
| 129888 | Y |
| 852885 | Y |
| 963666 | Advance Done |
| 987447 | Not Yet |
| 652325 | No |
| 989971 | Y |
| 379514 | Y |
1) I have applied the filter to display all Fields containing a "Y " Is there a way to include a count check, which in this case is 6?
| OrderID | Payment status - Comments |
| 147852 | Y |
| 987321 | Y |
| 129888 | Y |
| 852885 | Y |
| 989971 | Y |
| 379514 | Y |
2) For any instances other than "Y," I would like to incorporate a check to verify comments - Like a Note - or sumthing to check comments
| OrderID | Payment status - Comments |
| 125478 | Advance Done |
| 857496 | Not Yet |
| 126987 | To be adjusted from Previous Pending |
| 963666 | Advance Done |
| 987447 | Not Yet |
| 652325 | No |
