I’ve searched the forum and tried to figure the formula out on my own but I’m not even sure if this is possible in Airtable. Any help would be appreciated. I have multiple columns where entries are either numbers or blank. I’d like to be able to generate a phrase that puts all these numbers and field names together as text.
xfieldname is the name of the column. All cells in the column are numbers or blank.
xvalue is the number in the column.
Final field is text
If xvalue > 0, return “xvalue xfieldname”
If not, return blank
binsert comma]
If yvalue > 0, return “yvalue yfieldname”
If not, return blank
Final output is:
xvalue xfieldname, yvalue yfieldname
I’ve tried:
IF({Set of Pins}>0, “{Set of Pins} set of pins”, “”)
Which of course produced “{Set of Pins} set of pins” instead of the actual number in the column.
Example:
If the “pairs of socks” column has “2”, the “hats” column has “3”, and the “set of pins” column is blank, the final output is:
2 pairs of socks, 3 hats