Numerical "Priority" Method
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.
Help Article Resources
Check out the Formula Handbook template!