I am efficient in Excel, but for the life of my can not figure out how to do basic functions in this.
I am making a form for CCTV salesmen to fill out. Each channel has a selection of different type of cameras they can assign to it. Example:
CH01
CH02
I want the formula to say something like this...
Containing(${Accounts.CH01},'Indoor Dome'),
(${Accounts.CH02},'Indoor Dome')... = Total number of 'Indoor Dome' picklist options. How can I achieve this please?