My data source is a google sheet with multiple tabs, each tab has a table which has its own slice, all the tables contain a column called “Next Area”. This column is a Enum type, a user would choose the next area that the product will go to, and this is displayed in the deck.
The issue is that this change only is shown in one slice, so if the product is in another slice this information is not shown. I need to be able to update this column in every sheet once it has changed in one slice so we know where the product is.
I tried to use an action however this doesn’t update the location automatically (i.e. without user intervention). Is there a way to do it?
User | Count |
---|---|
18 | |
11 | |
7 | |
3 | |
2 |