My tables are as given below.
Table 1 Master Inspection details
Table 2 Child inspection where all checkpoints to be attended. The checkpoints are derived from another table.
Table 1 relates with Table 2.
Want my workflow on table 1 where defined checkpoints are attended. Therefore, create a virtual column “Inspection status” with below expression.
IF(COUNT(SELECT(Inspection Template[Checkpoint], [Fleet Type]= [_THISROW].[Fleet Type])) = [Questions Attended], “Completed”, “Incomplete”)
On workflow, in Update event “ALL_CHANGES” and Condition "[Inspection Status] = “Completed”.
But workflow is not working.
User | Count |
---|---|
36 | |
8 | |
3 | |
2 | |
2 |