Reviving this question. I have the same issue where I’d like to check if a value lies between a min and max value of a list. Is anyone able to help figure out what’s causing the ‘invalid filter on {number field}’ issue?
Reviving this question. I have the same issue where I’d like to check if a value lies between a min and max value of a list. Is anyone able to help figure out what’s causing the ‘invalid filter on {number field}’ issue?
Welcome to the community, @Elisabeth_Schloemmer! :grinning_face_with_big_eyes: Could you describe your setup in greater detail? Screenshots would be very helpful (even if you have to mask out things for privacy).
Reviving this question. I have the same issue where I’d like to check if a value lies between a min and max value of a list. Is anyone able to help figure out what’s causing the ‘invalid filter on {number field}’ issue?
Hi, I figured this out. Can you share what you need and I’ll be happy to share the formula I used.
Hi, thank you so much for the quick replies! I’ve been able to solve the issue with changing the trigger. It now runs on “When record is created” and the first action is to “Find records”. That way the error didn’t occur again.
I’ll take notes for what information to submit in a post next time, I can see that wasn’t quite clear.
Axel_Meta, I’d still be curious about your solution, perhaps it will help someone else down the line too.
