仅当状态在另一个coloumn中完成时才填写一列 [英] One column to be filled only if the status is as completed in another coloumn

问题描述

我有两列：测试和结果列的状态。

（选择） - 测试的状态包含下拉菜单，例如：已完成，待处理，由于问题。

（选择） - 结果列仅包括已通过或失败。

因此，我想在结果列中进行验证仅在案件处于完成状态时才被选中。如果它处于任何其他状态，我不希望任何内容出现在结果列中。

状态=已完成，则结果应通过或失败

其他状态=空白/不应允许通过或未通过选择。

解决方案

您好

您可以使用计算字段作为结果，并在其设置中写入公式。

以下是一个示例。

 = IF（Status =" Completed"，" Passed"，""）

Hi,

I have two columns: Status of the test and result column.

(Choice) - The status of the test contains drop downs such as: completed, pending, due to issue.

(Choice) - Result column includes only passed or failed.

Therefore, I want to put a validation where result column will be selected only if the case was in completed status. If it is in any other statuses, I do not want anything to be in the results column.

Status= Completed, then Result should be Passed or Failed

Other statuses = Blank/should not allow passed or failed to be selected.

解决方案

Hi

You can use Calculated Field for Result, and write formula in its setting.

Here is a sample.

=IF(Status="Completed","Passed","")

这篇关于仅当状态在另一个coloumn中完成时才填写一列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！