Spreadsheet: 687068d1594936295-month-by-month-nested-sumifs-and-averageifs-formulas-stopped-working-content-calendar-help
Sheet: Content

 |  | SOCIAL MEDIA CONTENT CALENDAR
 |  | SJC
STATUS |  | ACTUAL LAUNCH DATE | DAY | MONTH | CHANNEL & HEADLINE | LAUNCH ETA | PUBLICATION TIME | CONTENT TYPE | ENGAGEMENT | REACH | IMPRESSIONS | LIKES | COMMENTS | SHARES/RETWEETS/DMed POST | LINK, POST, & WEBSITE CLICKS | TWITTER # OF CLICKS ON MEDIA (VIDEOS, GIFS, IMAGES) | TWITTER AND INSTAGRAM PROFILE CLICKS | INSTAGRAM SAVES | INSTAGRAM FOLLOWS | FACEBOOK FOLLOWS | FACEBOOK & INSTAGRAM VIDEO/PHOTO VIEWS/MEDIA ENGAGEMENTS | AVERAGE VIEW DURATION | SENTIMENT NEUTRAL | SENTIMENT POSITIVE | SENTIMENT NEGATIVE | BOOSTED? | $ AMOUNT FOR [NAME]
Done |  | 2020-04-06 00:00:00 |  |  | FACEBOOK: Example 1 | 2020-04-06 00:00:00 | 2:49pm | Marketing Organic Content | 122 |  | 3285 | 35 | 1 | 6 | 61 |  |  |  |  |  | 19 |  | 0 | 0 | 0 | No | 0
Done |  | 2020-04-06 00:00:00 |  |  | TWITTER: Example 1 | 2020-04-06 00:00:00 | 2:45pm | Marketing Organic Content | 87 | 0 |  | 6 | 0 | 2 | 3 | 48 | 4 |  |  |  | 24 |  | 1 | 1 | 0 | No | 0
Done |  | 2020-04-06 00:00:00 |  |  | INSTAGRAM: Example 1 | 2020-04-06 00:00:00 | 2:46pm | Marketing Organic Content | 56 | 867 | 1000 | 47 | 9 | 2 | 1 |  |  | 0 | 0 |  | 11 |  | 3 | 0 | 1 | No | 0
Done |  | 2020-04-09 00:00:00 |  |  | FACEBOOK: Example 2 | 2020-04-09 00:00:00 | 6:15pm | Marketing Organic Content | 93 | 2464 | 2702 | 33 | 1 | 4 | 48 |  |  |  |  |  | 14 |  | 0 | 0 | 0 | No | 0
Done |  | 2020-04-09 00:00:00 |  |  | TWITTER: Example 2 | 2020-04-09 00:00:00 | 6:15pm | Marketing Organic Content | 66 |  | 3485 | 6 | 0 | 1 | 18 | 23 |  |  |  |  | 22 |  | 3 | 0 | 0 | No | 0
Done |  | 2020-04-09 00:00:00 |  |  | INSTAGRAM: Example 2 | 2020-04-09 00:00:00 | 6:15pm | Marketing Organic Content | 81 | 921 | 1002 | 79 | 0 | 0 | 3 |  |  | 2 | 0 |  | 17 |  | 0 | 0 | 0 | No | 0
Done |  | 2020-04-09 00:00:00 |  |  | LINKEDIN: Example 2 | 2020-04-09 00:00:00 | ? | Marketing Organic Content |  |  | 457 | 13 | 1 |  | 23 |  |  |  |  |  |  |  |  |  |  | No | 0
Done |  | 2020-04-08 00:00:00 |  |  | YOUTUBE: Example 2 | 2020-04-09 00:00:00 |  | Marketing Organic Content |  |  | 746 | 1 |  |  |  |  |  |  |  |  | 137 | 1m 8s |  |  |  | No
Done |  | 2020-04-19 00:00:00 |  |  | FACEBOOK: Example 3 | 2020-04-16 00:00:00 | 4:25pm | PR Boosted Content | 52024 | 57335 | 81486 |  |  |  | 4121 |  |  |  |  |  | 11583 |  | 0 | 4 | 0 | Yes | 200
Done |  | 2020-04-19 00:00:00 |  |  | TWITTER: Example 3 | 2020-04-16 00:00:00 | 4:28pm | PR Organic Content |  |  |  | 33 | 0 | 8 | 3 | 128 | 9 |  |  |  |  |  | 3 | 1 | 0 | No |  |  |  | Reference Table
Done |  | 2020-04-19 00:00:00 |  |  | INSTAGRAM: Example 3 | 2020-04-16 00:00:00 | 4:28PM | PR Organic Content | 101 | 841 | 959 |  |  | 4 | 0 |  |  | 3 |  |  | 4 |  | 0 | 1 | 0 | No | 0 |  |  |  | Channels | Character Count | Status | Approved? | Content Type | Boosted? | Month
Done |  | 2020-04-19 00:00:00 |  |  | LINKEDIN: Example 3 | 2020-04-16 00:00:00 | 4:28PM | PR Organic Content |  |  |  | 66 | 5 | 12 | 53 |  |  |  |  |  | 2379 |  |  |  |  | No |  |  |  |  | Facebook | Column1 | Idea | Approved | Marketing Organic Content | Yes | APR
Done |  | 2020-04-19 00:00:00 |  |  | YOUTUBE: Example 3 | 2020-04-16 00:00:00 | ? | PR Organic Content |  |  | 821 | 44 |  |  |  |  |  |  |  |  | 4361 | 1m27s |  |  |  | No |  |  |  |  | Twitter |  | In Progress | Not Approved | Marketing Repost | No | MAY
Done |  | 2020-05-01 00:00:00 |  |  | TWITTER: Example 4 | 2020-05-01 00:00:00 | 6:38pm | PR Organic Content | 206 |  | 8699 | 24 | 1 | 16 |  | 38 | 14 |  |  |  |  |  | 3 | 3 | 1 | No |  |  |  |  | Instagram |  | Ready for approval |  | Marketing Boosted Content |  | JUN
Done |  | 2020-05-01 00:00:00 |  |  | INSTAGRAM: Example 4 | 2020-05-01 00:00:00 | 2:12pm | PR Organic Content | 71 | 741 | 804 | 50 | 0 | 1 | 0 |  | 2 | 1 | 0 |  |  |  | 3 | 1 | 0 | No |  |  |  |  | LinkedIn |  | Scheduled |  | PR Organic Content |  | JUL
Done |  | 2020-05-01 00:00:00 |  |  | LINKEDIN: Example 4 | 2020-05-01 00:00:00 | 2:12pm | PR Organic Content |  |  | 233 | 9 | 0 | 0 | 4 |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | YouTube |  | Done |  | PR Repost |  | AUG
Done |  | 2020-05-15 00:00:00 |  |  | FACEBOOK: Example 5 | 2020-05-04 00:00:00 | 11:41am | Marketing Organic Content | 635 | 6648 | 7308 | 218 | 6 | 28 | 362 |  |  |  |  |  |  |  | 6 | 1 | 0 | No |  |  |  |  | # |  |  |  | PR Boosted Content |  | SEP
Done |  | 2020-05-15 00:00:00 |  |  | TWITTER: Example 5 | 2020-05-04 00:00:00 | 11:41am | Marketing Organic Content | 173 |  | 4683 | 35 | 2 | 10 | 2 | 67 | 4 |  |  |  |  |  | 2 | 2 | 0 | No |  |  |  |  | Idea |  |  |  | [NAME] |  | OCT
Done |  | 2020-05-15 00:00:00 |  |  | INSTAGRAM: Example 5 | 2020-05-04 00:00:00 | 11:40am | Marketing Organic Content | 197 | 1107 | 1248 | 185 | 8 | 18 | 0 |  | 7 | 4 | 0 |  |  |  | 3 | 1 | 1 | No
Done |  | 2020-05-15 00:00:00 |  |  | LINKEDIN: Example 5 | 2020-05-04 00:00:00 | 11:40am | Marketing Organic Content |  |  | 850 | 46 | 0 | 1 | 18 |  |  |  |  |  |  |  |  |  |  | No |  |  |  |  | [NAME] |  |  |  |  |  | NOV
Done |  | 2020-05-20 00:00:00 |  |  | FACEBOOK: Example 6 | 2020-05-04 00:00:00 | 3:39pm | PR Organic Content | 75 | 2800 | 3126 | 26 | 0 | 5 | 36 |  |  |  |  |  |  |  | 0 | 0 | 0 | No |  |  |  |  | Theme Week |  |  |  |  |  | DEC
Done |  | 2020-05-20 00:00:00 |  |  | TWITTER: Example 6 | 2020-05-04 00:00:00 | 4:03pm | PR Organic Content | 39 |  | 4111 | 4 | 0 | 3 | 20 | 20 | 1 |  |  |  |  |  | 3 | 3 | 1 | No |  |  |  |  | Theme Week |  |  |  |  |  | JAN
Done |  | 2020-05-20 00:00:00 |  |  | TWITTER: Example 6 | 2020-05-04 00:00:00 | 4:01pm | PR Organic Content | 43 |  | 4605 | 1 | 0 | 2 | 1 | 12 | 3 |  |  |  |  |  | 3 | 3 | 1 | No |  |  |  |  | Theme Week |  |  |  |  |  | FEB
Done |  | 2020-05-20 00:00:00 |  |  | LINKEDIN: Example 6 | 2020-05-04 00:00:00 | 4pm | PR Organic Content | 75 | 2800 | 145 | 3 | 0 | 1 | 2 |  |  |  |  |  |  |  | 3 | 1 | 0 | No |  |  |  |  | Theme Week |  |  |  |  |  | MAR
Done |  | 2020-06-05 00:00:00 |  |  | FACEBOOK: Example 7
Idea |  | 2020-06-05 00:00:00 |  |  | TWITTER: Example 7
Idea |  | 2020-06-05 00:00:00 |  |  | INSTAGRAM: Example 7
Idea |  | 2020-06-05 00:00:00 |  |  | LINKEDIN: Example 7
Idea |  | 2020-05-01 00:00:00 |  |  | #SpaceDay
Idea |  | 2020-05-04 00:00:00 |  |  | #StarWarsDay
Idea |  | 2020-05-04 00:00:00 |  |  | #InternationalFireFightersDay
Idea |  | 2020-05-05 00:00:00 |  |  | #CincoDeMayo
Idea |  | 2020-05-05 00:00:00 |  |  | #[NAME]
Done |  | 2020-05-06 00:00:00 |  |  | #NursesDay
Done |  | 2020-05-09 00:00:00 |  |  | #EuropeDay
Done |  | 2020-05-10 00:00:00 |  |  | #MothersDay
Done |  | 2020-05-12 00:00:00 |  |  | #NationalLimerickDay
Done |  | 2020-05-13 00:00:00 |  |  | #NationalReceptionistDay
Done |  | 2020-05-15 00:00:00 |  |  | #[NAME]
Done |  | 2020-05-15 00:00:00 |  |  | #BTWD
Done |  | 2020-05-16 00:00:00 |  |  | #[NAME]
Done |  | 2020-05-24 00:00:00 |  |  | #NationalScavengerHuntDay
Done |  | 2020-05-25 00:00:00 |  |  | #MemorialDay
Done |  | 2020-05-26 00:00:00 |  |  | #NationalPaperAirplaneDay
Done |  | 2020-05-28 00:00:00 |  |  | #NationalHamburgerDay
Done |  | 2020-05-29 00:00:00 |  |  | #PaperclipDay
 |  | 2020-06-24 00:00:00 |  |  | FACEBOOK: Example 8 | 2020-06-24 00:00:00 | 12:33pm | PR Organic Content | 762 | 2382 | 2591 | 95 | 4 | 6 | 584 |  |  |  |  |  |  |  | 3 | 0 | 0
 |  | 2020-06-24 00:00:00 |  |  | TWITTER: Example 8 | 2020-06-24 00:00:00 | 12:43pm | PR Organic Content | 77 |  | 1609 | 12 | 0 | 3 |  | 34 | 5 |  |  |  |  |  | 0 | 0 | 0
 |  | 2020-06-24 00:00:00 |  |  | INSTAGRAM: Example 8 | 2020-06-24 00:00:00 | 12:30pm | PR Organic Content | 163 | 1016 | 1160 | 153 | 6 | 5 | 0 |  | 14 | 4 | 0 |  |  |  | 3 | 1 | 1
 |  | 2020-06-24 00:00:00 |  |  | LINKEDIN: Example 8 | 2020-06-24 00:00:00 | 12:30pm | PR Organic Content |  |  | 294 | 6 | 1 |  | 7
