I have a select list column in my table that I want to give options based on how many rows are in the table.
For example, if there are 2 rows in the table. I want the options for the list to be either “1” or “2”.
I have not had success with this so far.
This formula is the closest I have gotten but it still does not display the items as a list:
My use case is I for project management. I have a list of tasks, and based on the list of tasks, I want to calculate the order of priority. So if there are 10 tasks (rows), I want to be able to order each row 1-10 to determine a roadmap of the timeline that each task should be completed.