SumIfs formula not working

John___I

Can someone please help me figure out what I am doing wrong with this formula? I am gett

=SUMIFS({Area}, {Time}, "(06) - ""The time is 6:00""", {Project Column}, "10 Jason")

Jgorsich

This formula would add the values in any row of "Area" where on the same row the column "Time" has the value

(06) - ""The time is 6:00""

AND the column "Project Column" has the value

10 Jason

Any row where BOTH of those things aren't true (either time says ANYTHING else OR "Project Column" says ANYTHING else) would get ignored.

Is that what you are trying to do? What problem are you actually running into?

John___I

Look for all entries in the project named 10 Jason. And add the area values that correspond with any cell that says "The time is 6:00" and with the formula I put Im getting #UNPARSEABLE

Jgorsich

Try this:

=SUMIFS({Area}, {Time}, "The time is 6:00", {Project Column}, "10 Jason")

I think the extra information in the "The time is 6:00" was going to prevent if from working (had it not errored out) but the extra quotation marks were breaking the formula entirely and forcing it to fail to parse.

If your Time column actually has

(06) - ""The time is 6:00""

as the entry instead of

The time is 6:00

you'll need to look into how to escape quotation marks in a formula in Smartsheet. Here is a relevant link:

TIP: How to reference a \ backslash or " double quotes in formulas + [ ] in Col Names — Smartsheet Community