-
Formula to countdown contract expiration dates
I have a sheet that lists all active contracts for my department. The sheet houses the contract details such as Contract Name, Contract ID #, Vendor, Start Date, End Date and Extension Date, etc.… I am currently using =[Expiration Date]@row - today() as the formula in an adjacent cell to countdown the days until the…
-
Grouping limit in reports? Data cut off, not collapsed.
Hi there, I know there are some limitations with grouping in reports, but I don't think I've run up against them just yet. I have a report with 2,059 rows but when I group them, the report only shows 1,974 rows. I tried removing some columns to reduce the overall number of cells, but that didn't help. I don't see any…
-
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…