Structure formula to calculate progress in percentage from Smart Checklist Progress custom field

[Lean Li]

Hi,

I'm trying to find a way to calculate (or show) progress as a percentage of the smart checklist items that are recorded to an issue. 

Smart Checklist Progress custom field has this kind of String values:

Custom field (Smart Checklist Progress)

2/5 - Done

3/3 - Done

1/2 - Done

8/9 - Done

Could anyone help me with the formula or syntax to use? Thank you already in advance!

[Olena Brazhko_TitanApps_ · Accepted solution]

Hi @Lean Li 

It's Olena from the Smart Checklist team here :) 

There are several ways to achieve what you are asking for.

Option 1: Using automation from Jira

1. Create a Number Field custom field with any name (example: Progress %)
2. Create the first automation rule:
   
   1. When the value changes for Smart Checklist Progress
      
      
   2. If Smart Checklist Progress contains DONE
   3. Then Edit field and choose the created custom field (Progress % in our example) and assign the value 100
      
      
3. Create a second automation rule:
   
   1. When the value changes for Smart Checklist Progress
   2. If Smart Checklist Progress does not contain DONE
   3. Then Edit field and choose the created custom field (Progress % in our example) and assign the value as below:

{{#=}} {{issue.customfield_10102.split("/").first.asNumber}} * 100 / {{issue.customfield_10102.split("/").last.asNumber}}{{/}}

It will display progress like this:

Option 2: Using Smart values

1. Create a Short Text custom field with any name (example: Progress %)
2. Create the first automation rule:
   
   1. When the value changes for Smart Checklist Progress
   2. If Smart Checklist Progress contains DONE
   3. Then Edit field and choose the created custom field (Progress % in our example) and assign the value 100%
3. Create a second automation rule:
   
   1. When value changes for Smart Checklist Progress
   2. If Smart Checklist Progress does not contain DONE
   3. Then Edit field and choose the created custom field (Progress % in our example) and assign the value as below:

{{#=}} {{issue.customfield_10102.split("/").first.asNumber}}*100 / {{issue.customfield_10102.split("/").last.asNumber}} {{/}}%

It will display like this:

I hope one of the options will suit your needs. If you have anything else you need help with -- be sure to let us know.

Kind regards,

Olena

[Lean Li]

Thank you for this answer! I could not get the JSON in your example to work, but with this minor tweak it is doing what I needed: 

{{#=}}{{issue.customfield_10102.split("/").first}}*100/{{issue.customfield_10102.split("/").last}}{{/}}

[Olena Brazhko_TitanApps_]

@Lean Li that's great to hear! We'll look into it on our side too, thank you for sharing!

[Ditte Simard]

Since Smart Checklist Progress is a custom field, you should be able to access its values in a Formula using any of the three methods described here: Retrieving Custom Field Values 

This formula is not exactly what you are looking for but I would recommend playing around with it and seeing if you can modify it to use your custom field: Custom Progress Bar  That would at least get you part of the logic you need to calculate % complete.

Good luck!

[Stepan Kholodov _Tempo_]

Hello @Lean Li 

There is no support for checklists in Structure's Formula at this time. If you would like to leave a feature request, please reach out to us directly at our support portal with more details, and we'll get back to you shortly.

Best regards,
Stepan
Tempo (the Structure app vendor)