Done |  | 2020-05-01 00:00:00 |  |  | #SpaceDay
Done |  | 2020-05-04 00:00:00 |  |  | #StarWarsDay
Done |  | 2020-05-04 00:00:00 |  |  | #InternationalFireFightersDay
Done |  | 2020-05-05 00:00:00 |  |  | #CincoDeMayo
Done |  | 2020-05-05 00:00:00 |  |  | #[NAME]
Done |  | 2020-05-06 00:00:00 |  |  | #NursesDay
Done |  | 2020-05-09 00:00:00 |  |  | #EuropeDay
Done |  | 2020-05-10 00:00:00 |  |  | #MothersDay
Done |  | 2020-05-12 00:00:00 |  |  | #NationalLimerickDay
Done |  | 2020-05-13 00:00:00 |  |  | #NationalReceptionistDay
Done |  | 2020-05-15 00:00:00 |  |  | #[NAME]
Done |  | 2020-05-15 00:00:00 |  |  | #BTWD
Done |  | 2020-05-16 00:00:00 |  |  | #[NAME]
Done |  | 2020-05-24 00:00:00 |  |  | #NationalScavengerHuntDay
Done |  | 2020-05-25 00:00:00 |  |  | #MemorialDay
Done |  | 2020-05-26 00:00:00 |  |  | #NationalPaperAirplaneDay
Done |  | 2020-05-28 00:00:00 |  |  | #NationalHamburgerDay
Done |  | 2020-05-29 00:00:00 |  |  | #PaperclipDay
Done |  | 2020-06-14 00:00:00 |  |  | #FlagDay
Done |  | 2020-06-20 00:00:00 |  |  | #FirstDayofSummer
Done |  | 2020-06-21 00:00:00 |  |  | #FathersDay
Done |  | 2020-06-21 00:00:00 |  |  | #NationalSelfieDay
Done |  | 2020-06-21 00:00:00 |  |  | #WorldMusicDay
Done |  | 2020-06-21 00:00:00 |  |  | #InternationalYogaDay
Done |  | 2020-06-26 00:00:00 |  |  | #[NAME]
Done |  | 2020-06-27 00:00:00 |  |  | #NationalSunglassesDay
Done |  | 2020-06-30 00:00:00 |  |  | #[NAME]
Done |  | 2020-06-30 00:00:00 |  |  | #NationalPostalWorkerDay
Done |  | 2020-07-04 00:00:00 |  |  | TWITTER: Example 9 | 2020-07-04 00:00:00 | 7:25am | PR Organic Content | 90 |  | 1374 | 8 |  | 2 | 6 | 51 | 4 |  |  |  |  |  | 0 | 0 | 0
Done |  | 2020-07-04 00:00:00 |  |  | INSTAGRAM: Example 9 | 2020-07-04 00:00:00 | 7:25am | PR Organic Content | 118 | 914 | 964 | 114 | 0 | 3 |  |  | 4 | 4 | 0 |  |  |  | 0 | 0 | 0
Done |  | 2020-07-06 00:00:00 |  |  | FACEBOOK: Example 9 |  |  | PR Organic Content | 762 | 2382 | 2591 | 95 | 4 | 6 | 584 |  |  |  |  |  |  |  | 3 | 0 | 0
Done |  | 2020-07-06 00:00:00 |  |  | TWITTER: Example 9 |  |  | PR Organic Content | 125 |  | 1651 | 75 | 0 | 2 |  |  | 3 |  | 0 |  |  |  | 0 | 0 | 0
 |  | 2020-07-14 00:00:00 |  |  | FACEBOOK: Example 9 |  |  | PR Organic Content | 1100 | 2801 | 3232 | 114 | 25 | 4 | 545 |  |  |  |  |  |  |  | 0 | 0 | 0
 |  | 2020-07-14 00:00:00 |  |  | LINKEDIN: Example 9 |  |  | PR Organic Content |  |  | 222 | 1 | 1 |  | 1
 |  | 2020-07-14 00:00:00 |  |  | YOUTUBE: Example 9 |  |  | Marketing Organic Content |  |  | 841 | 14 | 2 |  |  |  |  |  |  |  | 133 | 59s |  |  |  | No
