Custom rollup fields for work items

We’ve been receiving requests from our valued customers to introduce rollup fields to automate calculation in work items. Here are some of the requests we've received so far:

Is there any way to have task estimation points roll up to the story (parent)?

Do we have a feature to sum up the effort estimation provided for the sub item that rolls up into the main item?

Is there an option to enable roll-up of estimation points from sub-items to the main item, like how work hours in Zoho Projects rolls-up to the main task? 

When the of sub-item’s end date is extended beyond the parent item’s end date, how to re-calcuate the duration?

We heard you all!

Zoho Sprints now supports rollup fields for work items, allowing you to summarize field values of related items or parent-child items. This custom field helps you cumulate or aggregate values, single out minimum or maximum values, and arrive at comprehensive numbers to analyze work item data.

 

What possible solutions can rollup fields help you achieve?

• Auto-calculate estimation points of a work item, aggregating the subitem estimation points
  
• Auto-calculate duration of a work item, estimating the original timeline as the subitem dates are adjusted
  
• Auto-calculate log hours of the entire item, including the hours logged for subitems
  
• Work out the average/maximum/minimum of estimation points, duration, or log hours
  
• View related entities of an item like the number of comments, attachments, or log hours
  
• Calculate the sum/maximum/minimum log hours of related entities 

Here's the inference from the above video:

Parent Item	Child Item	Estimation Points	Actual Estimation Point Rollup
Parent Story (As a user, I would like to see different sections)		3	5
	Child Task (Store it in our database to generate charts on customer likings)	3
	Child Bug (Like option is not working)	2

Scenario: A parent item with two subitems, each with its own estimated points.

Rollup Field: Actual subitem estimation rollup

Rollup Type: Child to parent

Source Field: Estimation points defined for each sub-item.

Aggregation Function: Sum

Result: The custom rollup field automatically sums the estimated points from all subitems (3+2) and displays the total estimated points for the parent item (5).

Note: You can also rollup the estimation points of the parent item along with the subitems. To enable this select the checkbox ‘Include value of parent item while calculating’.

 

We have a detailed guide to help you learn all about rollup fields in Zoho Sprints. We’d love to hear how you’re planning to use this feature in your organization. Let’s discuss in the comments below!  

• Topic Participants

• Saranya Baskaran Lakshmi

  

• Sticky Posts

• Ask the experts - Live Q and A on the latest releases from Jan-Apr 2019

  Hello all,   We are excited to kick-start the 'Ask the experts' community series for Zoho Sprints. This series is user-centric and we will focus more on the latest releases and queries that are frequently discussed in our customer support tickets. The first version will cover all the features released in the first quarter of 2019.    What's in the first half?   The first half of this year has been successful with some feature releases and enhancements. Take a look at the list below: Custom layouts

• Focus Group #1 - Epics in Zoho Sprints

  Hello, everyone! As a part of our community learning series, we kick-start "Focus Groups" where you'll get a chance to have a look at a feature that's in its beta phase. "Epic" has been one of the most requested features of late. So, our first focus is on epics.  Our engineering team has developed a module for Epic in Zoho Sprints and the feature is in its testing phase now. We've planned to show a small demo to the folks who register with us through this post. You can also evaluate this feature

• Recent Topics

• Zoho Books will discontinue support for older browser versions soon

  Hello users, Starting from May 15, 2024, Zoho Books will no longer support the following browser versions: Browsers Version Restrictions Firefox Browser Versions older than 100 Google Chrome Versions older than 100 Microsoft Edge Versions older than 100

• Zoho Projects - Q3 Updates | 2025

  Hello Users, The final quarter of the year 2025 has begun, and we at Zoho Projects are all set with a plan. New targets to achieve and new milestones to reach, influenced by the lasting imprint of the past quarter. 2025's Q3 saw some new features and

• Issue with Trident exe file

  Hello Team, Exe Setup file It's showing harmful for user pc please check and do needful. this message for developer team. Thanks Bhargav Purohit

• Transaction Locking with the dynamic date

  Is it possible to dynamically update dates on transaction locking. We want to lock transaction x days from today

• Unable to change sales_order status form "not_invoiced" to "invoiced"

  I am automating process of creating of invoice from sales_orders by consolidated sales_orders of each customer and creating a single invoice per customer every month. I am doing this in workflow schedule custom function where i create invoice by getting

