Custom Formula Help

+4

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?

+31

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}
)

Adam, Airtable Consultant - thetimesaving.company

+4

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