Issue with Spreadsheet formula in Numbers formatter

[yumaheymans]

Hi,

I have an issue with using the number formatter by Pabbly.

The formula returns the formula as a result, instead of the result.

When I use the same formula in spreadsheets it does work.

See here the working formula that I used in the sheet:
=IF(C3="Freelancer", 1, IF(AND(C3="Agency", D3="1"), 1, IF(AND(C3="Agency", OR(D3="2 - 5", D3="5 - 25", D3="25 - 250", D3="250+")), 2, IF(AND(OR(C3="Startup/scaleup", C3="Enterprise", C3="Other"), OR(D3="1", D3="2 - 5", D3="5 - 25")), 1, IF(AND(OR(C3="Startup/scaleup", C3="Enterprise", C3="Other"), OR(D3="25 - 250", D3="250+")), 2, "")))))

 

[ArshilAhmad]

Hey @yumaheymans,

After conducting tests, we have confirmed that the Spreadsheet Formulas action event is functioning properly. I kindly request that you review your formula to identify the issue.

 

[yumaheymans]

Hey @yumaheymans,

After conducting tests, we have confirmed that the Spreadsheet Formulas action event is functioning properly. I kindly request that you review your formula to identify the issue.

Thanks but this is not really helpful yet.

What have you tested that worked? And what do you suggest I look into having shared the full details of my issue, which you can see in the screenshot?

 

[ArshilAhmad]

Hey @yumaheymans,

We were able to fix the issue by making a few changes to your formula, after which it is giving the correct response. Please note that while we are happy to assist you, it may not always be possible for us to fix complicated spreadsheet formulas.

IF("Enterprise"="Freelancer", 1, IF(AND("Enterprise"="Agency", "25 - 250"="1"), 1, IF(AND("Enterprise"="Agency", OR("25 - 250"="2-5", 25-250="5-25", "25 - 250"="25 - 250", "25- 250"="250+")), 2, IF(AND(OR("Enterprise"="Startup/scaleup", "Enterprise"="Enterprise", "Enterprise"="Other"), OR("25 - 250"="1", "25 - 250"="2-5", "25-250"="5-25")), 1, IF(AND(OR("Enterprise"="Startup/scaleup", "Enterprise"="Enterprise", "Enterprise"="Other"), OR("25 - 250"="25-250", "25 - 250"="250+")), 2, "")))))

 

[laradb]

Hi, I have the same issue with the Days formula, that is quite simple.

DAYS('5. Result : 01-03-2023','2. 0 Datetime : 30-06-2023 ')
Tt's returning the exact same query instead of the number of days.

Can you help?

Hey @yumaheymans,

We were able to fix the issue by making a few changes to your formula, after which it is giving the correct response. Please note that while we are happy to assist you, it may not always be possible for us to fix complicated spreadsheet formulas.

IF("Enterprise"="Freelancer", 1, IF(AND("Enterprise"="Agency", "25 - 250"="1"), 1, IF(AND("Enterprise"="Agency", OR("25 - 250"="2-5", 25-250="5-25", "25 - 250"="25 - 250", "25- 250"="250+")), 2, IF(AND(OR("Enterprise"="Startup/scaleup", "Enterprise"="Enterprise", "Enterprise"="Other"), OR("25 - 250"="1", "25 - 250"="2-5", "25-250"="5-25")), 1, IF(AND(OR("Enterprise"="Startup/scaleup", "Enterprise"="Enterprise", "Enterprise"="Other"), OR("25 - 250"="25-250", "25 - 250"="250+")), 2, "")))))

View attachment 25164

 

[ArshilAhmad]

Hi, I have the same issue with the Days formula, that is quite simple.

DAYS('5. Result : 01-03-2023','2. 0 Datetime : 30-06-2023 ')
Tt's returning the exact same query instead of the number of days.

Can you help?

Please change the format of your dates to MM/DD/YY and try again.

 

[laradb]

Please change the format of your dates to MM/DD/YY and try again.
View attachment 28001

Thank you, that worked!
One more small question: The Slack message is posted to the channel correctly, but the channel does not show that there is a new notification - so basically in the side bar there is not the typical signal of the channel being marked in bold since there is something new that was posted there.
Any idea how to get this to happen?

 

[ArshilAhmad]

That is just the way Slack's API handles notifications. I'm afraid we have no option to mark the channel in bold for new posts.