Sign in to join the conversation:
I'm trying to count everything in a Type column that = "Risk" that match a status of "Red" and "Yellow".
How would I add "Yellow" to this statement?
=COUNTIFS(Type:Type, "Risk", Status:Status, "Red")
I think you mean OR, since (at least in my system) Status can't be both Red and Yellow at the same time.
=COUNTIFS(Type:Type, "Risk", Status:Status, "Red") + COUNTIFS(Type:Type, "Risk", Status:Status, "Yellow")
or
=COUNTIFS(Type:Type, "Risk", Status:Status, OR(@cell ="Red", @cell ="Yellow")
should work.
Craig
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
