DeanZ
(Dean Zoyes)
January 29, 2025, 7:20pm
1
Having issues with a LEN formula, and I am stuck as to why it works but returns with an error if left blank. Is there another way to write this formula so if the field is blank it won’t error out?
ROUNDUP(IF(LEN({Trip Credit Recipient}) < 3, “N/A”, {Sale Price} / 2),0)
Sale price is divided by 2 to get the student his/her Trip Credit amount.
Thanks in advance.
dmccarthy22710
(Desiree McCarthy | Monday.com Ambassador)
January 29, 2025, 8:31pm
2
Try this IF(LEN({Trip Credit Recipient}) = 0, “Not Needed”, IF(AND(LEN({Trip Credit Recipient}) > 0, LEN({Trip Credit Recipient}) < 3), “N/A”, {Sale Price} / 2))
Change Not Needed to whatever you’d like it to show if the trip recipient is blank
DeanZ
(Dean Zoyes)
January 29, 2025, 10:06pm
3
To be clear, I would rather not add a column, as I already have too many columns to indicate action as it is.
DeanZ
(Dean Zoyes)
January 30, 2025, 7:47pm
4
Desiree McCarthy | Monday.com Ambassador:
IF(LEN({Trip Credit Recipient}) = 0, “Not Needed”, IF(AND(LEN({Trip Credit Recipient}) > 0, LEN({Trip Credit Recipient}) < 3), “N/A”, {Sale Price} / 2))
Desiree, thanks for chiming in, however, when I plugged that in it did not seem to work, and I am not sure how to trouble shoot it. Any thoughts?
dmccarthy22710
(Desiree McCarthy | Monday.com Ambassador)
January 30, 2025, 8:04pm
5
Are your columns named exactly the same?
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
January 31, 2025, 1:59pm
6
Hi @DeanZ ,
Try:
IF(LEN({Tip Credit Recipient})<3,"N/A",ROUNDUP({Sale Price}/2,0))
What if we could break free of the Formula column? and write formulas that update any type of columns? What if a formula could update multiple columns at once? This is possible with the Advanced Formula Booster app.