
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 14, 2022 08:23 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Jan 15, 2022 03:41 AM
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().
