Assistance needed for formula for social media data analysis dashboard
I wanted to use this dashboard for social media that I found here: https://docs.google.com/spreadsheets/d/1tAOpd_89rWFc0Flr6iIoqYor69WzaCDAbGNzVsLBwVE/edit#gid=1491016518. I would be like implement on google sheet (there a download, but it is okay to do it so on Smartsheet as well).
I'm trying to tally the posts not by the days of the week (Monday, Tuesday, Wednesday, etc.) and group them by the number of weeks (how much I've posted per week) but by month, from November 2023 to October 2024, to know annually how much we have posted. I would like to visualize this data in the charts (exactly as it is now, but with the criteria I want). I would also like, just as it is in the template now, to break down by month and then annually the type of posts (TEXT, IMAGE, VIDEO) and platform (Fb, X, etc). It's not essential to know the exact publication date (e.g., 1/11/2023), although I would still like to insert it in the table in a new column, but not for reporting purposes to the company.
What I did is:
Assuming I want to use a dropdown menu in the actual "day for the week" column, and I have already set up a separate column with the months instead of week, I could use a formula like this:
=IF( = "Month", [Link to Month Column])
It checks if the value in the "month I posted" column is set to "Month" (or whatever your dropdown options are for selecting months).
If it is, it returns the value from your separate column that contains the links to the months.
I have replaced [when I posted] and [Link to Month Column] with the actual cell references or column names.
It is not working.
I'm not sure if the formula for this in Smartsheet and Google Sheets is very different. I'd like to give it a try. So, if I can set it up in Smartsheet, I can also use it in Google Sheets.
Could someone help me?
Thank you very much!
Help Article Resources
Check out the Formula Handbook template!