-
Report not showing Data when a second sheet is added
Hello, I have a report that displays data properly but as soon as I add a sheet, my data vanishes from the columns before I even add any columns from the newly added sheet. I searched for a similar question but those issues had to do with filters but I have none. Why do I lose my data when I add my new sheet prior to…
-
Automatically Add recent changes information to a row.
Hello, I'm trying to look If there is an option to automatically update the changes happened in the worksheet from past 10 days in to new column (Lets assume the column name is "History_Past10Days") Information I'm looking in this column(History_Past10Days): All the column Names updated from past 10 days Ex: Sheet has 20…
-
Show next pending task in Summary
Hello, I am trying to show the next pending (open) task in Summary, so it will show on my Summary report as well. In the summary report I also want to show the delivery date for that task. Basically if the previous task is Completed (checked), then I want the next one to show in Summary. I am trying an IF and VLOOKUP…
-
Gantt chart line for overarching group within a report
Hi All, I have report fed by a data sheet which contains dates for departmental events. These are grouped by department. I have added a Gantt chart which displays the individual lines but i'm wondering if it's possible to have the Gantt data roll up into the grouped Department line. For example, Department A has event 1 on…
-
Graphs from Excel into Smartsheet
Is there a way to take a graph that was created in Excel and import it into a Smartsheet? I can do it via a dashboard but I would like to have it directly on the sheet with the data.
-
Adding Max Sums in a Report
Is it possible to get a total at top of the sheets max sums added together in a report?
-
Report for all owned items
Is there a report you can run for all owned items instead of just owned sheets? I'd like to be able to see a report that includes owned reports and dashboards as well.
-
It there a formula to use so that I can calculate an amount between dates?
Hi! I am trying to calculate the amount outstanding between certain dates, but I can't figure out what to use or if that is even possible.
-
User Activity Report
I am trying to get a report of all of the activities and actions taken in our workspace. Is there something already created for this? Or is this something I am able to create on my own? If so, what would be the steps I take to create the report?
-
Group by Contact in report showing multiple contacts even though there is only Contact assigned
Hi all, I am facing a strange problem with a report I am creating, so we have multiple programs and we have the contact list field "assigned to evangelist" as one of the fields in the programs. I am trying to group by "Assigned to evangelist" and then group by program sheet. For some reason for some contacts, the group by…