Hi all,
I have a enum column for the status of ticket, the values of this column is including “completed”, “uncompleted”, and others.
One of my user meets with this problem: every time he changes the ticket status to “completed” and submit it, the ticket status is still “uncompleted” then.
Is there any possible reason to make this problem happen? And any ideas or suggestions?
Thank you.
Does you status column have a Valid If expression? An Initial value expression? Is Reset on edit set to ON?
Yes this column have valid if expression, and the initial value is “uncompleted”, but the Reset on edit is OFF
What is the Valid If expression?
Hi Steve,
thank you for reply. The Valid If expression is as below
if(AND([Ticket_Type]="Maintenance",LOOKUP(USEREMAIL(), "Members", "Email", "Role")="Member"),LIST("Uncompleted","Retrieve scooter","Check done","Processing","Maintenance done","Block"),if([Ticket_Type]="Maintenance",LIST("Uncompleted","Retrieve scooter","Check done","Processing","Maintenance done","Completed","Block"),LIST("Uncompleted","Processing","Block","Completed")))
But in the situation I mentioned before, the ticket type is not Maintenance.
Hmmm… The Valid If expression looks fine, for the most part.
Are you using any actions or workflows that interact with this table?