Any help would be great! I am trying to write a formula that looks at a specific column for the item and dependent on the data in the column will then output a prefix + data from another column in the same item. I am getting errors on it and after doing searches and playing with it, I am still not doing something right.
IF({Quote Type}=“Existing INS User”, “L”+{Deal ID}, IF({Quote Type}=“New INS User”, “Q”+{Deal ID}, IF({Quote Type}=“Transfer”, “T”+{Deal ID})))
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
2
Hi Tina,
The problem is with your use of +. You can’t use it with strings of characters. Use & instead.
Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.
Create formulas without using the Formula column (and avoid its limitations)
Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
In one formula, update multiple columns from multiple items.