根据日期计算Archer GRC中的状态 [英] Calculation for status in Archer GRC based on date

问题描述

尝试根据用户从中选择的多个值列表创建状态字段，但已经提出要求我们检查日期字段中的值以确保已设置估计日期，以便计算可以确定如果记录的状态为进行中"，延迟"或未开始".

Trying to create a status field based on a number of Value Lists that users select from, but a request has been made that we check a date field for a value to ensure an estimated date has been set so that the calculation can determine if the status of the record is "In Progress", "Late" or "Not Started".

推荐答案

您可以尝试在计算字段中使用ISEMPTY()函数来验证日期字段中是否包含值.然后，使用DATEDIF函数确定记录是迟到的还是进行中的.

You can try using the ISEMPTY() function within your calculated field to verify that the date field contains a value. Then, use the DATEDIF function to determine if record is late or in progress.

这篇关于根据日期计算Archer GRC中的状态的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！