-
Check box - how to auto record user details once selected
Hi Guys, I am using a checkbox to indicate when a particular task has been completed, but i need it to automatically record the user who changed it and when this occured. Can anyone help me with this, or suggest another way to make this work. Thanks in advance, Brett
-
Feature Request: Mimic specific sheet(s) in Report
This can be done manually, but is time consuming: I would like a Report that mimics a specific sheet*. That is, the Report would display all columns in the same order as displayed in the sheet. Currently, this is a manual process which is OK for a sheet with a dozen (or even two) columns, but I'm working with sheets that…
-
Dynamic Dates
I am creating task reports for our team that pulls tasks from multiple sheets and aggregates them into one, easy to read report. I'm using reports because I want to apply date filters and structure task reports to show all outstanding tasks (past due and due today) and upcoming tasks (tasks due within the next week). I…
-
Reporting Services down?
I am unable to open any of my existing report , here is the error message: an unexpected error has occured running your report and the smartsheet.com team has been notified. Am I the only one?
-
Create dependency reminder by date
I'm looking to create a content tracker that includes a reminder to review once a document has reached a certain age. For example, Content piece one contains a column for "publish date", once 6 months have passed since that date, I'd like a status column with options of "current, needs review, outdated" to reflect status…
-
Rollup Reporting - Escrow System
I've created a set of templates which are essentially extended to-do lists for tracking real estate escrows. Each new escrow gets a fresh sheet inserted into the <active escrow> work group. The user is responsible for adding the new sheet to the master report. Beyond that, I can't ask uses to create links or other…
-
Sights Dashboard Feedback from Power User
Hi there, not sure where to put in my feedback for Sights but I think it's a great tool but has the potential to really be so much more powerful for business users. I feel like I get stopped at ideas due to lack of features. Here are some ideas I hope you can add: - Export to PDF: we use the dashboard as sort of a…
-
Linking cells based on matching criteria
I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link…
-
Report is pulling correct results, but cells are blank
I have a set of project sheets that all share the same basic layout and format, AND also have all the same sharing permissions -- specifically, I am the owner of all of them. I'm trying to generate a report that shows me all sheets with an End Date in the future for a specific task / row in the sheet. The report seems to…
-
Creating a report, Not able to select column that exsists on sheet.
Hello, I use the same sheet frequently and change the title/calendar to fit the need of the project. I also use the same report, and generally just change the sheet the search is restricted to in order to generate calendars for sub contractors for the specific project. However, I'm having a strange error. I'm trying to…