This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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...
