Condensed Logic in the formula colum

Platform discussions Special workflows & use cases
,
1

Hey Community,

I am trying to figure out Monday.com’s logic functions and was wondering if anyone had some ideas of how I might condense down the following into monday’s format.

I wish to condense 4 colums into one by using an if statement but im not sure how to add multiple variables to the if statement.

I am used to writing something like this in the following order.

IF{ItemVariable} = {“Label A”} or {“Label B”}:
print(number C * number D)
Else:
Print(“Non compliant Label”)

However I’m not to sure how I can tell monday to check multiple item variables. Guessing there isn’t a way to check through a list of item variables.

Any help would be greatly appreciated.:grin:

2

Hey @B.Hales I’d recommend checking out the monday AI formula builder to help you with this. You can describe the formula you’re trying to build and it’ll create it in monday.com logic. I demonstrate it in the video HERE at the 15:49 mark

1 Like
3

@B.Hales as mondaymaster said, AI is your friend.

I find the chatGPT better at getting formulas though, so try this customGPT tailored for monday here

Just paste your query, and it should come out with what you need!

Thanks,

Kofi

1 Like