Orderby in Valid If removes option to add new, is there another way?

[ZOCO_Unlimited]

I need to be able to order the dropdown as well as have the option to add a new record. Is there a work around for this or another area that I can order it by?

Valid If ORDERBY(Customer Contacts[Name],[Active],true,[Last Used],true,[Name],false)

Once the Ordered by is removed, the New Option returns

[Suvrutt_Gurjar]

Instead of Valid_If, you could try the same expression in the “Suggested Values” setting for a soft constraint. It will allow the user to add new values as well.

Configure suggested values for a column - AppSheet Help

[ZOCO_Unlimited]

This worked perfectly! Thank you so much!

[Suvrutt_Gurjar]

You are welcome.