SUMIF - FORMULA CAN'T FIND A NUMBER STARTING WITH "0"

Gino Medeiros

Hi,

I'm trying to Sum total cost. But it doesn't recognize the number "00000013".

Also, if I change the criterion to "13" and switch to another column with =RIGHT,2 formula, from the "00000013" column that would equal "13", it still doesn't work.

My formula is

=SUMIF({02. BUDGET TRACKER COST CODE}, "00000013", {02. BUDGET TRACKER EXTENDED COST})

Please let me know if there is a work around.

FYI, if I manually change the "00000013" to "13" (no formula) and use the below formula, it works. Problem is I don't want to manually change 200+ lines every upload my report.

=SUMIF({02. BUDGET TRACKER COST CODE}, "13", {02. BUDGET TRACKER EXTENDED COST})

Thank you,

Andrée Starå

Hi Gino,

Have you looked at using the VALUE function?

https://help.smartsheet.com/function/value

Would that work?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi Gino,

Have you looked at using the VALUE function?

https://help.smartsheet.com/function/value

Would that work?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer. It will make it easier for others to find a solution or help to answer!

Gino Medeiros

Perfect, thank you. That was too easy. (I should've know that)

Andrée Starå

Easy to miss!

Happy to help!