I’m trying to create a formula to do “high to low” and “low to high” features on our website. It is not working right. I wanted to show just the cheapest if there are multiple rooms available in a property but it does not work right. Here’s the formu...

I have 4 sets of formulas. SUBSTITUTE({Status}, “Floater Membership”, “Available”) SUBSTITUTE({Status}, “Pending Lease”, “Available”) SUBSTITUTE({Status},“Pending Payment”,“Available”) SUBSTITUTE({Status}, “Floater Membership”, “Available”) We wanted...