Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

Need to Update Table on dashboard without active field

Primm
Tera Contributor

‎04-02-2024 12:47 PM

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. 

Primm_0-1712086818769.png

 

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.

0 Helpfuls
  • 451 Views
1 REPLY 1

SanjivMeher
Mega Patron

‎04-02-2024 12:58 PM

Add a column active to the sheet and then import the data.


Please mark this response as correct or helpful if it assisted you with your question.
0 Helpfuls