I want to create a feature that compares two number columns and, if the values differ, sets a status column to “Discrepancy” and moves the item to a Discrepancies group. Can this be done using Monday.com’s native system?
For example, if the “Current Count” and “Future Count” columns are unequal, the subitem’s status should change to “Discrepancy,” the parent item’s status should also update to “Discrepancy,” and the item should move to the Discrepancies group.
