Using several conditions
I am trying to build several conditions into my Smartsheet, is there a limit as to how many we can have?
This is the conditions I need to have set:
GRAY - when renewal status column status are selected: Awaiting Information, Bound (Lead), Bound (Subscription), Broker Contacted, Cancelled, Extension, Lapsed, Lapsed - Final Notice, Lapsed - Pricing, Lapsed - Unknown, Lapsed - Broker Lost, Lapsed - LMA, Off Risk - Capacity, Off Risk - Claims, Off Risk - Declined Referral, Off Risk - Other (Remarks), Quoted, Retired
This is the formula I am trying to use. which also includes an expiry condition too.
Is this doable or is there another method I should be using to get the results I am looking for? Any assistance is greatly appreciated.