Sort the value in the 'reff' field

[SanyaCLAUS]

How can I sort the value in the 'reff' field? Or should i sort by "app scripts" inside the GoogleSheet?

How to hide dates that are, for example, "older" than today()/Now()?

[Joseph_Seddik · Accepted solution]

How can I sort the value in the 'reff' field? Or should i sort by "app scripts" inside the GoogleSheet?

Use ORDERBY() in the Suggested Values field.

How to hide dates that are, for example, "older" than today()/Now()?

---

Add a restriction in the Valid if field.