Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

If blank formula

Solved
Jump to Solution
382 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi community,
I need your help.

I have a concatened formula who find 2 result on 2 colums + text
I just want to add this condition : if you have 1 or 2 result missing, display a bank field.

This is the formula :
CONCATENATE("Diamètre : “,{Diamètre},” cm / ",“Hauteur : “,Hauteur,” cm”)

The 2 column : “Diamètre” and “Hauteur”

Thank’s for your help

Matthieu

1 Solution

Accepted Solutions
IF(
   AND({Diamètre}, {Hauteur}),
   CONCATENATE("Diamètre : ", {Diamètre}, " cm / ", "Hauteur : ", {Hauteur}, " cm")
)

See Solution in Thread

2 Replies 2
IF(
   AND({Diamètre}, {Hauteur}),
   CONCATENATE("Diamètre : ", {Diamètre}, " cm / ", "Hauteur : ", {Hauteur}, " cm")
)

thanks a lot Kamille