I am making sequencial task management app. This app has four columns
Unique ID: Unique ID
Thing: Name of tasks
Next: Names of tasks I shoud do next
Previous: Names of tasks I shoud do Previous
I made Next and Previous columns as Enumlist and refer the "Thing" column of this sheet.
For example, I have two things "First" and "Second", and when I select "Second" at Next column of "First" row, I want to add "First" row at Previous column of "Second" row. Is it possible to refer Enumlist eath other?
Yes you can but if it is sequential, there should only be 1 Next and only 1 Previous. You probably do not want to use EnumList as the definition for these columns. instead just define them as REF. Then implement the Valid_If expression for each to provide the desired dropdown list of Tasks.
Additionally, each Task can only be assigned ONCE as Previous and ONCE as Next, so you can refine your dropdown list expressions to remove any Task already assigned - in Previous column Valid_If would remove the current Task AND any other Tasks already assigned as Previous, same for Next column.
I hope this helps!!
Thank you so much. I try it. I might ask again.
User | Count |
---|---|
27 | |
26 | |
23 | |
22 | |
15 |