Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

What is wrong with my formula guys?

Topic Labels: Formulas
292 1
cancel
Showing results for 
Search instead for 
Did you mean: 

if (
{revenus ou dépense}=‘revenu’, LEFT({catégorie}, 5), {revenus ou dépense}
)

i want my key field to display different things according to what is written in another field

thanks girls and guys in advance

1 Reply 1

Perhaps it’s the space between if and the first parenthesis? Make sure you have it formatted properly, like this:

IF(
   {revenus ou dépense}=‘revenu’,
   LEFT({catégorie}, 5),
   {revenus ou dépense}
)