Numerical "Priority" Method

Jess Bowles

Hello,

I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column becomes blank. I don't think this would be possible without using many columns to determine what needs to be changed, so I came here to see if anyone has a better way to complete this.

Thank you for your time.

Paul Newcome

Insert an auto-number column (I called mine "Auto" in this example) with no special formatting.

Then the formula to output the adjusted priority is along the lines of...

=IF([Submitted Priority]@row <> "", COUNTIFS([Submitted Priority]:[Submitted Priority], @cell < [Submitted Priority]@row) + COUNTIFS([Submitted Priority]:[Submitted Priority], @cell = [Submitted Priority]@row, Auto:Auto, @cell >= [email protected]))

Paul Newcome

Insert an auto-number column (I called mine "Auto" in this example) with no special formatting.

Then the formula to output the adjusted priority is along the lines of...

=IF([Submitted Priority]@row <> "", COUNTIFS([Submitted Priority]:[Submitted Priority], @cell < [Submitted Priority]@row) + COUNTIFS([Submitted Priority]:[Submitted Priority], @cell = [Submitted Priority]@row, Auto:Auto, @cell >= [email protected]))

Jess Bowles

https://community.smartsheet.com/discussion/comment/330064#Comment_330064

Paul,

Thank you so much! This is working perfectly.

Paul Newcome

Happy to help. 👍️