-
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…
-
Can you parse a summary field from a report into another report?
I have a dashboard series of reports that have the sum of all room populations for the specified spaces in the report summary. Is there a way to capture the summary from these reports? I want to have a text box that displays these sums… I am trying to avoid having to setup yet another helper column to count up these spaces.
-
Primary Column in Reporting
Is there a way to not have the Primary Column be graphed onto a dashboard (but instead pull the data from a different column to be graphed), without changing which column is the primary? Thanks!
-
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…
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
Target range in graphs
I would like to be able to have a highlighted/shaded section on a graph indicating the target range desired for the data being displayed in the graph. For example, The graph is depicting the average number of patient's seen per therapist per shift… the target range is 6-8…. is it possible to have a shaded line parallel to…
-
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…
-
Merged: Change Report Column Header Name
This discussion has been merged.