I’m currently migrating from using google sheets to Airtable, I have a majority of my formulas working, however, I need assistance with this:
=IFS(A2>1000001,A254%,A2>=400001,A251%,A2>=200001,A247%,A2>=100001,A242%,A2>=80001,A237%,A2>=60001,A234%,A2...
Thanks for the feedback and guess what? It works, this is the formula in effect:
IF({Deal : Automated Value} > 1000001,
{Deal : Automated Value} * 0.54,
IF({Deal : Automated Value} > 400001,
{Deal : Automated Value} * 0.51,
IF({Deal : Automated Value...
