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 resources are assigned (again using the search).
But its not working (airtable accepts the syntax, but returns an #ERROR… Just a syntax/equation error, or am I totally off in how to do this? Other suggestions? I am out of automations, and writing advanced code for apps is beyond me…
Thanks for the help!!