• Apply Vendor Credits Automatically

  We are bulk importing Vendor credits in Zoho Books!!! Is there a way to apply vendor credits automatically to the first UNPAID bill of the Vendor?

• Apply Vendor Credit Automatically

  Hello!!! Is there a way where in we can apply vendor credits automatically on the FIRST OUTSTANDING BILL of the vendor?? We have lots of VENDOR CREDITS ISSUES mostly!!! Applying it manually is a pain for us. Would be great if we have a way to apply the

• Need Easy Way to Update Item Prices in Bulk

  Hello Everyone, In Zoho Books, updating selling prices is taking too much time. Right now we have to either edit items one by one or do Excel export/import. It will be very useful if Zoho gives a simple option to: Select multiple items and update prices

• Creator problem: Edit form View not displaying whole form

  I'm having problems with the form in my database. The edit view is not showing the whole form: This is how it looks in the normal view: As you can see, there is a whole section in the bottom right of the form which is not displaying in the Edit View. This means that I can't change or delete any of these fields... Anybody had a similar problem or know a solution? Any help would be appreciated.   Cheers,

• Vendor Master Enhancements for Faster Purchase Entry

  I’d like to suggest a few features that will improve accuracy and speed during purchase voucher entry: Automated Item Tax Preference in Vendor Master Add an option to define item tax preference in the vendor master. Once set, this preference should automatically

• Quick Item Search & Auto-suggestion for Invoices

  Hi Team, I am facing an issue while creating invoices in Zoho Books. Currently, I have to type the full item name in the correct sequence and spelling for it to appear. For example, my item name is: "Distemper Acri Silk Special White 10kg" If I type something

• Integrating Chatbot with Zoho Creator Application

  Is it possible to integrate a chatbot with a Zoho Creator application?

• Average Costing / Weighted Average Costing

  Hello fellow maadirs. I understand Zoho Books uses FIFO method of dealing with inventory costing, but do you guys have any plans to introduce average costing? We indians need average costing. It's part of our culture. Please. I beg thee. Thanks.

• 'Add Tax To Amount' not reflected in Invoice

  Hi Zoho Support, I'm experiencing an issue with tax calculation display in my invoice template. Despite having "Add tax to amount" box checked in the template settings, the Amount column is not showing the tax-inclusive total for line items. Current behaviour:

• "Subject" or "Narration"in Customer Statement

  Dear Sir, While creating invoice, we are giving in "Subject" the purpose of invoice. For Example - "GST for the month of Aug 23", IT return FY 22-23", "Consultancy", Internal Audit for May 23". But this subject is not coming in Customer Statement. Only

• A real WYSIWYG field instead of the limited rich text

  Hi to everyone A "real" WYSIWYG or HTML field that outputs good HTML code when accessed through the API would be excellent. I tried to use the rich text field, but the styling options are limited. For example, there are no heading tags (h1 to h6), and

• Delete my store of Zoho commerce

  Hi Team, I want to delete my stores of commerce. Please help me asap. Looking for the positive response soon. Thanks Shubham Chauhan Mob: +91-9761872650

• Delete Inactive Zoho Accounts - Access Cleanup_User Id: 60001640923

  As part of our Zoho access hygiene, we’ve reviewed and deactivated several inactive user accounts. These accounts have not been used in the past year and are no longer tied to active operations. All access rights have been revoked, and records retained

• Inappropriate Removal of Features

  It's the first with any software where I am experiencing that an existing customer has some of his exiting features removed. Moreover, new Zoho One users are paying less than us. Is this going to be Zoho's "normal behaviour". If so, it is going to be

• Filtering report embeded in page

  Right now we are using a page variable to filter a report on a page. However, it being a page variable makes it reset if you go to another report/form, we want the filter to be kept the same. I tried using an application variable according to zoho you

• Zia summarizes your IM bot chats in real time

  Hello everyone! Let's say you’re an agent taking over a chat where a customer was booking a flight through a bot on WhatsApp. They've already shared key details, like their destination, travel date, and number of passengers. You need to understand the

• Megamenu

  Finally! Megamenu's are now available in Zoho-Sites, after waiting for it and requesting it for years! BUT ... why am I asked to upgrade in order to use a megamenu? First: Zoho promised to always provide premium versions and options for all included Zoho-applications

• Cancel and refund

  Hi, Yesterday I paid for the Zoho email subscription. Within a few minutes, I realized that the subscription counts one email ID as one user. To make another email ID for the same domain name, I'd have to pay for another user. I emailed right away to

