# 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.

• ✭✭✭✭✭✭

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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭

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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭
edited 08/18/22

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:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭

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:andree@workbold.com | 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:andree@workbold.com | 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!