Hi, if someone could help would be awesome!
I´ve got a [Status] column with 6 possible values (for example: A, B, C, D, E, F) and these values change, through actions, from A to B, B to C and so on…everytime a user clicks a button.
I´ve set 5 actions (of type:Data: execute an action on a set of rows):
Action 1 => Set these columns
Status => [Status] = “B”
**BEHAVIOR** only if this condition is true: [Status] = "A"
Action 2 => Set these columns
Status => [Status] = “C”
**BEHAVIOR** only if this condition is true: [Status] = "B"
… and so on…
I´ve started Monday and everything was working just fine, suddenly, since yesterday things are not ok because whenever i click one of those 5 action buttons the result is FALSE in the Status column of the googlesheet.
So, for example if i click action1 button in order to change the value from A to B, i get FALSE.