I'm trying to update a row based on a condition.
Steps are:
1- find all rows in table equal to ko_deal id value added to the same table.
2- find row with process step = process step in added row - 1
3 - update this row's active stage end date
two problems:
1. I'm not able to build a calculation using process step. It's a number field, but is not accessible in the formula editor to create Process Step - 1
2. My condition doesn't seem to allow me to select the row that was found in the conditional statement. ie. the condition finds the correct row, and I want to complete the action based on that row. But it still asks me to input the row ID etc. so it's unclear whether it will perform the action on the correct row from the condition.