-
Cell to test if an ETA has passed without an order delivery
Hello, I'm trying to generate a report that shows any orders that have passed their ETA without delivery. In the sheet, I have figured out how to highlight the row with conditional formatting, but I'd like to extract the order essentials into a report that I can surface to three different managers via a portal/dashboard.…
-
Bug: Reports still have problems
Smartsheet status (https://status.smartsheet.com/) shows the Reporting Service Delay issue as "Monitoring - The Reporting service is no longer experiencing delays. We are continuing to monitor this service." Sorry to say, I still see issues. This has been going on for a while: "Report Delays" - 2018-03-14 and 2018-07-12…
-
Report - Return the Column of the cells with a certain value
Hi All, I have a sheet that I am using to track the results of site inspections. Each row is a facility's inspection, each column heading is a question on the assessment (ex. have fire extinguishers been inspected?) and each cell has an option of "yes", "no", or "Found not Fixed". I want to report on this "Found not Fixed"…
-
Report Not Updating
What’s the deal with reports not updating. It’s been 2 days now. This is a constant issue. Is anyone else having this problem, again?
-
Mobile app doesn't show dashboard graphs
I can't view any of the graph widgets on the mobile app. Is this a known issue or are my settings wrong?
-
Auto-send PDF Gantt chart of project schedule
We want to be able to auto-send a PDF of projects to our clients on a weekly basis. Can we do this somehow? I know we could share a report for them to view at their own convenience, however, we can't be sure that they will log on to view it regularly which is necessary. to make it easier for them, we would like the option…
-
Can a Smartsheet form submitted auto-populate PDF then triggers DocuSign
Hi, I am trying to deploy a reimbursement system for my office. Once a person submits a form via smartsheet, I need to have a PDF pre-filled with all of the info including the ones that will be linked to other cells. Once the PDF is prefilled, I will need it to go thru DocuSign for signature. Once the user signs I will…
-
Comments in report widget
I have a report pulling in the info I need from a master, and then am using the report widget in my portal to display the contents of the widget. However, within the report widget I can't see the comment bubble/view comments. Is there a way to see comments from within the portal? Thank you!
-
Removing duplicate types in an output report
I have a report that shows the output of staff within a department. It shows all the publications and events they are working on. I am looking to build the report so that it does not show duplicates of the same type of output by the same person. For example, Staff member A is running 10 roadshow events throughout the year.…
-
Conditional formatting with heirarchy and card view
Hey All, I'm having difficulty getting my card view tabs to show a certain color based on percentage complete for the subtask. When I create the rule it either highlights all the subtasks based on the parent percentage complete, or does nothing at all. I am trying to have individual subtasks change color base on…
