Best Of

Hello @scanlan99

If it is a multi select column, you need to use HAS in the formula. Give this a try:

=COUNTIFS([Column Name]:[Column Name],HAS(@cell, "Criteria"))

For this: What would be even more awesome, would be to count the number of times that an option is within a cell AND the status of that project.

Give this a try:

=COUNTIFS([Column Name]:[Column Name],HAS(@cell, "Criteria"), [2nd Column]:[2nd Column],"Criteria")

Hope this helps!

@kelsey_odoc Use the formula's below in your month and year columns and make them column formulas. These will be Text/Number columns.

=YEAR([Date of Employee Request]@row)

=MONTH([Date of Employee Request]@row)

@squirrelax I do not believe there is a direct way to achieve this. However if your organization has Bridge for Smartsheet or if you are familiar with the API you could do this.

Alternatively, you could add an auto row number column (Lets say it's named "UniqueRow") to your sheet if you don't already have one, and also add the Latest Comment Column to your sheet, then you could use a copy row automation and cross sheet references to achieve a count.

Then you would essentially have a helper sheet (lets say its called "Comment Count") that just receives copied rows from your source sheet, triggered when the latest comment column changes to any value. You could create this sheet by saving your current sheet as new, but clear the data.

You would need a cross sheet reference to the Comment Count sheet for "UniqueRow".

Your formula on your source sheet in your count column would be:

=countifs({CommentCountAutoRowNumber}, [UniqueRow]@row)

{CommentCountAutoRowNumber} would be whatever your cross sheet reference name is.

Does this make sense?