• Kaizen# 209 - Answering Your Questions | All About Client Script

  Hello everyone! Welcome back to another exciting Kaizen post! Thanks for all your feedback and questions. In this post, let's see the answers to your questions related to Client Script. We took the time to discuss with our development team, carefully

• To Do: shareable task links without login

  Hi! I’m using Zoho Mail and ToDo in my daily work, and I’ve run into one limitation that’s a real blocker for me. Right now, to share tasks with managers or directors, they need to have a Zoho account and be added to a group. In practice, many of them

• Ability to turn off "Would you like this amount to be reflected in the Payment field?" message

  Team, Is there any way to turn off the message" Would you like this amount to be reflected in the Payment field?" when I make a payment? This is so annoying. This happens EVERY TIME I put an amount in the Payment Made field.

• Unlock agreement intelligence with Zoho Sign's latest AI updates

  Hello! If you've been struggling with long, complex agreements and spending way too much time on them, here's exactly what you'll want to hear: Zoho Sign now integrates with OpenAI's ChatGPT to make agreement management smarter and simpler. Acting like

• Currency abbreviations

  Hello, Im stuck, and need help. I need the currency fields for example, opportunity value, or total revenue, to be abbreviated, lets say for 1,000 - 1K, 1,000,000 - 1M, and so on, how should I do this?

• Embed Sign Document

  Has anyone tried embedding a document in a webpage? I'm building a webpage (using PowerPage) and I'm trying to embed it using an iframe then I got this error: Refused to display 'https://sign.zoho.com/' in a frame because it set 'X-Frame-Options' to

• We’re transitioning from Zoho ShowTime to TrainerCentral

  Hello everyone, Zoho ShowTime was originally built as a training platform to serve training agencies, HR teams, and individual trainers. As the platform grew, we realized that more creators and businesses could benefit from its capabilities. That’s why

• Emails Are Not Being Delivered to My Inbox

  Hello Zoho Support Team, I am experiencing an issue with my Zoho Mail account. The most important problem is that emails are not being delivered to my inbox. Details: My Zoho Mail address: info@coreforcelife.com What happens: I am not receiving any incoming

• Radar In Focus: Track customer support metrics using Radar's static reports

  Hello everyone, Welcome back to the Radar In Focus series, where we explore how Radar features can add value to your business. In this episode, we're looking at Radar static reports. The help desk is filled with vast amounts of data that can be analyzed

• Mail ToDo & Tasks Webhooks

  Our company uses Zoho ToDo inside Mail to manage our tasks. When I create a task and assign it to a team member it does not notify them unless I add a reminder via mail. I'm trying to create a webhook for when a task is created to send a cliq message

• Improved UI for a Seamless User Experience - Calls, Tasks, and Meetings

  Hello all, We are making UI unification across CRM so that the UI experience is seamless across the product. As part of that effort, we have made changes to the details page of activity-based module records—Meetings, Calls, and Tasks. Let's look at these

• Where can I find rejected inbound mails and their reason for rejection

  Hi, I was recently made aware by a mailing list which I am subscribed to (ffmpeg-devel@ffmpeg.org) that my Zoho mail Mail account is rejecting some emails. If I look under Admin Panel > Security & Compliance > Quarantine > Incoming, the list there is

• Refund

  Hi There, Please refund me asap possible, because of no support given. Thank you

• تغيير عمله الدفع"Change payment currency"

  ما هى طريقه تغيير عمله الدفع "ما هي طريقة تغيير عملة الدفع؟"

• Attention API Users: Upcoming Support for Renaming System Fields

  Hello all! We are excited to announce an upcoming enhancement in Zoho CRM: support for renaming system-defined fields! Current Behavior Currently, system-defined fields returned by the GET - Fields Metadata API have display_label and field_label properties

• Zia's ability to generate and improve content extended to Desk mobile app (iOS and Android)

  In support, agents will have to understand customers' pain points completely to provide empathetic personalized solutions and a positive experience. However, at times, agents might find it challenging to comprehend the customer issues and connect with

• BANK FEED - MAYBANK , provider from YODLEE IS NOT WORKING

  As per topic, the provider YODLEE is not working for the BANK FEED. It have been reported since 2023 Q3, and second report on 2023 Q4. now almost end of 2024 Q1, and coming to 2024 Q2. Malaysia Bank Maybank is NOT working. can anyone check on this issue?

• Next Page