Record Project Task Status Changes (Status Timeline)

Record Project Task Status Changes (Status Timeline)

We need to track the average business it takes to complete a tasks with some exclusions. 

We use Projects to track incoming orders. Before the order can be entered into the system several steps need to be accomplished.  The process has a general order but sometimes can go back and forth to other statuses. We have status such as Risk Assessment, GM Approval, Awaiting Customer, Re-Quoting, Scheduling and Order Ready.  The excluded statuses are Awaiting Customer and Re-Quoting.

I know there is no Analytics connection for this now and I can export each and every single task individually and then take the massive effort of combining the files into accessible data but I'm looking for an alternative.

Is there a Function, Workflow, API, Webhook... something that we can use?  Could there be a trigger when a status is changed that that data is saved to a spreadsheet document within the Project?  Can an accumulative integer field be updated for each of the statuses when they change?

I'm really hoping there's a better way.  We may need to pull this from Projects and find a better product.



      • Sticky Posts

      • Tip: How to print the Gantt View

        Though we move from the traditional project management system (using papers) to an online project management system, we still prefer to have a printed copy of the activities/tasks that are to be done in the project. This way, we can carry the to-do lists with us for the meetings and refer when we are offline. The print option, available at the right side of the page, allows the users to print the project information across all the modules. However, this option failed to print all the tasks & milestones

      • Project Management via Emails in Zoho Projects

        We write mails to communicate. In Zoho Projects, we can write mails to collaborate. Yes, Zoho Projects supports Email based project management. The mails that you send turn into tasks, bugs, project comments, forum replies, etc. The following are some of the frequently asked questions that might be of some help to you. What are the pre-requisites to manage my projects through Emails? You need to have a personal / business mail ID that is registered and confirmed with accounts.zoho.com To learn more

      • Four types of task dependencies

        "Nothing is particularly hard if you divide it into small jobs."                                                                                                                  - Henry Ford Projects, small or large, are driven by simple work units called tasks. Monitoring standalone tasks might look simple but as the workflow becomes elaborate, tasks may start relying on one another. In project management, this relationship between tasks is termed as "Task Dependencies". Dependency between tasks arise

      • Task and Project numbering

        Zoho Projects now generates a unique number for each project, task, and issue added. The auto-generated ID is a combination of a prefix and a number which is assigned by Zoho Projects. The unique IDs for projects, tasks, and issues will be useful to track, identify, and search easily. You can modify the settings to enable or disable the Project and Task IDs.  Learn more on how to modify Prefix & ID settings for projects and tasks. Issue IDs cannot be disabled, only its prefix can be changed (tasks

      • Task Inline Editing Enhancement

        Hi All, Today, we have made an enhancement in task inline editing. In 4.0, task edit is moved in a single screen in a pop-up. We designed this in-order to make the task edit across the product to be the same. Let it be in Feeds, Tasks & My Tasks tab, Calendar & My Calendar tab, a click on the task title will open the popup and user can edit the values. Customers pointed us the inline editing was very useful to them & how much they miss that in 4.0. Based on the feedback, we have rolled out this enhancement.