Skip to main content

Hello,

I want to create a dashboard where it shows the total average completion between the 'received' and 'completed' dates. Also, I need to set the prompt for 'action' items and the calculation needs to change according to the action selected. See my workbook attached.

 

Many thanks.

 

Amanda

4 answers
  1. Nov 30, 2020, 6:00 PM

    see the attached

    it this what you want?

    If this posts assists in resolving the question, please mark it as “Best Answer” or Upvote. 

    Also please help use better track your reply by including a mention to the volunteer who provided the answer  – mine is   @[Jim Dehner]​ 

    Thank you.

    Jim

0/9000