💡 Change column function

[Bastien_Siebman]

I completely missed this feature from several months ago!

In Asana, when you have number custom fields in a project, you get a nice sum of values displayed at the bottom of columns. Did you know you can actually choose other functions to replace the sum, for example average, max, min, count? I did not, this was my latest discovery

To change the function, just click on the arrow next to the column header and click on “Change column function”.

And no you can’t customize the function (yet?).

Version Française

[Christine_Bolton]

@Bastien_Siebman, this is an amazing find!

[Rebecca_McGrath]

Great find, @Bastien_Siebman! I’m ashamed to say even I missed this update

[Jackie_Clark1]

No I didn’t! Game changer. Thank you!

[Andrea_Mayer]

Hehe yes indeed very nice feature. Figured it out a view weeks ago and been using it since then. Very helpful

[Herve_Buisset]

Is there a way to disable the column function (per column)?

[Bastien_Siebman]

What about “Change column function > None”?

[Herve_Buisset]

Hi Bastien, seems logical, but I do not see that option. I may be looking in the wrong place ofcourse.

I feel

[Herve_Buisset]

@Bastien_Siebman never mind, got it. At top of the column, and I was looking at the bottom where you can also change the options …
Thx!

[Heidi_Magario]

This is great except have others had problems with changes to this setting not sticking? My column is of numbers that correspond to row numbers on a spreadsheet. Asana thinks I want to sum them when in fact I don’t need any summary at all. When I open the project and change to “none” the summary disappears but every time I click away from the project and then back to it, the sum feature is selected again. Thoughts?

[lpb]

Welcome, @Heidi_Magario,

Click the answer below to see a screen shot and the steps of how to preserve your change:

When in list view, I hide certain columns and it is removed from the view. However, it comes back on refresh/new session.

Welcome, @vishwar, Yes, just click the blue dot then “Save for everyone” after you make a change that you want to lock in and save. [image] Larry

Thanks,

Larry

[Heidi_Magario]

Thank you! I think I clicked every place except there. So when I make changes to tasks everyone sees the changes but if I make changes to … other things, I’ll see that blue dot show up indicating I need to save it for everyone?

[lpb]

Yes, that’s basically it.

Changing the content is visible to all immediately (in a second or two).

Changing the view (sorting, filtering, hiding/showing/reordering columns, etc.) is visible just to you and only so long as it’s active in your browser. If you’re changing the view for the purpose of setting the default for everyone, then lock it in.

Hope that makes sense!

Thanks,

Larry