Help with "One of the parameters is invalid" Error

Platform discussions Special workflows & use cases
1

I have an IF function that is returning an invalid parameter and I can’t figure out why. The IF function works properly if I replace the positive and negative conditions with “1” and “0”, respectively, and the CONCATENATE functions work properly when they are isolated. However, the function as a whole does not work for the positive result. It only works properly for the negative result. Can anyone point me in the right direction? The logic works, so it has to be a monday formula eccentricity, I think.

IF({s/h $} = "TBD", CONCATENATE("$", {Qty} * {Unit $}, " + s/h"), CONCATENATE("$", {Qty} * {Unit $} + {s/h $}))

1 Like
2

What are the column types? ie #, status, etc?

Desiree - www.thecleverclovers.com

3

{s/h $} is text, {Qty} is number, and {Unit $} is number

1 Like
4

Try IF(
OR(TRIM(UPPER({s/h $}))=“TBD”, ISBLANK({s/h $})),
CONCATENATE(“$”, {Qty} * {Unit $}, " + s/h"),
CONCATENATE(“$”, {Qty} * {Unit $} + VALUE({s/h $}))
)

Desiree - www.thecleverclovers.com

5

I have an IF formula that keeps giving an invalid parameter error. Interestingly, it works if I use simple values like “1” and “0” instead of my CONCATENATE results. Also, the CONCATENATE functions work fine when tested alone. But when combined, the formula only works for the “false” outcome, not the “true” one. The logic seems correct, so I suspect it’s something quirky with how monday.com handles formulas. Can anyone help me figure this out?