Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-12-2023, 09:24 PM
Jere_RV90 Jere_RV90 is offline Summary Tasks / Custom Field Formula not working Windows 10 Summary Tasks / Custom Field Formula not working Office 2019
Novice
Summary Tasks / Custom Field Formula not working
 
Join Date: Oct 2023
Posts: 1
Jere_RV90 is on a distinguished road
Default Summary Tasks / Custom Field Formula not working


Hi Everyone!

I'm trying to use MSProject to track different projects in the company I'm working for.

I'll be using the Duration with a calendar with working days in order to: assign public holidays, allocate resources, and see if I'm over capacity and need to expand (bringing more people to the project). I still need to learn how to create this.

At the same time, I need to be able to see the elapsed time. I'm doing this using a number column with custom fields driven by a formula that calculates the difference between Start and Finish. This works perfectly for tasks, but it shows 0 for Summary tasks (picture below), can this be solved? Having the time for the Summary Tasks will help a lot in knowing how much each phase will take.



(EDIT: Image URL as Image not displaying Capture hosted at ImgBB — ImgBB )

Thanks!!!
Reply With Quote
  #2  
Old 10-13-2023, 05:47 AM
DaleHowardMVP DaleHowardMVP is offline Summary Tasks / Custom Field Formula not working Windows 10 Summary Tasks / Custom Field Formula not working Office 2021
Advanced Beginner
 
Join Date: Apr 2023
Posts: 49
DaleHowardMVP is on a distinguished road
Default

In the Custom Fields dialog, select the custom field you created with the formula. In the "Calculation for task and group summary rows" section of the dialog, select the "Use formula" option and click the OK button. Hope this helps.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Format not working on cells with formula Cosmo Excel 1 11-01-2022 03:36 AM
How to calculate summary progress date time on summary tasks Logotip Project 0 05-16-2017 01:18 AM
Rollup Summary Tasks to Project Summary Task shep555 Project 1 05-24-2014 12:28 PM
Dependency mapping using custom field - formula help alexRP Project 3 03-24-2014 08:03 AM
Summary Tasks / Custom Field Formula not working Custom field formula not working at summary task level abw1987 Project 3 10-05-2011 07:17 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:21 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft