Countifs with find

TdeGroh
TdeGroh
edited 12/09/19 in Smartsheet Basics

I have 2 columns  (Stage) and (Courses) Courses is a multi dropdown, stage is a single drop down. 



I want to count how many people are invited to Fundamentals 1 vs how many have completed or certified in a rollup sheet. I am either getting unparsable or invalid 

 

This is on a rollup sheet that points to the working sheet. 

=COUNTIFS({Splunk Training course}, FIND("Fundamentals 1", @cell) > 0, {Splunk Training Stage}(Invited))



Thanks in advance. 

Comments