-
Data String Type Different in Budget vs Time & Hours Data for Advanced Reports in RM
Is this a bug or just a limitation? When I create an Advanced Report based on Budget data in RM, the Data String type in Smartsheet is automatically a Date format. However, when I create an Advanced Report based on Time & Hours data in RM, the Date String type is Smartsheet is in Text format. Is there a way to have them…
-
Using report information in a new sheet
I am working on creating a streamlined way to obtain information from our 66 non-profit groups in order to request specific credentials based on what zone their group will be working in. I only need full name and email addresses from the group leads. All other information needed, I and operations managers would enter. I…
-
How to Account for Budgeting Future Expenses in Resource Mgmt
How should Expenses, such as fixed price milestones payments, be accounted for in the future dates? What’s the proper way? I see where you can add the budget amount in the Project properties but not the dates in which you anticipate them to occur. If you add them to future Expenses (via the My Work -> Time & Expenses), it…
-
Request for Rollback - create sheets in Sheets folder
This new update from Smartsheet is hindering work performance for us and I'm wondering if other users are feeling the same way. This new update has created the inability to create folders, move sheets into folders and made it mandatory for new workspaces to be created when a sheet/report/dashboard is being created. For us,…
-
Track Monthly Submissions from Multiple Locations
Hello! I have been using Smartsheet for a few years but have really only used the basics. I have a form for our branch managers to submit their monthly safety checklists and wanted to see if there was a way to track / indicate which locations did not submit and for which months. On the form, there is a drop down for them…
-
Rounding in Reports
It would be beneficial if, when data is grouped in a report, and I have summaries showing averages of the grouped data, I could apply rounding to the group summary directly in the report. As it stands, the grouped averages will show a variation of 0 - 5 decimal places. I'd like to be able to set rounding rules directly in…
-
How can i access to my worksheets
I been trying to access to my worksheets but it shows up the next error Anyone know how to solve this?
-
Timeline using Portfolio report
I am attempting to use a timeline from a portfolio report on my dashboard but after setting it up I keep receiving an error - Columns used to configure this widget have been deleted or changed. I have took all filters and grouping off of my report and it still showing this error. I don't know how I can get around this…
-
How to prevent reports and dashboards from breaking when renaming sheet columns?
Hello! I’ve noticed for a LONG time that when I change the name of a column in a source sheet, the corresponding column in reports breaks, which then causes dashboard widget charts (that rely on those reports) to fail. Is there a way to: Prevent this issue when renaming columns? Fix existing reports and dashboards without…
-
Is there an issue with using reports on a dashboard to create a graph?
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…