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 , 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
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(
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