Why can't I see 'At Risk' column in sheet summary?

Arundhati

I set up a column 'At Risk' with a formula to flag the rows if the task is past due date and not complete. I am trying to create a dashboard, insert metric widget, sheet summary data and choose the 'At Risk' column but I don't see it. How can I fix this?

Andrée Starå

Hi @Arundhati

I hope you're well and safe!

You can't use the Sheet Summary option if the field for the metric isn't added to the Summary Section.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Arundhati

I hope you're well and safe!

You can't use the Sheet Summary option if the field for the metric isn't added to the Summary Section.

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Arundhati

Thanks! That took me down the right path. I tried to add a new field in Sheet Summary but it was not pulling the values I was looking for. I realized that I need to add a formula in the field to count the total.

Andrée Starå

@Arundhati

Excellent!

Happy to help!