Help Required to Build Formulae for Metric from Data Entry Sheet
Dear Commuinity ,
I need the following output to be shown in the Metric Calculation Sheet as follows from the Data Entry Sheet Maintained by Procurment as follows
Awaiting response on the way forwards to get the Output
Answers
-
Hi @Denny V
Is the screen capture showing your current Data Entry Sheet, and you want to use formulas to create calculations?
If this is your main source sheet, I would recommend creating a Report from this sheet. Then you can Group by the Client Name and use the Summary feature on your "No of PO" column if you want to SUM the data. Here's a free webinar that goes through these features: Redesigned Reports with Grouping and Summary Functions
If I have misunderstood you, can you identify what metrics you're looking to get? Do you have a screen capture of the "Metric Calculation Sheet"?
Thanks,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
hi ,
Thanks for the response , I hope my question was not clear . Sorry for that .
Kindly see the Sample Date Entry Sheet being Maintained by the users
From the above data Entry sheet , Require help on on getting the below output in another sheet (Metric Sheet) .
Color coded for easy understanding . thanks
-
Hi @Denny V
Thank you for these images, this really helps!
I would still actually suggest using a Report:
- Group by the Client Name
- Summarize a COUNT on the PO No column
- Summarize a SUM on the Amount column
This will then be automatically updated as you update the original sheet. Have you tested the Report feature?
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!