Hi there! I have a project tracker where we’re tracking the development of certain articles on a website. I’ve used a “Calculate” field so that whenever a status is changed, the “Assigned To” field automatically changes to the person who is responsible for the next phase in the project.
Now what I want to do is create a “Hand Off” button column so that when someone is done with their task, they don’t have to go to the “Status” select column and look for the next status that should be used. Instead, all they have to do is click the “I’m Done!” button and it will automatically change the status to the next one in the line.
For example, if you look at the screenshot below, if the status is currently set to “Article in Editing,” when someone clicks the “I’m Done!” button, the status should change to the next one in line, which is “Article Ready for Review”.
How can I do that? I’ve seen it done in The Coda Guy’s docs, but I just don’t know what formula he’s using in the cycle button column.
See you got it working now. The “why” is because you seemed to use “=” to assign the value. Coda does not assign values in that way, but in the way you discovered.