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

• Update to the Merge Tickets Functionality

  This is to inform you about a significant update to the Merge Tickets functionality in Zoho Desk.  Until now, while merging tickets, a user could set one ticket as the master ticket and choose the final value for any field from any of the secondary tickets too. As a result of this provision, many a time, crucial details related to the master ticket faced the risk of being excluded in the final, merged ticket. To overcome this challenge, we have decided to make the value of some critical fields unchangeable,

• Setting up CRM for RFP workflow management

  This will be the first time our organization uses an off-the-shelf CRM, transitioning from our homegrown custom solution, and I would appreciate general thoughts on how to get started in general with our workflow using Zoho CRM. The main question: if

• Integrating Calendly with Zoho Calendar in Zoho Mail

  I moved my office into a business incubator space that uses Calendly for meeting management and events. Calendly doesn't have a integration with Zoho Calendar and vice versa. I was directed to Zapier for integration but it doesn't have an integration

• Unable to access Zoho Desk at all - has an extreme slow load and then just remains blank

  This is all I see:

• Demande : Épingler automatiquement un commentaire via Deluge

  Bonjour, Je suis utilisateur de Zoho Desk et j'ai développé une fonction avec Zoho Deluge permettant d'ajouter automatiquement un type de commentaire à chaque création de ticket. Cependant, j'aimerais pouvoir épingler ces commentaires directement depuis

• Using Creator API access tokens in deluge script

  I am working on generating download urls for files that are uploaded via a creator form. I want to include these urls in record templates so they can be easily accessed. The goal is to make downloading multiple attachments in a record as quick and easy

• Option to Re-order from past orders

  Customers would like to place a repeat order with the business entity. Currently there is no option to support this and everytime the customer has to check out following the same process. Can a option be given to reorder from the past orders?

• Display your zoho contact name when they call your mobile number

  As per the title If a contact calls the office number, the contacts name shows on mobile as long as I have their contact details registered in my crm. Is there a way that if the contact calls my mobile, their name can be displayed? Currently just their number shows when they call.

• US to EU Data Migration done / Workflows and Custom Functions stopped working

  Hello, I need help to restore my workflow rules and custom functions to work. My data was transferred from the US to the EU (Data center migration). Now all Workflow Rules and Custom Functions not working. I have no idea how to restore them to work again.

• Custom view for Milestones

  Hi, Just an idea for the future... would it be possible to create custom views for the Milestones view under Work Overview ? I usually need to look at this view filtered by project group but the filter doesn't remain when navigating away. A custom view

• Email an Invoice from API

  When calling the API to email an invoice, it seems it does not actually send it. Below is a screen shot where I used an API call for the bottom record, and it updated its' status to "Due Today", but no email was actually sent. The top record, I hit the

• How to delete Email Sent From CRM from Contact Records

  I can't figure out how to delete email sent form CRM from contact records. Can you please advise? 

• CRM Deluge how can link attach file with workdrive file.

  Hi, We have create file at workdrive and would like to link to attachment at crm module by deluge. Right now can only upload it to attachment but can not link the file from workdrive. Thank you

• Tropicalize Books

  Books is an incredibly powerful tool that works well in many countries. But I feel that it is a product that is not yet "tropicalized" for Brazil as we speak (this would be like adapting the local reality). We have many strong competitors who do more

• Refund of a check distribution fee...

  I use cashiers checks, from my local credit union, to pay some bills very occasionally. They charge me a 5.00 fee for this service, but then refund me that same amount at the end of the month on my statement. How would I record this transaction in Zoho

• Usuários do Zoho Recruit no Brasil

  Gostaríamos de interagir com outros usuários do Zoho Recruit. Acabamos de completar um ano de utilização. Quem mais usa? se usa outra qual é?

• Zoho Creator Upcoming Updates - December 2024

  Hi all, We're excited to be back with the latest updates and developments on the Creator platform. Here's what we're going over this month: Deluge AI assistance Rapid error messages in Deluge editor QR code & barcode generator Expandable RTF and multi

• Questions about To Do

  1. I created a To Do note on Android and there is a line sorting option in the options drop down menu. But I didn’t find such an option in the PC client. I really need this option. 2. Why is there no search in To Do on the PC client? 3. Why is there no

• Introducing Offer Details Sync to Zoho People

  We've introduced a new option for the Zoho People integration that allows you to push offer details when a candidate is converted to an employee. This simplifies your recruitment-to-onboarding process by seamlessly syncing critical offer information,

• Conversion of functions from Google Spreadsheets

  Hello! I use this formula "=QUERY(ResumoOrdemVencimento!A3:O38;"SELECT A,B,C,D,E,F,G,H,I,J,K,L,M,N,O WHERE C != '' ORDER BY C,G")" in Google Sheets but when importing my spreadsheet into Zoho Sheets the formula was not converted. The QUERY function brings data from another spreadsheet, and then I sort and apply conditional formatting. The order of data will change automatically as I update the source spreadsheet. What Zoho Sheets function is equivalent to QUERY? I have some other spreadsheets to

