SUM of Hours column
Hello, I have four columns:
Task | Hours | Assigned to | Total hours
The 'hours' column is how much time (hours) it will take to do the task, the 'assigned to' you can assign the task for more than one person.
Now I need the 'total hours' column to show me how much time it will take for a task (example: Task1 takes 1 hour but it is assigned to three people, so it need to be counted as 3 hours, 1 hours for each person). And in the end, a total sum of all the time of all tasks.
Can someone help me, please?
Thank you!
Best Answers
-
You would use something along the lines of...
=COUNTM([Assigned To]@row) * Hours@row
-
Happy to help. 👍️
Answers
-
You would use something along the lines of...
=COUNTM([Assigned To]@row) * Hours@row
-
Thank you very much, it worked just as I needed!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 460 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!