-
How to display "closest matching" rows based on an "input" row?
Hello all! I've been building out what is essentially a database to track information related to customer orders of a specific product. The product is essentially custom tailored firmware - specifically, automotive engine tuning files. Most of the information is provided by a customer through a form, some is manually input…
-
Sending Scheduled Reports
Hello, I have a project with many tasks, and created a report that pulls in any outstanding tasks based on who is assigned in the Assigned To field. I can download the report and send to them manually, but this project runs for the next 8 months and wanted to see about automating the report to send on a weekly basis. I did…
-
Can users sort reports on the Andriod mobile app?
I currently share a report (I am the Owner) with my team. Team members are editors. My team member, working in the field, wanted to sort the report in the app. We can't find that functionality available in the app and we can't access the Smartsheet desktop version, because Smartsheet automatically signs them into the app…
-
Pulling next date from a sheet
Hello! I am looking for assistance with a formula that can pull in the next action date from one sheet to another. For context, we use sheets for customer renewal project plans. We also have a tracker that gives an overview of all the project plans and their name, completion, next action date, status, etc. What I would…
-
Report will not allow me to choose one of my sheets
I'm trying to create a report for one of my sheets, but for some reason I cant select it! There is another sheet that has identical columns/permissions as the one that I want to use that I can select, but for some reason not the one I want. What could i be doing wrong?
-
How to Implement Time Reporting and Assignment in SmartSheet?
Hi Everyone, I hope you are doing well. I have a question. I have maintained 2 sheets, one for Project Assignment to Resources and one for Resources Time Reporting. In first sheet (Project Assignment), I assigned Projects to Resources on Weekly basis. In the second sheet (Time Reporting for Resources), I have maintained…
-
Sheets in Reports
Hi there, I have a question and an answer is greatly appreciated! I have a report that pulls data from standard sheets across all workspaces we have. I need that same information to be pulled from every newly created workspace in the portfolio without me having to add those sheets manually. Is there a way to automate that…
-
Edit locked columns via WorkApp
Hello, I have a sheet that is shared to a couple of groups of people. One group has Admin access to the sheet so they can edit locked columns, the other does not (only want them editing certain columns). I would like to have all users access the sheet via a report on a WorkApp. My question is, will the admin access…
-
Alerting when a new line is added to a report
Hi folks! We have our product roadmap that is being accumulated from 200+ different smartsheet for the different product development teams. My job is to build a technical support training curriculum for the new features that are being deployed so we can better serve our customers. I created a report that accumulated all…
-
Populating Entire Columns Referencing Another Sheet
Hi all! Over the last week or so I have been trying to build a report that shows average tasks completed over a given 12 week period. So far I have been successful in creating the formulas for these, which have been working on dummy data. Now I would like to process live data from another sheet. Well ideally I would…