FIND returns INVALID DATA TYPE

I have a formula to look for a specific quarter in a field

Example of data in the field: "Q1;#1;#Q2;#2;#Q3;#3;#Q4;#4"

My Formula: =IF(FIND("Q2", JOIN([Estimated Quarter]@row)), 1)


If my search string is at the beginning of that field, it returns a 1 just fine, if say "Q2" is anywhere after the first character it returns #INVALID DATA TYPE.


Could the ; or # characters in my search field be causing the issue?


Thanks in advance!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!