How to automatically copy the approved documents into another grid or sheet?
I have a grid or sheet where the rows which document status is already "SPC-approved" need to copy or populate to another sheet called "Approved Docs". Is there a way where this Approved-Docs sheet can automatically copy or get those rows with "SPC-approved"?
Please lead me to an idea like formulas, automation workflow, etc.
Help Article Resources
Check out the Formula Handbook template!