Report: Business Order Status

	Business Order Status Col	Q1	Q2	Q3	Q4		Business Order Status Col Formula	Q1 Formula	Q2 Formula	Q3 Formula	Q4 Formula
	Collaboration powered by Smartsheet   |   Report Abuse
1	How it's working now. Is this the best way to do this?					FORMULAS MIRRORED HERE >>	Mirror of the left showing formulas
2	Change Year to Update Dates >>	2019					Change Year to Update Dates >>	2023
3	Business Order Status	Q1 2019	Q2 2019	Q3 2019	Q4 2019			`="Q1 " + $[Q1 Formula]$2	`="Q2 " + $[Q1 Formula]$2	`="Q3 " + $[Q1 Formula]$2	`="Q4 " + $[Q1 Formula]$2
4	Women-Owned Business		1		2			`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q1 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q1 Formula]$3))	`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q2 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q2 Formula]$3))	`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q3 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q3 Formula]$3))	`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q4 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q4 Formula]$3))
5	Immigrant or Foreign Born-Owned Business							`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q1 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q1 Formula]$3))	`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q2 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q2 Formula]$3))	`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q3 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q3 Formula]$3))	`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q4 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q4 Formula]$3))
6	Minority-Owned Business							`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q1 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q1 Formula]$3))	`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q2 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q2 Formula]$3))	`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q3 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q3 Formula]$3))	`=IF(COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q4 Formula]$3) = 0, "", COUNTIFS({BusinessOwnerStatus}, CONTAINS($[Business Order Status Col]@row, @cell), {Quarter}, [Q4 Formula]$3))
7	Family or Multi-Generation-Owned Business	1						ALL formulas in this col are identical	ALL formulas in this col are identical	ALL formulas in this col are identical	ALL formulas in this col are identical
8	Veteran-Owned Business				1
9	Disabled-Owned Business	1			1
10	Disadvantaged Business (DBE)
11	LGBTQ-Owned Business		1		1
12	White/Caucasian-Owned Business
13	African-American/Black-Owned Business	1	2		1
14	American Indian or Alaska Native-Owned Business		1
15	Asian-Owned Business (Chinese, Filipino, Asian Indian, Vietnamese, Korean, Japanese, Other Asian)
16	Native Hawaiian and Pacific Islander-Owned Business	1	1		1
17	Hispanic / Latino-Owned Business	1	2		1
18	Two or More Races-Owned Business		1
19	Other	2
20
21	Column Totals:	7	9	0	8		Column Totals:	`=SUM([Q1 Formula]4:[Q1 Formula]19)	`=SUM([Q2 Formula]4:[Q2 Formula]19)	`=SUM([Q3 Formula]4:[Q3 Formula]19)	`=SUM([Q4 Formula]4:[Q4 Formula]19)
22
23