I'm working on doing to time automations for our company workflow. I've done this by setting up a number of commands that track the amount of time spent in the previous list when a card is moved out and then this populates in a custom field.
I am tracking this time spent in days as it makes it easy for us to take that data and convert it into an HH:mm format within google sheets.
I originally had the commands setup for minutes as opposed to days and that often showed a large number of decimal places (sometimes showing up to 10dp) when inputting the value, but had to change to days for the google sheets.
However, when running a few tests, I left a card in a column for 5 minutes (some of our milestones may take only 5-10 minutes), but when I moved the card out of the list, it set the {carddaysinpreviouslist} value to 0. It looks like days only tracks to 2 decimal places. Is there a way I can increase this, or do I have to revert back to minutes and then figure out a new conversion method in google sheets?
Appreciate any help
Hi @Tim Shanaher - I don't believe we currently have a way to return more decimal places for the `carddaysinpreviouslist` variable. What you can try is using the the `cardminutesinpreviouslistround` which will round the minutes to the nearest integer. Give that a try and let me know if that works for you or not.
The rounding feature can be applied to all variables dealing with a card's time: https://support.atlassian.com/trello/docs/butler-variables/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.