Showing progress visually in a Custom Field

My recent Forum Leader Tip on documenting your organization’s custom fields in Asana sparked some appreciation for that topic, but also about the individual custom fields I happened to show. So to answer questions, and at @Phil_Seeman’s request, here’s a post focused solely on my custom field to depict progress visually.

Here’s how the field looks in List view with a value:
image

And when editing the value:

Here’s how the custom field is defined:
image

To create this custom field for your own use, all you need are these two emojis, strategically placedd (copy and paste when defining your custom field): :black_medium_square::white_medium_square:

I deliberately used greyscale to avoid distraction from other key info (like the task’s title) and calling too much attention to theses values, which already are quite eye-catching.

A client ran with the idea and created a more striking version:
image

It’s defined like this:
image

The two emojis you need are: :green_square: :white_large_square:

Note that he made a few changes:

  • Reversed order of choices from complete to incomplete
  • Five boxes and six option values (vs my original four boxes and five option values)
  • Changed the field’s background color to green for only the fully-complete value

A case can be made for elements of both versions; you’re encouraged to mix and match to choose the features from each that you like best.

Be careful not to overuse a field like this. Remember that any additional custom field at the project level creates a burden to maintain the value for potentially every task in a project, so only use it where warranted.

I like to use it in Portfolios (at the project, not task level), and also in projects at the task level where tasks represent larger efforts, initiatives, or other projects (almost like a Portfolio does). This field is manually updated, so that’s another reason to be judicious in its use.

Thanks,

Larry

27 Likes

Excellent tip, @lpb! I agree with you about using greyscale to avoid distraction :heavy_check_mark:

1 Like

Well done @lpb

I will test this out. But mine os probably an overkille

Think i will limit this to 5.
Very helpfull for larger tasks

4 Likes

Thanks @lpb that’s very cool :rocket:

I had the same idea recently, but I love the % at the end :wink:

My simple version (that I will improve based on your post :slightly_smiling_face:) :
ezgif-1-f36b012416

2 Likes

Nice, @Arthur_BEGOU!

1 Like

How did you get the icons in, I only get this if I copy & paste:
black_medium_square::white_medium_square:

1 Like

Yes, @anon37918025, I just copy and paste or the shortcuts for Windows and Mac emoji pickers:

Larry

3 Likes

Thank you @lpb for sharing your knowledge. Love this idea! Emoji has tons of potential :star_struck:

1 Like

@lpb this is genius! I’d love to figure out a way to update this custom field with Rules!

5 Likes

Thank you for the idea. I will test it as well. :+1:t2:

1 Like

Well said.

1 Like

Thank you @lpb for this brilliant feature - where no coding is needed.

I have adapted this using 3 colors to get a narrower field. Width is a premium in asana columns.

  • Art

2 Likes

I like the visually appealing progress bar a lot but keep in mind that showing the progress in a number field (%) has its advantages. For example, you can show the average progress per section or use it for calculations in reports:

2 Likes

I agree, @Uli.Kisslinger, and another benefit of a number field is greater precision.

The main use of my tip is for when you need a more visual display, perhaps for better scannability.

Thanks,

Larry

With the Today input available in formulas, you can get an automated percentage of planned completion based on the duration between the start & due dates in relation to today, assuming that the planned progress is linear.

Have a look at point 3, here:

1 Like

It would be great to be able to display a numeric (not single-select) custom field as a progress bar, as in the native Progress field.

Anyone know if this is possible? If not can we add it to the roadmap?

Note that Steven Campos had the same feature request:

@Wells_Wulsin,

I found this request which corresponded to Steven’s so I merged his thread into it, and you can go there and vote for it with the purple Vote button:

Your earlier post here is slightly different (it’s not restricted to portfolios but rather a new kind of custom field). If you agree, I’d recommend you create a new request in Product Feedback and then vote on it. Note, though, that to display any numeric as a progress bar, you need an additional value specified: the total value (as opposed to just the current value). So I think you’d have to request either 1) a custom field shown as a bar where you specify two values, or 2) a percent custom field (only current value is required, not two values) that displays as a bar–this could be implemented as a special format of the existing custom field, I’d think, alongside “% Percent” perhaps as “% Percent as Progress Bar”

Thanks,

Larry

1 Like