Issue with IF Formula - Illegal Formula Error

Platform discussions
, ,
1

Hello everyone,

I’m encountering an issue with a formula on Monday and would appreciate any assistance or insights you might have.

I am trying to use the following formula to check if a date is within a specific month (July) and if another column (“Custo”) has a specific value (“SEDE”):

IF(FORMAT_DATE({Data}, “MMM”) = “jul” AND {Custo} = “SEDE”, 1, “”)

However, I am getting an “illegal formula” error when trying to use it.

Has anyone else faced a similar issue or knows what might be causing this error? Any help on how to properly structure this formula would be greatly appreciated.

Thank you in advance!

Best regards, Klarc Almeida

1 Like
2

Hi Klarc,

Give this one a try. It will return either ‘true’ or ‘false’:

AND(FORMAT_DATE({Data},“MMM”)=“Jul”,{Custo}=“SEDE”)

Aternatively, if you’d like it to return 1 or 0, you could use this one:

IF((AND(FORMAT_DATE({Data},“MMM”)=“Jul”,{Custo}=“SEDE”))=TRUE,1,0)

Hope this works for you!

2 Likes
3

Hi @KlarcAP ,

You can try the following formula:

IF(AND(FORMAT_DATE({Data},“MMM”)=“Jul”,{Custo}=“SEDE”),1," ")

I hope it will resolve the error.

Thank you
Anjanesh Vaidya
Ignatiuz software

2 Likes
5

Hi! For me the options above did not work, but you maybe could try this one:

IF(AND(MONTH({Data})=7,{Custo}=“SEDE”),1," ")

Best regards!

6

Thanks Jose! This works for me

1 Like