Creating a Formula where there is multiple selections needed.

jimhmeyers

Good Morning Smartsheet Community. I have been struggling with these formulas for a few weeks now and decided to finally reach out for some help.

I am trying to make 2 formulas but there is a part of the formula where I need to reference 2 options in the same drop down. I think I am tripping myself up when it is having to get both of those options.

This is the formula I am kind of working on at the moment but I am getting the #UNPARSEABLE.

=SUMIFS({Deliverables}, {Fiscal Year}, HAS(@cell, "FY24"), {Fiscal Quarter}, HAS(@cell "Q1"), {Work Type}, (HAS(@cell, "New"), HAS(@cell, "Revision")))

The work type is the section I think I am running into my issue.

Any and all help is greatly appreciated!

heyjay

=SUMIFS(
{Deliverables}, 
{Fiscal Year}, HAS(@cell, "FY24"), 
{Fiscal Quarter}, HAS(@cell "Q1"),
{Work Type}, OR( HAS(@cell, "New"), HAS(@cell, "Revision")

Is it Work Type HAS New OR Revision?

jimhmeyers

Hi @heyjay I am looking to have the formula look for items that are marked New and Revision.

heyjay

=SUMIFS(
{Deliverables}, 
{Fiscal Year}, HAS(@cell, "FY24"), 
{Fiscal Quarter}, HAS(@cell "Q1"),
{Work Type}, AND((HAS(@cell, "revision")), (HAS(@cell, "new")))

The HAS + AND works for this sample,