I've read through all the replies on this but have not found the resolution yet

I want to display RYG balls in a new column i created that corresponds to the project Status and Finish Date.  The new column Properties is RYG Balls

The formula works, but only shows as text

Formula i created:


I am trying to use a COUNTIFS formula and it is returning a zero, even though it should return a one...I think it is user error...I checked the reference sheet and it refers to all the columns on the sheet...

=COUNTIFS({SVC Support Priority Range 1}, "[Urgent - Drop Everything]", {SVC Support



I have an automated flow with a status and want to record the # of times an operator changes a task to "for review" (which automatically notifies the review) and it goes back to "to do" because the reviewer doesn't accept the task as submitted.

I looked at an IF function to write YES or NO to a