Hi guys - I am new to the forum but wanted to really just share my latest achievement. Case is that I have 6 sales managers that need to all vote if a task is with a certain priority (Low, Normal, Urgent). So what I did is that I created 3 different Voting columns, then created another column for Priority and used a formula based on the count of the votes to give at the end the result of the voting. You can see in the screenshot how it looks. Also here is the formula I used: IF(and({Urgent#Count}>={Normal#Count},{Urgent#Count}>={Low#Count}),“Urgent”,IF(and({Normal#Count}>{Urgent#Count},{Normal#Count}>={Low#Count}),“Normal”,IF(and({Low#Count}>{Urgent#Count},{Low#Count}>{Normal#Count}),“Low”)))
The only thing I couldn’t do is limit the selection to one column only as now they can duplicate their vote by mistake and vote for example for Low and Urgent at the same time. If anyone can help with that would be greatly appreciated. Or if you can share your approach on such a request.
