I am unable apply this formula to the whole column.

Amr

=COUNTIFS({Carpenter Sheet 2024 Range 3}, "Installation Ph 2", {Carpenter Sheet 2024 Range 2}, Date@row, {Carpenter Sheet 2024 Range 1}, CONTAINS(@cell, $City1))

$City1 is a cell having two drop down values

Andrée Starå

https://community.smartsheet.com/discussion/123856/i-am-unable-apply-this-formula-to-the-whole-column

Hi,

I hope you're well and safe!

You can't have a direct cell reference in a Column Formula. However, it would work if you could replicate the cell in the sheet summary and reference that instead.

Make sense?

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!