-
Bump of old question - User input for reporting
Original Question: "https://community.smartsheet.com/discussion/use-web-form-return-row-or-report-another-sheet#comment-6824" essentially, I would like to have people with shared access be able to enter in a search term or term and then run a report off of that. The only way I see to do something like that is to re-run the…
-
Reporting not working
Reporting is still not working. The Smart Sheet Status page shows it is working properly, however, I cannot run reports.
-
Use web form to return row or report from another sheet?
I have a sheet with 2500+ rows of data + attachments. I would like to allow a technical group the ability to complete the web form with some criteria and return the rows that have the specific value in it. Ideally this would be a nice report nicluding any attachments. Can this be done? The other option is to give access to…
-
Combining Formulas
I am currently using 2 columns to identify tasks "Due in Next 2 Days" and "Past Due/No Schedule". I have been trying to nest the two formulas together to get the status in the same column. How can the following formulas be combined togateher: =IF(AND(Due6 <= TODAY() + 2, NOT(Due6 < TODAY()), NOT(Status6 = "Completed")),…
-
Sorting from a drop down list that parallels parent row hierarchy?
I use the sales pipeline by stage sheet and love it. Typically, we manually move rows between our stages, which are set up as parent rows. I use the stage as the parent so I can easily keep track of my totals, which gives me trigger points for action on issues when sales may get slow. I also derive all of our sales…
-
Remove user but retain resource management functionality
What is the suggested/best practice for removing/revoking a user's access to a team account and it's sheets, but to retain the historical data for that user in resource views and reporting? I am trying to remove former employees' access/ability to see our team data, but I don't want to lose them from resource management…
-
Report Request: Show new discussions added within a time period
I would like to be able to publish any rows that have recieved new comments over the past 7 days along with what those comments are. Is that possible?
-
Counter on Report
Is there a way to add a column to a report? I have multiple SmartSheets managing Test Scripts in multiple functional groups and I want to create a bug report for the developer that searches them all and only shows them the "Fails", but I would like the failures to get a unique identifier. Is it possible to add a column…
-
Setting up alerts on a Report
We have a report that is populated when a cell is checked off from a tracking list. I would like to send an alert to co-worker when a new row is added to the report.
-
TICKBOXES IN SMARTSHEET
I am trying to record telemarketing results for multiple users, who want a simple sheet to "tick" one of four boxes as to the quality of the call, every time they make one. This needs to be automatically updated, and centralised onto a single sheet, with the ability to breakdown into user and date. Ideally, we dont wish to…