• Copy, Duplicate, or Clone a Custom View?

  I searched the forums and didn't see anything on the subject. Is there a way to copy, duplicate or clone a custom view? I want a custom view similar to one I've already created. I just want the columns in different order.

• Import from OneNote

  Is there a way to import notes from OneNote? 

• In Zoho Forms - adding a Zoho CRM field for Contact barely shows any fields.

  I'm making a Zoho Form and I want to add a CRM field for Contact. I was expecting to be able to match the contact on the email address provided in the form. My standard layout has lots of fields but for some reason on the dropdown list in Zoho Forms,

• Is Bigin Really Free - Confused by notifications?

  I started to look at Bigin as I was under the impression it was free, but as I started using it I kept getting messages that my trial period was X number of days and to upgrade. When I see something like this I assume I am not on a free version of anything

• Tracking a loan from an investor - a new Bank or Credit Card

  I have an investor providing money from a HELOC (Home Equity Line Of Credit). I have also turned around and loaned this money to another company. But I want to track my outstanding balance of the debt that I owe to the HELOC. Would I / should I track

• The Zoho Meeting Video Quality Crisis

  I'm evaluating Zoho One for my business in Switzerland, and I must address a critical concern that threatens our potential adoption of the platform—the persistently poor performance of Zoho Meeting's video conferencing capabilities. In today's digital-first

• Pay run Error

  Trying to run the last payroll of the year. The payment doesn't get to the employee Due to Technical Glitch in Tool, kindly Help us and resolve IT's showing Technical Glitch from Bank Website But bank People saying contact Zoho team for further solu

• How to make the default currency type in a certain module different from the base currency>

  We have US dollar as the base currency. Also we have two more other currency types. In a custom module, we would like to make another currency as the default one rather than USD. Is it possible to do? How? Thank you very much!

• Track Contact's Employment/Account History

  Thank you in advance for all of your help! Is there a way, within Zoho, to keep track of a contact's employment history? For example, if John Doe is my contact at Account 1, but leaves the company and is hired by Account 2, can I... ...maintain John Doe

• CRM became very slow

  Plz check asap. image failed to upload , workflow doesn't run

• ZohoCRM Workflows Not Triggering After Tool Recovery

  I noticed that ZohoCRM experienced an issue earlier, and according to the status webpage (https://status.zoho.com/), all tools were reported to be fully restored as of 03:00 (PST) on December 30, 2024. However, ZohoCRM workflows are still not triggering

• API to post drafts for social media

  I we want to post draft posts to our zoho social account and then approve and schedule them within Zoho social. is this possible with for example: https://apis.zoho.com/social/v2/post TIA Jon

• What do the color presents represent on the parts of the website?

  I would like to customize my color palette, but I have no idea how each color relates to the parts of the website. It is labeled as uno, duo, trio, etc... Could somehow tell me how they're related or name them more intuitively? Thanks

• Switch to enable or disable sent notification when close a ticket

  Some time you need to turn off the notification email on closing a ticket. But the only way is in the Settings of Zoho Desk. It would be great to have a switch in the ticket just to disbale for once the notification mail when close the ticket.

• Deluge upload to upload file field

  Trying to upload a file to a field type Upload File. I believe I have most correct. I have a merge and download from writer. I have this same script in many other functions and it works fine. I then upload the file to ZFS and get a success response However,

• Alternatives to using multi-select lookup field for a 1-many module relationship?

  I have 2 modules where I only need multi-select lookup option on one of them and the other always has a 1-1 relationship. Do I have to use a multi-select lookup field in this case? Is there another way to solve this? Am asking because I've hit the limit

• O que é o Code Studio no Zoho Analytics?

  Olá Pessoal, Colocando um pouco de informação sobre uma feature do Zoho Analytics chamada Code Studio. O Code Studio é: ‌Funcionalidade que permite desbloquear recursos de Data Science e Machine Learning (DSML) no Zoho Analytics. Utiliza código Python

• Sobre qual tema você gostaria de falar em 2025?

  Olá Pessoal, Quais temas que gostariamos de explorar em 2025? - Zoho CRM Customizações Básicas - Zoho CRM Funções Personalizadas - Zoho Desk Básico - Zoho Desk Avançado - Zoho Analytics - Zoho Creator Deixe a sua opinião

• Sobre qual tema você gostaria de falar em 2025?

  Olá Pessoal, Quais temas que gostariamos de explorar em 2025? - Zoho CRM Customizações Básicas - Zoho CRM Funções Personalizadas - Zoho Desk Básico - Zoho Desk Avançado - Zoho Analytics - Zoho Creator Deixe a sua opinião

• Automatic Updates for Zoho Desk Extensions

  Dear Zoho Desk Team, I hope you're doing well. We would like to request the addition of an automatic update feature for Zoho Desk extensions. Currently, updating extensions requires manually searching for updates and clicking the update button. This process

• Next Page