-
Hidden Form Fields No Longer Writing to Sheet
I have a form that has two hidden fields at the top to indicate which location is using the form. These are necessary to the PowerBI report that uses the data. All of a sudden these fields no longer save when the user submits the form. When I unhide them, they show after submission. I would really like to have them hidden…
-
Enable Card View for Reports within WorkApps
Right now, when we use a Report inside a WorkApp, we can only see it as a simple list. Many teams like to use Card View to manage and edit their tasks like a board. This would would use the full power of a report in having tailored columns that are available to a user to edit when in a WorkApp view. WorkApp logic on…
-
Can I filter for Current User in a Sheet Summary Report?
I would like to create a Sheet Summary Report that shows summaries for only those sheets where the current user is the project manager. I have a series of sheets and each sheet has a summary field of contact list type and containing the project manager. When building the summary report, I created a filter where the Project…
-
Smartsheet Report - Un Grouping
Hi there I have an issue with grouping on a report that is causing a headache. Any grouping I apply to the reports seems to undo itself when the number of days change in the filters. None of the clients have admin access so no one is manually removing the grouping, but they are manipulating the number of days in the…
-
Add "End Date" for recurring delivery schedule of report
I like the ability to create a report that sends to a group of users on a schedule. But adding an end date for when the report will stop sending as an option would be helpful. Making it "set it, and forget it". Additionally, if I can build a report with a recurring send into a template, and have that report only send…
-
Sending a recurring scheduled report to a dynamic list of recipients
I'd like a dynamic list of users that changes with a scheduled recurring report. When selecting who to send a recurring report, I'd want to list the stakeholders for the project, plus have it go to anyone listed as an "Assigned To" in the report. In this case I can have a weekly report for all late and upcoming tasks, that…
-
Reports - Sorting & Grouping
Who can sort a report and group a report? I have a report that I made another member admin on - however they are unable to change the filters or group and ungroup Do they need to be admin to the underlying sheet?
-
Board View Report Without Giving Users Access to Sheet
We have a Smartsheet form where users can request a certificate of insurance. Their email address is recorded in a contact field. I've created a report that filters the contact field to the current user. We'd like for them to be able to see the report in board view, but only for their requests, and do not want to give them…
-
Parent/child rows in a report even if not assigned to parent row
I need to build out a report that pulls the below information: Report needs to show the parent and child rows -Parent is not assigned but child is assigned -Parent is assigned and child is assigned I am open to helper columns but everything I have tired is not working. Formulas: -Parent Helper: =COUNT(ANCESTORS())…
-
COUNTIFS Cross Sheet Error
I have written these hundreds of times but for some reason I am missing something with this one. Simple, trying to count "Health" based on what we call Seq, in this case TSK. Building a metrics sheet for Dashboards. This formula is producing a Unparsable error and I cannot find the error. =COUNTIFS({DSV 3PL Schedule Range…