Formula Criteria - IS ANY OF based on Multi-Select Dropdown
So I'm going to guess that the answer is no, but I'm going to hope the answer is yes.
We have a board that is used to help track hot or critical inbound items. The goal is to retrieve dates from our, lets call them 'Build Trackers', based on a series of criteria in order to help inform the priority and urgency of those items, and on the base level, that is easy enough. However, my current solution, while usable, is less than ideal.
* This is where my current formula lives. It uses the Priority Build field as the identifying criteria for looking up dates on the Build Trackers. However, it requires that people keep the field up to date as far as which Build currently has the highest priority.
I would love to find a way to be able to check the earliest date for each build and then take the earliest of those. Which brings me to wondering if there is an inverse to the HAS or CONTAINS functions, the multi-select dropdown is clearly aware of containing several distinct values, but I have no idea if it is possible to define a criteria in a formula as 'is any of the values contained'.
Help Article Resources
Check out the Formula Handbook template!