Show value/price in "Price (from Room Details)" if the status is Available and Becoming Available

I am trying to add a formula that if the status is “Available” and “Becoming Available” in “General Listing Calculation” tab it will show the price from “Price (from Room Details)”. Not sure how to start.

I guess it will be like this IF({General Listing Calculation}= “Available”, {Price (from Room Details)}) but not sure how to add “Becoming Available” in the formula

What kind of field is Status? Anyway, I think your solution is to use OR(), like:

IF(OR({General Listing Calculation}= “Available”, {General Listing Calculation}= “Becoming Available”), {Price (from Room Details)})

Just adding the second value to the if condition with the OR().

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.