Hello Airtable Community,
I am new to Airtable and I am struggling with a simple CONCATENATE formula:
The DESIRED RESULT column is what I am trying to achieve.
You can see that anytime I try to add “" as separators, but if one of the cells is blank then not to have the "” in it’s place.
I tried this formula:
CONCATENATE(CompName,"_", Length,"_", Dimensions,"_", Date,"_", Code)
Not sure if CONCATENATE is the right solve.
I have been able to do this in Google Sheets with this formula:
=JOIN("_",FILTER(B2:F2,B2:F2<>""))
Been racking my brain for a whole week on this. I appreciate any help or guidance.