Forum Discussion
Custom column when data fields are used differently
Hey there, We have 2 vendors who managed cases in our tool. Vendor A actively uses a " case completed" field that indicated weather a case was completed or not ("yes": completed, "no": not comple...
gittelena , My advice would be to add a new column like this, in the table and then you have same status every where
new status =
switch( True(),
[status] in {"case completed","Yes"}, "Yes",
[status] in {"not completed","Yes"}, "No",
"No"
)