I’m new here but already in love with Airtable. I need your help to solve my problem.
Here is the case. I’m Product Manager and I’m responsible for prioritization. I want to involve everyone in the company to this process, by giving them a possibility to set their priorities within their department.
To achieve that, I’d like to share with them their own table → which will be a sync table from my master table. This table includes every solution we’ve mapped so far.
Here is an example:
They can’t modify anything here, because it’s a sync table, but I would like them to set priorities. Nothing from among ratings (stars) or votes (number of votes) doesn’t work, because this way of prioritization results in the end that “everything is very urgent” or several of features are rated with same number of stars.
So I want them, to prioritize this table by dragging and dropping items on the list, from most important ones (at the top) to the less important ones (at the bottom). This way of prioritization means that nothing can be equally urgent. And this is obviously possible to achieve and I know how to do this in Airtable.
And now, the case is that I’d like to get the position of an item on the list, which basically is its row number.
Then I’d like to get this number to my master table, and repeat same thing with table assigned to each department.
So I can have all their priorities at one place and can take decisions having a helicopter view. Of course these aren’t only factors I’ll be taking into the consideration while prioritizing, but having clear view of what our departments need will be certainly helpful.
Could anyone please give me an advice how to approach this issue?
have a wonderful day everyone,