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,
Thanks for your reply @ScottWorld ! I was afraid hearing that… But I wonder why there isn’t such a feature in Airtable. It seems really easy to implement and I can see plenty use-cases, especially in terms of prioritization which is so important in many cases.
So, how people use Airtable for prioritization? Do they use features such as ‘stars’ or a predefined field with selection of priority levels? This always leads to same problem, that we do decisions having couple of tasks which are rated exactly the same…
Yes, either of those ideas could work, but there will likely be duplicates as you said.
You could also use a number field that displays decimal points, so you could have more fine-tune precision over the prioritization of your tasks. In other words, you could prioritize your tasks with numbers like this: 1.00, 1.01, 1.10, 1.11, 1.20, 1.21, 1.25, 1.30, 1.37, 1.40, 1.50, 1.60, etc.
Although, once again, if people are manually typing in their own values, you would need to figure out how to prevent duplicates.
There are literally hundreds (probably thousands) of features that have never made it into Airtable that many of us would love to see. You could email them at firstname.lastname@example.org to request this feature, but I have never yet seen them implement any feature requests from their users — and many of these feature requests are even more critical than the one you are talking about. Airtable does not have a very good culture of “delighting their customers”.
I believe that Asana offers this capability. And if you still wanted to use Airtable in addition to using another platform like Asana, you could always sync your data between the two platforms.
I have a few of my clients syncing their data between Asana & Airtable using my favorite automation tool Integromat: