-
How to make Networkdays formula display less than 0 values
Hello, I am having multiple issues with my calculations using MAX and NETWORKDAYS. In the “Invoice Variance” field my numbers are displaying as negative numbers using the following formula =MAX(NETWORKDAYS([Invoice Submission Due Date]@row, [Original Invoice Receipt Date]@row, [Resubmitted Invoice Receipt Date]1:[2nd…
-
Is it possible to visualize Power BI data in SmartSheet?
Our company utilizes Power BI to track project dates and we'd like to be able to auto-update these specific dates into a SmartSheet sheet based on similar project numbers used in both systems. We want the dates imported from Power BI into SmartSheet, not SmartSheet info into Power BI. Is this possible? Thanks!
-
Portfolio Compilation
Hi Everyone, Relatively new smartsheet user so looking for some help. I want to create a portfolio of all projects that need my team support. Each team has their own project sheet and I do not need all the data in those sheets, just 4 columns for a summary sheet and then create some dashboard reports on it. 2 main blockers…
-
Resource Manager - ability to select field in reports
The reports that can be generated in Resource Manager are quite limited and lack flexibility. I t would be great to be able to select additional fields to the reports. The ability to filter is great, but not so useful is you cannot see all the fields relevant to the filtered group.
-
Merged: Report access should not depend on source sheet
This discussion has been merged.
-
How to combine duplicate data and sum totals of those rows.
I have a sheet that we track data for on a monthly basis for the same items (example below). I would like to display a "top impressions" and "top clicks" widget on my dashboard, but cannot figure out how to show this data without it being duplicated over the 12 times (once for each month). I know a report will need to be…
-
Simple lock row automation doesn't work 100% of time
I have an automation to lock a row once a check box is manually checked off in a report. However, it only works about 80% of the time. I have another automation to unlock the row when unchecked as well however, about 20% of the rows that are checked are never locked. I'm thinking a workaround could be a move row when check…
-
Restricting view of a Dynamic View based on report
Hi, I'm wondering if there is a way to restrict view of a dynamic view with filter where the dynamic view is based on a report? I'm using smartsheet report to generate aggregate data from multiple sheets and then I wanted to restrict views similarly to what I can do using sheet filters (Settings/General). However, reports…
-
How can I auto-generate a report from a template?
Hello! I have a template that I use for new clients, and I'd like a report that generates for each new template I create - specific to that template. What I'd like it to look like is: A new copy of Sheet Template A is generated in Workspace X - we'll call it Sheet X A new report is automatically generated from Report…
-
RYG ball to determine priority involving multiple dates
I have a sheet that lists all active contracts for my department which all have expiration dates. However, I am struggling with this sheet because in all calculations I need to consider any extension dates. I do fine with calculations when there is one date involved but when I need to write them to incorporate two and…