-
Moving singular cell data into a sheet from a master sheet with autonomy?
I am sure this has been asked before, but I have scoured many forums and attempted many solutions but to no avail. My issue: I have a sheet (let's call it master) that holds metadata. I also have another sheet (let's call it Department) that relies on a single piece of metadata from Master, but also requires the ability to…
-
Reports vs. Sheet (reporting / dashboards)
I am struggling because I have a very large SHEET that has many many data points that I have created a REPORT to create a BUDGET summary and projects for Quarterly Portfolio review(s); however, NOW I have to create a REPORT from this REPORT so I can create WIDGETS / Charts on a Dashboard; however, I know it isn't a thing…
-
Having Indented Children enter and leave Reports with Parent
Good Morning Community, I use reports to give concentrated views of our Master SmartSheet to Project Managers for ease of use and navigation. One example of such a report is an Overdue Est. Installation Date Report that populates into the report when the Est. Installation Date is in the past. I would like the Parent to…
-
How do I make a Basic Cashflow Line Graph?
I have to think I am just missing something obvious, because I am having the most difficult time using the Dashboard to create a Line Graph that shows my cash flow over time. I tried using only two columns (again, this is a very basic chart) that has the dollar amount figure, and the date that the amount was recorded. My…
-
Create a chart from the sum of columns
Hi, is there a way to create a chart from the sum of columns in a report? Attached is a screenshot - I just want to chart the Sum row. Thanks!
-
Rounding Summary Numbers in Reports
We have reports that show us turnaround times for certain items. We are using the summarize feature to take an average for those turnaround times, but the decimals do not come out cleanly or consistently. Is there a way to round these averages so that it is a whole number?
-
Aligning Columns in a Report that is pulling Data from Multiple Sheets
I have a Primary Column in two sheets with the same data - Project IDs. The subsequent columns are different, however. One sheet has team members info. The other sheet has budget info. Can I create a report that pulls from both sheets, and the Team Member info is side-by-side with the Budget information? As I understand…
-
Building contingency into project plans
What is the best way to manage tasks that have a high degree of uncertainty in the duration? An example might be resolving a design problem – sometimes they are quick, sometimes they take a while. A previous software we used, allowed you to put in a best case and worst-case estimate for each task – effectively adding…
-
Reports - How to open in a new window
Hello Community! I have a Form that contains a "Reference" link, to show a list of projects. This list is a Report, but users have the issue that this report sometimes opens in the same window and hence, they lose everything they already typed in the Form. My question is: is there any parameter that I can include in the…
-
Excel Row Limitation with Sheet Access Reports
When running an all user sheet access report, does anyone run into an Excel row limitation error? If so, how have you worked around this? We have 1M+ rows on our report and it fails. We have too many users to run individual reports and combine. Opening with Microsoft Access has given us trouble.
