This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.
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 🙂
Check out the new SWITCH function. This can help cleaning up some nested IF type statements.