-
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…
-
Can columns with different names be merged in a report?
I am trying to create a report to consolidate task lists that are managed by other people. One person may have used "start" and another used "start date" for the same purposed. Is there a way to merge those into a single column in a report, short of forcing everyone to use the same column names? I do have the option of…
-
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.
-
Setup Notifications for When Reports Change
I'd like to be able to setup a notification for when an additional row is added to a report. Currently we can do this with sheets but it would be useful to also have that feature built in for reporting to do the same so that when new data is added to a report I can be notified. While this can be done in the individual…
-
Report: Show me child tasks ONLY if the parent is In-Progress
Hello, I'd like to build a report. My goal is to see only "Milestone" tasks (of any status), but only when the Parent Status is "in-progress". I can't seem to find the right combination of filters to build this report? Can you help? thank you tons!
-
Can you change the number of decimal places in a report's "Total" field for averages?
This is a report that is populated by a few sheets and is used to average the columns. Look below and notice how the Avg for the manager has only 2 decimal places. However, the "Total" has 6. Can we make Total have 2 decimal places like the manager line?
-
Cross Project Dependencies
Hi SmartSheet Community! I have built a portfolio of projects and I want to create an additional project within the portfolio to capture action items that need to be completed before some of the tasks in the related projects could complete. Example, I'm making ice cream and I have three projects in the portfolio: Vanilla…
