I don't know how to set up formula column properly

Hello to every one :wave:t2:

I need some help with setting up formula column.
I have a proper working one: ROUND(IF({Currency}=“₼”,DIVIDE({Amount},1.7),{Amount}),1)
The thing is I want to add date(numbers) from another formula column to this one :arrow_up:, yet when use “SUM function” it says that it creates a circular dependency. How can I fix it?
I would really appreciate if you could help me, guys :pray:

@faighajiyev

I’d be happy to help. Can you give us the other formula text and the name of both formula columns?

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas: the SECRET Functions

Hello Jim,

Thanks a lot for reaching out :blush:

I have another formula column on the same board, and i would like to calculate the sum of that column «NDS 18%» into the «Cost in $»

@faighajiyev

It’s still not clear to me where the circular dependency is occuring…

Please give me all the formulas as you think you want them in this format:
{NDS 18%} = ROUND(IF({Currency}=“₼”,DIVIDE({Amount},1.7),{Amount}),1)

The thing is I don’t know to add the sum of column “NDS 18%” into the column “Cost in $”
When I use this formula ROUND(SUM(IF({Currency}=“₼”,DIVIDE({Amount},1.7),{Amount}),1),{NDS 18%})
It creates a circular dependency. As you can see here I added “SUM” function here, yet I don’t know how to use the function “SUM” in this formula properly(

Screen Shot 2021-12-16 at 11.40.32.png

@faighajiyev

Ok, I suspect that the error message may be incorrect.

Here is how I would write it:

ROUND(IF({Currency}="₼", {Amount} / 1.7, {Amount}) + {NDS 18%}, 1)

If you really want to use the SUM() function, try this:

ROUND(SUM(IF({Currency}="₼", DIVIDE({Amount}, 1.7),{Amount}), {NDS 18%}), 1)

If you still get an error, I would double check the formula for NDS and make sure that it is not referencing your Cost in $ column.

Jim - Subscribe to The Monday Man
Watch Our Latest Video: monday Formulas: the SECRET Functions

1 Like

Hi @faighajiyev :wave:

Welcome to the Community!

Just wanted to check if you were still have issues with your formula here?
If so we’d be happy to continue to assist, although it looks like @JCorrell has got you covered here with some great suggestions :smiley:

Let us know if there’s anything we can help with!

Best,

Dani

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.