Skip to main content

Implement the IFS function, like in Google Sheets

  • September 10, 2023
  • 1 reply
  • 5 views

Karl_at_Easy_La
Forum|alt.badge.img+15

This is very useful for multiple nested conditions, and is basically a string of multiple IF-conditions, with the 'ELSE" condition being another IF.  

The google sheets documentation for the IFS function clearly explains this.  

It would be very helpful to make long nested formulas much more readable! Thanks for the great work with Airtable 🙂

1 reply

jcervantes11
Forum|alt.badge.img+10
  • Known Participant
  • September 25, 2023

Check out the new SWITCH function. This can help cleaning up some nested IF type statements. 

https://support.airtable.com/docs/an-alternative-to-if-statements-using-switch