IF formula contains "XXXX" text will result Yes / No

[Anonymous]

Hi All,

Im looking for a formula that will help search a parameter for text in name and return yes or no,

Basically the name of the clash contains its status I need a formula to find its status and respond yes or no

Thanks and is this possible?

[lucdoucet_msdl]

@Anonymous 

Unfortunately, Revit does not support text operators in formulas.

https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/CloudHelp/cloudhelp/2014/EN...

-luc

[martijn_pater]

Not possible directly. You can only do it the other way around, so you could check these on/off parameters for active/new/resolved/reviewed and then have it display a certain text based on that. Probably using Dynamo you could do it though...

[barthbradley]

What determines New, Active and Resolved?  There might be another approach.  

[Secttor]

Hi @Anonymous 

My solution would be like this. Use an integer parameter ("Condition") in order to intermediate. It's value 1 or else will be set in the rfa types based on your needs.