Sep 12, 2023 12:45 PM
Hi 🙂
I have a formula field "TASK" that checks if there is value in fields or not. It looks like this;
Solved! Go to Solution.
Sep 12, 2023 06:49 PM
Hi @Pjero_Kusijanov,
Is this formula not good?
IF(
AND(
{Fuel L}=BLANK(),
NOT(FIND("Fuel L",{CLEAR}))
),
CONCATENATE("• Add fuel tank", '\n')
)
Sep 12, 2023 06:49 PM
Hi @Pjero_Kusijanov,
Is this formula not good?
IF(
AND(
{Fuel L}=BLANK(),
NOT(FIND("Fuel L",{CLEAR}))
),
CONCATENATE("• Add fuel tank", '\n')
)
Sep 13, 2023 11:57 AM
Hi @Sho ,
This does the job. I have simply forgotten that I can use NOT to reverse logic.
Thank you for your help 🙂