How do I count a fixed text and unique number in the same cell?

I have a sheet that counts if there is anything in a cell, however to the possibility of a incorrect entry I would like a formula to count if the word Jira is found in the column and if there is a number in the same cell which will be unique in every cell.

=countifs({Range}, "Jira") works for the text how can I also identify that there is a unique number in the same cell.

For Instance

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!