Create you a simple and automated Project Tracking Spreadsheet

Delivery in
3 days
Response time
within a day

  • Views 517
  • Sales 1
  • 1
  • 1

What you get with this Hourlie

In google sheet, there is the possibility of a lot of automation and feature development and one of the best thing is it is open source free service. Therefore, I think, template would really help you.

Features included are;
-6 dropdown data validations
-3 simple conditional formatting.
-1 custom conditional formatting.
-All column formatting according to data type.
-1 Setup Sheet and 1 Template with automations

Instructions for Use;
-In order to add Account/Lead column in "2017 Open Projects" tab, just copy grey highlighted row and paste it the new row entry.
-When "Stop" is selected in status column, whole row font color would change to red.
-When quantity and unit cost are entered, system would automatically calculate "Estimated value" and similarly, when probability is entered, "weighted value" is updated.
-"Account" row gets total for upto 2 projects per account automatically.

Get more with Hourlie Add-ons

  • I can update your data to template

    Additional 2 working days

  • I can modify dropdown column and automated template colours

    Additional 2 working days


What the Seller needs to start the work

Following may be required according to your requirements
-Your work logo
-Dropdown values for status, stage, account, who (customer), location, category.