Refer Enumlist each other

[amufaamo]

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?

[WillowMobileSys]

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!!

[amufaamo]

Thank you so much. I try it. I might ask again.