1.我在带有验证的列表的下面各列
1. I have below columns in a list with validations
如果审核状态=入围(WIP),则日期2不能为空
If Review status = Shortlisted (WIP), Date 2 cannot be blank
如果评论状态=收益确认,日期3不能为空
If Review status =Benefit validation, Date 3 cannot be blank
如果发布日期不应该是过去的日期,并且不能在今天之后的90天之内
If Release date should not be past date and cannot be >90 days from today date
如果审核状态" =效益验证",则项目类型不应为空
If Review status = Benefit validation, Project type should not be blank
如果审核状态=保留,发布日期不能为空
If Review status = On hold, Release date should not be blank
如果审核状态"为入围在制品",则项目类型不能为空
If Review status = Shortlisted WIP, Project type should not be blank
如果审核状态=外部技术,则项目类型不能为空
If Review status = External Tech, Project type should not be blank
如果审核状态"为入围在制品",则项目类型不能为空
If Review status = Shortlisted WIP, Project type should not be blank
如果通过=附加体积来保存实现,则为Addl.每年的数量不能为空
If Saving realization by =Additional volume,Addl. volume annually should not be blank
如果通过FTE运动来保存实现,否.的人不应该是空白
If Saving realization by = FTE movement,No. of people moved should not be blank
如果关闭月份<>空白,好处不应该空白
If closure month <> blank, benefit should not be blank
我有以下公式,其中粗体步骤无效,其余步骤均有效,有人可以帮忙解决此问题吗?
I've the below formula of which the bold steps are not working and the rest are working, can someone help to fix it?
= IF([评论状态] =入围(WIP)",IF([日期2],"TRUE,FALSE),TRUE = IF([评论状态] =" ; Benefit Validation",IF([Date 3]","TRUE,FALSE),TRUE = IF([发布日期]",IF(DATEDIF(TODAY()), [释放 日期],"D")<= 90,是,否,是,否= IF([审查状态] =受益确认",如果是([项目类型]< ;,",是, FALSE),TRUE = IF([评论状态] =保留",IF([发布日期]<",TRUE,FALSE),TRUE = IF([评论 状态] =入围(WIP)",IF([项目类型]",,TRUE,FALSE),TRUE = IF([审阅状态] =入围-内部技术",IF ([Project type]",TRUE,FALSE),TRUE = IF([Review Status] ="Shortlisted-External Tech",IF([Project 类型]"",TRUE,FALSE),TRUE = IF([评论状态] =已完成",IF([Closure Month]"",TRUE,FALSE), TRUE = IF([节省实现] =其他数量",IF([每年增加数量]",TRUE,FALSE),TRUE = IF([节省 通过] ="FTE运动"实现,IF([移动的人数]","TRUE,FALSE",TRUE ))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))) /p>
=IF([Review Status]="Shortlisted (WIP)",IF([Date 2]<>"",TRUE,FALSE),TRUE=IF([Review Status]="Benefit Validation",IF([Date 3]<>"",TRUE,FALSE),TRUE=IF([Release date]<>"",IF(DATEDIF(TODAY(),[Release date],"D")<=90,TRUE,FALSE),TRUE=IF([Review Status]="Benefit Validation",IF([Project type]<>"",TRUE,FALSE),TRUE=IF([Review Status]="On Hold",IF([Release date]<>"",TRUE,FALSE),TRUE=IF([Review Status]="Shortlisted (WIP)",IF([Project type]<>"",TRUE,FALSE),TRUE=IF([Review Status]="Shortlisted - Internal Tech",IF([Project type]<>"",TRUE,FALSE),TRUE=IF([Review Status]="Shortlisted – External Tech",IF([Project type]<>"",TRUE,FALSE),TRUE=IF([Review Status]="Completed",IF([Closure Month]<>"",TRUE,FALSE),TRUE=IF([Saving realization by]="Additional volume",IF([Addl. volume annually]<>"",TRUE,FALSE),TRUE=IF([Saving realization by]="FTE movement",IF([No. of people moved]<>"",TRUE,FALSE),TRUE)))))))))))
推荐答案
= IF([评论状态] =入围(WIP)",IF([Date 2],TRUE,FALSE) ,TRUE = IF([评论状态] =福利验证",IF([日期 3]",TRUE,FALSE),TRUE = IF([发布日期]",IF(DATEDIF(TODAY(),[发布日期],"D") )< = 90,TRUE,FALSE),TRUE
=IF([Review Status]="Shortlisted (WIP)",IF([Date 2]<>"",TRUE,FALSE),TRUE=IF([Review Status]="Benefit Validation",IF([Date 3]<>"",TRUE,FALSE),TRUE=IF([Release date]<>"",IF(DATEDIF(TODAY(),[Release date],"D")<=90,TRUE,FALSE),TRUE
= IF([查看状态] =保留",IF([发布日期]<,TRUE,FALSE)
这些验证有效,并且
更多推荐
列表中的列基于另一个列条目不应为空
发布评论