Post Project
  • Search
    • Buyers can
    • Search offers to buy now
    • Search freelancers to request a proposal
    • Freelancers can
    • Search projects to quote on
  • How it works
  • Log in
  • Sign up
  • Freelancer?
Categories
    Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media
Technology & ProgrammingWriting & TranslationDesignDigital MarketingVideo, Photo & ImageBusinessMusic & AudioMarketing, Branding & SalesSocial Media

Develop Google Sheet progress report from ASANA linked projects

- or -

Post a project like this
304
£50(approx. $68)
  • Posted: 11 months ago
  • Proposals: 3
  • Remote
  • #2723428
  • Awarded
Sohail I.
SAMUEL O.Hassam S. have already sent a proposal.
  • 0
  • 0

Description

Experience Level: Intermediate
Estimated project duration: 1 day or less
We're using ASANA for project management (a new endeavour), and I have set up a a Google Sheet that syncs every hour. The data is organised well, with the ability to add custom fields in order to further refine a project report by overarching/related objectives, strategies and tasks. The end goal is to have a dynamic dashboard report that takes a so called 'performance factor' (calculated by multiplying task progress against various weightings) and apply a bonus calculation per quarter / per person.

I'm using a combination of INDEX ARRAYS and VLOOKUPs in GOOGLE SHEETs and have got about 25% there, but hoping to take a few hours in a Google Hangout / shared desktop to problem solve structure issues (and improve approach, so that it is dynamic as project tasks/dates change).

Job: Est. 2 Hours



Jezz H.
Jezz H.
100% (2)
Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
16 Mar 2020
United Kingdom

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

    There are no clarification messages.
304
£50(approx. $68)

- or -

Post a project like this
Jezz H.
Jezz H.
100% (2)
Projects Completed
1
Freelancers worked with
1
Projects awarded
100%
Last project
16 Mar 2020
United Kingdom

Related project Searches


project management asana customization development problem solving

Product

  • About
  • Team
  • Careers
  • Blog

Support

  • How it works
  • Trust & Safety
  • Help Centre

Discover

  • PeoplePerHour Plus
  • Academy

Resources

  • Customer Stories
  • Business Cost Calculator
  • Startup Cities

Browse

  • Freelance Services
  • Freelance Services By Country
  • Freelance Skills
  • Terms
  • Privacy
  • © 2021 People Per Hour Ltd
We use cookies to improve your experience and our services. By using PeoplePerHour, you agree to ourCookie Policy