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

Nikolaj

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

Andrée Starå

Hi @Nikolaj

I hope you're well and safe!

Try something like this.

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

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Nikolaj

It works!

Thank you so much :-)

Best regards,

Nikolaj

Andrée Starå

Hi @Nikolaj

I hope you're well and safe!

Try something like this.

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

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Nikolaj

It works!

Thank you so much :-)

Best regards,

Nikolaj

Andrée Starå

@Nikolaj

Excellent!

Happy to help!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!