Only show calendar text (Primary Column) if other column = X

Options

Hi,

I’ve got this Primary Column for publication in our calendar:

=([Event Title]@row + ", kl. " + Start@row + "-" + End@row + ", " + [Contact Name]@row)

I’d like to only show this if dropdown column ”Booking” has the value ”Verified”. If dropdown column "Booking" is anything else, I'd like the Primary Column to be empty. Basically, I need an ”IF” in the formula but I can’t get it right.

Is there a simple way to do this?

Thanks,

Nikolaj

Tags:

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!