Hello,
I have a excel file that needs to be imported to a table and be reflected with the updates from this on a dashboard. The excel file shows updated positions that are no longer active in white and the ones that are still active in green. See the screenshot.
As you can see there is no column that shows an active is true/false. This all needs to be reflective on a dashboard that shows only the active positions. Do I make a script? How do I pull this off?
Any script and all script help would be great. Thank you.
