Adding work hours
I want to add the "Amount of work hours WK" as per the "Initials" or "Responsible", to create the total work hours in a week.
Best Answer

Update that last formula to my modified one below. (You had numbers surrounded by " " and that makes Smartsheet read them as text)
=IF(Priority1 = "P0", "URGENT", IF(Priority1 = "P1", 8, IF(Priority1 = "P2", 6, IF(Priority1 = "P3", 2, IF(Priority1 = "C", "", IF(Priority1 = "P4", 1, IF(Priority1 = "P5", 0.5, IF(Priority1 = "P6", "Postponed"))))))))
Did that work?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers

Hi @Nitish
I hope you're well and safe!
Try something like this.
=SUMIF(Initials:Initials, "N", [Amount of Hours WK]:[Amount of Hours WK]) + SUMIF(Responsible:Responsible, "N", [Amount of Hours WK]:[Amount of Hours WK])
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Hi @Andrée Starå ,
Thanks for the solution.
But the result is coming out to be "0".
FYI, the "Amount of work hr WK" is having a formula. Could it be an issue ?

Happy to help!
What's the formula? It might be that it's read as text, and then we'd need to add the VALUE function to the formula.
Test this formula in a cell referencing the Amount of Hours WK cell.
=IF(ISTEXT([Amount of Hours WK]@row), "Text", "Number")
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

Hi @Andrée Starå ,
This is the formula for "Amount of hours WK"
=IF(Priority1 = "P0", "URGENT", IF(Priority1 = "P1", "8", IF(Priority1 = "P2", "6", IF(Priority1 = "P3", "2", IF(Priority1 = "C", "", IF(Priority1 = "P4", "1", IF(Priority1 = "P5", "0.5", IF(Priority1 = "P6", "Postponed"))))))))
Also, the result of the formula that you sent is "Text"

Update that last formula to my modified one below. (You had numbers surrounded by " " and that makes Smartsheet read them as text)
=IF(Priority1 = "P0", "URGENT", IF(Priority1 = "P1", 8, IF(Priority1 = "P2", 6, IF(Priority1 = "P3", 2, IF(Priority1 = "C", "", IF(Priority1 = "P4", 1, IF(Priority1 = "P5", 0.5, IF(Priority1 = "P6", "Postponed"))))))))
Did that work?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

It worked like a charm, thanks a ton. :)

Excellent!
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå  Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com  E:[email protected]  P: +46 (0)  72  510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
Check out the Formula Handbook template!