Scenario: I have a Gainsight Object with below fields and data. I am now trying to run a rule on this object to update the column E “Modified Date”
I have created a rule to update column E with below conditions:
1. If column D is TRUE, update column E with the values from column A (Run Date)
2. If column D is FALSE, update column E with the last updated value from Column E
Issue Observed for scenario 2 (when column D is FALSE):
When the rule is executed sequentially for each ‘Run date’ in filters (eg. 1/04/2025), the column E5 updated as expected. But when I do not choose the the filters for ‘Run Date’ the rule fails to update all cells E5 to E12.
Question:
Is there a way to have circular references in the same rule, where I am updating a cell in column E and also using that value as a reference to update succeeding cells.
Here is how the logic should work:
In this example I update cell E5 as 1/03/2025.
I would then want the E6 to be updated as 1/03/2025, considering D6 is False and E5 is now updated as 1/03/2025.
Final Expected Result:
