Remove numbers if answer is text

Brucey

Hey Community,

The below spits out the answer : TBC60. As the milestone date is 'TBC'. Is there any way I could get SS to add nothing if the answer is text rather than a date?

Paul Newcome

You would leverage either the ISDATE or ISTEXT function similar to how you have used the ISBLANK function.

Brucey

@Paul Newcome Excellent idea thanks so much!

Paul Newcome

Happy to help. 👍️