-
Report on tasks for the next 3 weeks
Hello, I am trying to create a report view of my company's work schedule that only shows tasks happening over the next 3 weeks. I have tried using a combination of filtering by start and end dates in the next or last ____ days, however the problem is that it doesn't capture every task. For example, if there is a one-month…
-
Merged: Add a column to a row report to perform calculations to summaries / groupings
This discussion has been merged.
-
I'm getting below error when trying to add a chart to my dashboard
Dear community, I'm looking for your help if you have come across a similar issue when creating a dashboard. I'm wondering why the data cannot be charted.
-
Row Report, Count Distinct and Summary Formula?
I have a row report that I am building off of a sheet that includes the date, name, and time spent on a task. I am wanting to build a row report grouped by name, that summarizes the sum of the time spent on a task and the count of distinct dates. The part that I am struggling with is counting the distinct dates, as I only…
-
What is the maximum number of rows that can be added to a sheet?
I've searched for 'Row Limitations' on the help center, and haven't found an article which explains clearly so asking here. What is the maximum row limit (vertical, up to down) on a single sheet? I've seen both 5000, and 20000. Additionally, is there an article where this information is contained?
-
Merged: Jump to locations within a dashboard
This discussion has been merged.
-
Formula to track issues logged for a specific year ONLY?
Hi! We currently have a log that captures issues for 2022 and 2023. I'm attempting to track our "Ops Issue" and Labeling Issue" categories for 2023 ONLY and am having a hard time with adding additional date criteria to the COUNTIF formula. The screenshot below reflects my latest attempt at capturing the 2023 data. Please…
-
creating a pie chart of yes/no responses
Hi there, I have a smartsheet where 1 column is a yes/no column. I am trying to create a Dashboard with a pie chart that breaks down the percentage of yes responses and the percentage of no responses. I need some serious help, as I am getting a lot of error messages and cannot figure out where to even start.
-
Track Birthdays and Anniversaries coming up
I am trying to set up a dashboard to allow me to see upcoming Birthdays and Anniversaries, with them being sorted to earliest upcoming being at the top of the list. I tried, what I thought would have been to do a min collect, without luck. Then I thought maybe someone had a better idea as to how to make the happen.
-
Allow Send as Attachment Within WorkApps
Allow users to set a Send as Attachment within WorkApps. I've given permissions only via WorkApps and would like the user to be able to get the attachment without having to be shared to the actual sheet or report.