Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have been attempting to count 2 features on a table that is filtering through multiple features and each time, it gives me the entire count of features rather than the 2 specific ones.
I need to count 'To Do' and 'Not Started'. What am I doing wrong?
count(if(match([Feature Status], 'In Design', 'Development', 'Read for Test', 'Not Stated', 'To Do'),
if([Feature Status]= 'To Do', 1)
+
if([Feature Status]= 'Not Started', 1)))
I'm not entirely sure what you're trying to achieve here, but if I read this correctly, perhaps:
Count( {< [Feature Status] = {'To Do','Not Started'} >} [Feature Status])
This is perfect! Thank you. Definitely over complicated that one