Forumla help pls
I'm trying to create a dashboard or even a simple sheet that will pull data from my main sheet. Essentially I have a master sheet with Merchant info, Sales Person, Payment Status, and Application status(done or 1of 5 other statuses). I want to pull data from my main sheet so it's easier for the Sales team to quickly glance at the sheet to follow up with merchants that doesn't have a completed application. What would be the best formula to use if I want to pull from the main sheet to show the Application status? For example, Merchant A is assigned to Agent A, Payment status-(completed or collecting payment) but pending signature or one of the other selection.. let me know if that makes sense?
Help Article Resources
Check out the Formula Handbook template!