我有一个列表,当用户在列中选择特定状态时,我想写一个验证,它验证他们在另一列中设置了日期。
这是我所拥有的,但是会引发错误:
= IF(AND([[Scheduled Status] =“ Delivery Scheduled”,ISBLANK([Scheduled Date])='Yes')
还尝试为可能具有多种状态的另一列编写相同类型的验证:
= IF(AND([计划提货状态] =“商店提货”,ISBLANK([计划提货开始时间日期])> Today()和ISBLANK([计划提货结束时间日期])> Today()AND([计划提货状态] =“仓库提货”,ISBLANK([预定提货开始时间]]> Today())和ISBLANK([预定提货结束时间]]> Today())
ISBLANK不应满足布尔条件。
AND(CONDITION1,CONDITION2,CONDITION3)
示例演示:
=IF([Scheduled PickUp Status]="Store Pickup",AND([Scheduled Pickup Start Time Date])>Today(),[Scheduled Pickup End Time Date])>Today()),IF([Scheduled PickUp Status]="Warehouse Pickup"),AND([Scheduled Pickup Start Time Date])>Today(),[Scheduled Pickup End Time Date])>Today()),TRUE)