-
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…
-
Formula to find the average word used in a column
Hi, Is there a formula I can use to find the average "word" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann
-
Compile a list of unique values
I've been playing around with this all day. I'm trying to figure a way to compile a list all the unique values in a given column (in this case, business entities/customers). I'm matching that against an "Inactive" checkbox and trying to end with a list of all customers with currently active projects. Ideally in a report so…
