Hi ! My Dashboards are meant to visualize high level information on my portfolio of projects. One key is visualizing the project duration on a Gantt Chart from Inception to Completion (Project Start t…
The Shortcut Widget layout says side by side but it still looks like stacked on top of each other (or am I missing something here?). How do I do Side by Side using the shortcut widget?
Hello, I am trying to build an executive summary dashboard and would like to capture cell values at the beginning of every month to compile on a monthly basis. I have thought about using a row copy au…
So I have a column I am trying to get a count of by year for a Metric dashboard. I am using the following formula: =countif([Completion Date]:[Completion Date], ="2023"). This formula is not working a…
I would like to be able to set the time period shown in a published calendar view of a report. At present, it defaults to one month, and can be changed in the dashboard, but at that level, many detail…
Hello, I am trying to pull a count of a column "Food Safety Hold" if the "site" matches. I am trying this but it is not working. =COUNTIF(MATCH({Site}, Site@row, {Food Safety Hold}, 0)) =COUNTIF({Food…
Hi All, I am looking for a solution to a problem, I am trying to pull together a chart for a dashboard, displaying the number of overdue documents under review we have - the sheet is set up as below, …
I am trying to collect from a separate sheet the counts of holds if the site matches and if the count of holds is greater than 0. I am trying to collect the Count of holds if the site matches if the c…
I was reading this help and it has some parts I need and noticed it referenced a sheet that no longer exists. https://community.smartsheet.com/discussion/69259/formula-to-pull-data-from-one-column-and…
