Help

Re: Custom Formula Help

1053 1
cancel
Showing results for 
Search instead for 
Did you mean: 
v1_oh_n0
5 - Automation Enthusiast
5 - Automation Enthusiast

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?

2 Replies 2

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

Screenshot 2023-03-26 at 5.29.51 PM.png

Having a problem accepting

LOWER(Name)

 What should "name" be?