-
Summary Sheet Symbols and Projection Question
Hi, I am trying to do a few things. First, I would like to pull symbols into the Sheet Summary based on the following criteria: Most Recent Entry for Site A. Pull symbol from the "▲ ▼" column. Second, pull the... Most Recent entry for Site A. Pull symbol from the "Status of Goal" column to sheet summary. Lastly, I would…
-
Reports from Multiple Sheets with a common element
Is there a way to use a report to "combine" information from 2 sheets based on a common identifier (i.e. unique project number)? I have my main data table that has a lot of columns already. One group would like me to add additional fields that could add 100+ columns to the sheet. That would significantly reduce the number…
-
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…