Iterative Functionality (circular reference) in smartsheet.
I'm currently trying to find a way to do a simple iterative count using the automation tools in smartsheet. Simple iteration is one of the most basic tools in computer based problem solving, so it seems like a good feature to have built into automation tools.
The specific situation is that I want to track how long a card has been in a column in smartsheet. The card can move backwards and forwards multipe steps and any number of times, but the general flow should be from left to right and the final column is complete/done.
I am fine with the innacuracy of simply using the 11pm central time test (built in automation function) to see what column a given card is in, and I would like to add 1 to that columns day total within that card. There seems to be no way to do this, or do any sort of iteration, even by 1's in Smartsheet and the automation tools.
Does anybody know of a solution?