Comparing multi-select items to completed tasks
I have a process where we have a number of multiselect items (Resources) in one column that indicate the need to score each of them in a different table. Each of those tables has a checkbox when they are done (Completed).
I’d like to write an equation that looks for an item in the Resource Column, and then looks at Completed checkbox, and returns a true/false statement on the task. So if an item has three Resources and two checkbox completed, it would return a “Needs to be Done” for the one that is not complete.
I would run these sequentially on all five Resources. I think each chunk could look like:
IF(
SEARCH(‘Riparian’, {Resource Type(s)})>0,
AND(
SEARCH(‘Riparian’, {Resource Type(s)}>0,{ :heavy_check_mark: RB Score Drafted}),
" RB Done", “RB Not Done”
)
)
This would search for the resource name in the multi select field, if greater than 0 its there, and therefore needs to return a Completed Checkbox to be true. The IF statement would just keep it from occurring if not r
