Looking for cross sheet reference help
I am likely making this harder on my self than need be.
My source sheet has data on it which I need, but my coordinator does not need.
I am looking for a formula to copy select columns from Source (Top Pic) to Coordinator Sheet (Bottom Pic) based on the value in the "Wave" column from the Source.
In this example, I do not want to include Wave OOS.
Also, it is important that if data is missing in Source, it reflects that accurately in the Coordinator Sheet.
I am very well versed in Excel, but this is my first time using SmartSheet. Please explain logic so I can learn rather than be a copy monkey
Help Article Resources
Check out the Formula Handbook template!