Is it possible to get a count in Sheet Summary with the following equation?

Lori Leighton

=IF([CFO Install]@row = "yes, me only", 1, IF([CFO Install]@row = "Yes, my spouse and I", 2, IF([CFO Install]@row = "Unable to attend", 0)))

I keep getting #unparseable. I tried COUNTIF(s), SUMIF(s)

Right now I have been creating a separate column in my sheet with the formula to get the sum. I would like to clean up my sheet and have this on the sheet summary.

Lori Leighton

Thanks! There is no other way to make it happen?

Andrée Starå

Hi @Lori Leighton

I hope you're well and safe!

Unfortunately, it's not possible because you can't use the @row feature because Smartsheet doesn't know which row it should reference.

Make sense?

I hope that helps!

Be safe and have a fantastic weekend!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Lori Leighton

Thanks! There is no other way to make it happen?