Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, i am using this formula to count the text. The issue is that in data column "status" i have : Performed and Performed Late. the formula is counting both( performed late and performed). How count only performed. Thank you
sum( if( SubStringCount( Status, 'Performed'),1,0) )
Does the status column contain "Performed" by itself? Can you just do:
sum( if( Status = 'Performed',1,0) )
-Rob
Does the status column contain "Performed" by itself? Can you just do:
sum( if( Status = 'Performed',1,0) )
-Rob