Hello,
I'm fairly new to smartsheets and trying to solve a roadblock.
I'm trying to count the amount of times a specific string is in a cell with two types of status: closed and submitted.
I'm using the FIND because some cells contain more than one ticket # (i.e. "Ticket-432, Ticket 12435")
=COUNTIFS({Database Range 1}, FIND("Ticket-12345", @cell) > 0) + =COUNTIFS({Database Range 2}, "Closed") + =COUNTIFS({Database Range 2}, "Submitted")
Much help is appreciated!