Done |  | 2020-07-30 00:00:00 |  |  | #DayOfFriendship
In Progress |  | 2020-08-08 00:00:00 |  |  | #InternationalCatDay
In Progress |  | 2020-08-09 00:00:00 |  |  | #NationalBookLoversDay
In Progress |  | 2020-08-15 00:00:00 |  |  | #NationalRelaxationDay
In Progress |  | 2020-08-16 00:00:00 |  |  | #NationalTellAJokeDay
Idea |  | 2020-08-19 00:00:00 |  |  | #WorldPhotoDay
Idea |  | 2020-08-20 00:00:00 |  |  | #NationalLemonadeDay
Idea |  | 2020-08-26 00:00:00 |  |  | #NationalDogDay
Idea |  | 2020-09-06 00:00:00 |  |  | #ReadABookDay
Idea |  | 2020-09-07 00:00:00 |  |  | #[NAME]
Idea |  | 2020-09-11 00:00:00 |  |  | #911Day
Idea |  | 2020-09-12 00:00:00 |  |  | #DayOfEncouragement
Idea |  | 2020-09-21 00:00:00 |  |  | #PeaceDay
Idea |  | 2020-09-22 00:00:00 |  |  | #1stDayofFall
Idea |  | 2020-09-27 00:00:00 |  |  | #WTD2020
Done |  | 2020-09-28 00:00:00 |  |  | #[NAME]
Done |  | 2020-09-29 00:00:00 |  |  | #InternationalCoffeeDay
Done |  | 2020-10-01 00:00:00 |  |  | #UNDOP
Done |  | 2020-10-01 00:00:00 |  |  | #WorldVegetarianDay
Done |  | 2020-10-02 00:00:00 |  |  | #WorldSmileDay
Done |  | 2020-10-03 00:00:00 |  |  | #TechiesDay
Idea |  | 2020-10-04 00:00:00 |  |  | #NationalTacosDay
Idea |  | 2020-10-05 00:00:00 |  |  | #WorldTeachersDay
Idea |  | 2020-10-10 00:00:00 |  |  | #WorldMentalHealthDay
Idea |  | 2020-10-13 00:00:00 |  |  | #TrainYourBrainDay
Ready for Approval |  | 2020-10-14 00:00:00 |  |  | #DessertDay
Ready for Approval |  | 2020-10-15 00:00:00 |  |  | #GlobalHandwashingDay
Ready for Approval |  | 2020-10-15 00:00:00 |  |  | #GetToKnowYourCustomersDay
Idea |  | 2020-10-16 00:00:00 |  |  | #FoodDay
Idea |  | 2020-10-20 00:00:00 |  |  | #StatisticsDay
Idea |  | 2020-10-31 00:00:00 |  |  | #Halloween
 |  | 2020-11-01 00:00:00 |  |  | #WorldVeganDay
 |  | 2020-11-01 00:00:00 |  |  | #[NAME]
 |  | 2020-11-03 00:00:00 |  |  | #[NAME]
 |  | 2020-11-04 00:00:00 |  |  | #NationalCandyDay
 |  | 2020-11-08 00:00:00 |  |  | #[NAME]
 |  | 2020-11-08 00:00:00 |  |  | #STEMDay
 |  | 2020-11-11 00:00:00 |  |  | #VeteransDay
 |  | 2020-11-13 00:00:00 |  |  | #WKD
 |  | 2020-11-15 00:00:00 |  |  | #[NAME]
 |  | 2020-11-21 00:00:00 |  |  | #WorldHelloDay
 |  | 2020-11-26 00:00:00 |  |  | #Thanksgiving
 |  | 2020-11-27 00:00:00 |  |  | #[NAME]
 |  | 2020-11-28 00:00:00 |  |  | #ElectronicGreetingCardDay
 |  | 2020-11-30 00:00:00 |  |  | #ShopSmall
 |  | 2020-11-30 00:00:00 |  |  | #[NAME]
 |  | 2020-12-03 00:00:00 |  |  | #IDPWD
 |  | 2020-12-04 00:00:00 |  |  | #NationalCookieDay
 |  | 2020-12-08 00:00:00 |  |  | #PretendToBeATimeTravelerDay
 |  | 2020-12-21 00:00:00 |  |  | #CrosswordPuzzleDay
 |  | 2020-12-21 00:00:00 |  |  | #WinterSolstice
 |  | 2020-12-31 00:00:00 |  |  | #NYE2020
 |  | 2021-01-01 00:00:00 |  |  | #NewYearsDay
 |  | 2021-01-04 00:00:00 |  |  | #NationalTriviaDay
 |  | 2021-01-15 00:00:00 |  |  | #NationalHatDay
 |  | 2021-01-16 00:00:00 |  |  | #GetToKnowYourCustomersDay
 |  | 2021-01-20 00:00:00 |  |  | #MLKDay
 |  | 2021-01-23 00:00:00 |  |  | #PieDay
 |  | 2021-01-25 00:00:00 |  |  | #[NAME]
 |  | 2021-01-25 00:00:00 |  |  | #OppositeDay
 |  | 2021-01-27 00:00:00 |  |  | #[NAME]
 |  | 2021-01-31 00:00:00 |  |  | #[NAME]
 |  | 2021-02-02 00:00:00 |  |  | #GroundhogDay
 |  | 2021-02-02 00:00:00 |  |  | #SuperBowl
 |  | 2021-02-09 00:00:00 |  |  | #[NAME]
 |  | 2021-02-09 00:00:00 |  |  | #NationalPizzaDay
 |  | 2021-02-14 00:00:00 |  |  | #ValentinesDay
 |  | 2021-02-17 00:00:00 |  |  | #RandomActsofKindnessDay
 |  | 2021-02-17 00:00:00 |  |  | #PresidentsDay
 |  | 2021-02-25 00:00:00 |  |  | #[NAME]
 |  | 2021-03-06 00:00:00 |  |  | #EmployeeAppreciationDay
 |  | 2021-03-08 00:00:00 |  |  | #[NAME]
 |  | 2021-03-08 00:00:00 |  |  | #[NAME]
 |  | 2021-03-10 00:00:00 |  |  | #[NAME]
 |  | 2021-03-14 00:00:00 |  |  | #[NAME]
 |  | 2021-03-17 00:00:00 |  |  | #StPatricksDay
 |  | 2021-03-18 00:00:00 |  |  | #NationalAwkwardMomentsDay
 |  | 2021-03-19 00:00:00 |  |  | #NationalLetsLaughDay
 |  | 2021-03-19 00:00:00 |  |  | #FirstDayofSpring
 |  | 2021-03-20 00:00:00 |  |  | #WorldStoryTellingDay
 |  | 2021-03-21 00:00:00 |  |  | #WorldPoetryDay
 |  | 2021-03-23 00:00:00 |  |  | #NationalPuppyDay
 |  | 2021-03-30 00:00:00 |  |  | #NationalWalkInTheParkDay
 |  | 2021-04-01 00:00:00 |  |  | #AprilFools
 |  | 2021-04-01 00:00:00 |  |  | #NationalWalkingDay
 |  | 2021-04-07 00:00:00 |  |  | #LetsTalk
 |  | 2021-04-15 00:00:00 |  |  | #TaxDay
 |  | 2021-04-16 00:00:00 |  |  | #StressAwarenessDay
 |  | 2021-04-16 00:00:00 |  |  | #[NAME]
 |  | 2021-04-16 00:00:00 |  |  | #GetToKnowYourCustomersDay
 |  | 2021-04-16 00:00:00 |  |  | #[NAME]
 |  | 2021-04-22 00:00:00 |  |  | #EarthDay2021
 |  | 2021-04-23 00:00:00 |  |  | #NationalPicnicDay
 |  | 2021-04-24 00:00:00 |  |  | #AdministrativeProfessionalsDay
 |  | 2021-04-24 00:00:00 |  |  | #ArborDay
 |  | 2021-04-29 00:00:00 |  |  | #InternationalDanceDay