
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 13, 2022 06:58 AM
Hello there!
I am brand new to Airtable formulas and was hoping to get some help. I’m attempting to calculate NPS just for this calendar year of 2022. I was able to calculate the NPS for all of my results but when I try to modify it to add in just for the year 2022 as an If/Then statement it doesn’t work. Here is what I have been attempting to use. Thank you so much for your help!
IF(
Date}=2022
)
THEN(
{NPS Score}=BLANK(),BLANK(),
IF({NPS Score} < 7,-100,
IF({NPS Score} > 8,100,
0)))
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 13, 2022 07:27 AM
THEN() is not a function in Airtable. IF()s look like this
IF(
condition,
value if true,
value if false
)
Your formula should probably be
IF(
{Date} = 2022,
IF(
{NPS Score} = BLANK(),
BLANK(),
IF(
{NPS Score} < 7,
-100,
IF(
{NPS Score} > 8,
100,
0
)
)
)
)
If {Date} is a full date instead of just a year then your formula should instead include YEAR({Date}) = 2022

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 13, 2022 07:27 AM
THEN() is not a function in Airtable. IF()s look like this
IF(
condition,
value if true,
value if false
)
Your formula should probably be
IF(
{Date} = 2022,
IF(
{NPS Score} = BLANK(),
BLANK(),
IF(
{NPS Score} < 7,
-100,
IF(
{NPS Score} > 8,
100,
0
)
)
)
)
If {Date} is a full date instead of just a year then your formula should instead include YEAR({Date}) = 2022

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 13, 2022 07:43 AM
Thank you SO much!!! It worked!
