Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

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

267 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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