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
Oct 20, 2020 04:24 PM
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
Oct 20, 2020 04:48 PM
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}
)