Help with formula

Support
1

I would like the ADVERTISE (Y/N) field to automatically adjust according to the entry made and updated in the MARKET STATUS field. The market status field options are as follows:

FOR RENT
FOR SALE
RENTED
SOLD
OFF MARKET (For Rent)
OFF MARKET (For Sale)
Unknown

I would therefore like for the ADVERTISE (Y/N) field to show “Y” for the first two options listed above (FOR SALE or FOR RENT), and show “N” for all other options shown.

I am unsure what the formula in ADVERISE (Y/N) field would look like. You assistance please…
[link remove by support staff]

Thanks,

Kane

2

Hi Kane,

Let’s say your “Market Status” field locates in A1. Please try formulas below:

IF(OR(A1.RAW=“FOR RENT”,A1.RAW=“FOR SALE”),“Y”,“N”)

3

Thanks,

IF(OR(A14=‘FOR RENT’,A14=‘FOR SALE’),‘Y’,‘N’) worked!

4

哈囉~可能要將Kanefranco的表單網址屏蔽掉喔.
不然任何人進入此表單都可以編輯並儲存資料…可能會影響作者的資料庫…l o l!!

5

Hi,

謝謝您的提醒，已經協助移除 :slight_smile: