Custom Formula Help | Airtable Community

Hello,

I am looking for a custom formula to help me solve the following.

Basically: If text in column A is true then add numbers in column B + 50 otherwise null.

If {inspection} contains "oil change" then add {engine hours} + 50.0

The problem I have is finding the correct way to prevent all engine hours having 50 added to it so I can determine when the next oil change is due.

Would this be possible?

Page 1 / 1

I'm not entirely sure what you're doing, but I used the following formula to get this result:

IF(


  FIND(


    "oil change",


    LOWER(Name)


  ),


  {Engine Hours} + 50,


  {Engine Hours}


)

I'm not entirely sure what you're doing, but I used the following formula to get this result:

IF(


  FIND(


    "oil change",


    LOWER(Name)


  ),


  {Engine Hours} + 50,


  {Engine Hours}


)

Having a problem accepting

LOWER(Name)

What should "name" be?

Sign up