Mar 25, 2023 11:51 AM
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?
Mar 26, 2023 02:30 AM
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}
)
Mar 26, 2023 08:46 AM
Having a problem accepting
LOWER(Name)
What should "name" be?