-
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.
-
Dashboard - error pulling data
I have created a Dashboard. I am trying to pull the report data in as I have always done. I keep getting an error message. I re-created the reports and initially it will work. As soon as I hit "save" I start getting error messages. Help?
-
Ability to Publish reports and sheets in Calender View for moblie users
Recently tried to publish (HTML link) a report to share with my team and ideally we'd like to view this in CAlender view. However the calender view is unavialble for mobile users who click through the HTML link. I would like to see the feature added on. As the gird view is not very the ideal display view, especially for…
-
Dynamic Reports and Control Center Programs
I am having an issue with our Dynamic Reports. We now have 2 separate Control Center programs that both look at the same Dynamic Report to list all of our high severity risks and issues for our projects. We are actually transitioning from one program to another. All of the projects provisioned from the old program were…
-
COUNTIFS Formula to calculate the number of values in a column with multiple values and parent rows
Hello, I'm trying to help a colleague set up a metrics sheet that can help them report on the number of skills they have within their department. There's a sheet of all the people in the department, which has a record of the person, their skills and what they are booked to work on. • Each of the people records are assigned…
-
Combining Reports into one Report and Printing
if someone on team wants to get a report that has ways of looking at the same sheet, rather then creating multiple reports that, has smartsheet created a way to consolidate reports into one when sending it out to the team member rather then multiple? Also, has smartsheet found a way to print a report that looks exactly…
-
Why is the "Assigned To" field not an option to group by within my report?
Hello! I created a report with several columns, however, it does not allow me to group by using the assigned to column (setup as a contact list) . Does anyone know why this is happening?