Changing a field value based on shape text

[whwaldrep]

I'm doing alot of conditions in a flow chart.  I need to change a value if the shape text contains NOT CND.  here was the foumula I tried which works if the find word is in the text but gives error if missing I believe.

Code Select Expand

=IF(FIND("NOT CND",SHAPETEXT(TheText))=1,"0","1")

Thank you for your help.


EDIT*  I came up with this to use.

Code Select Expand

=GUARD(IF(STRSAME("NOT",LEFT(SHAPETEXT(TheText),3))="TRUE","0","1"))

[Visio Guy]

Thanks for sharing the solution whwaldrep! I'm glad you figured this out.

It is not so obvious that strings can't be directly compared in the ShapeSheet. It is really important to know about the STRSAME function.