Help

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

460 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jason_Bautista
4 - Data Explorer
4 - Data Explorer

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.
image

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

1 Reply 1

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().