-
TODAY() returns yesterday or tomorrow depending on your timezone
Hi Community, We have an interesting issue here in Melbourne, Australia when we use the TODAY() function. At various times of the day, it can return yesterday's date rather than today's date (as it should). Took quite a while for this to be acknowledged, but the behaviour has been confirmed now by a couple of senior…
-
Reference Hundreds of Sheets
Hello, I have hundreds of sheets that represent individual contracts. Every time contract is renewed, the current year is added to the sheet. I use a report to reference all the contracts and bring in information for the current year. I want to compare the year's contracts against the budget so I created a new sheet and I…
-
Dashboard Error
I have shared a Dashboard with internal and external stakeholders, but they receive the following error when trying to view. I have shared it with them directly through Smartsheet and also with the direct link. What am I missing here? The individual's shared on the entire workspace do not have a problem accessing it. Do I…
-
Report and Dashboard
In my sheet, I have a column calculating the NETDAYS between two events. This column does not show up if I try to create a Summary Report. It only allows me to create a Row Report. In a dashboard, how can I use a half-pie graph to show the number NETDAYS greater than 37 and NETDAYS less than or equal to 37. I do have…
-
WorkApps: Different report filters for different roles
When using WorkApps to provide restricted access to data, it would be great if we use that same report across different roles by apply different filters. This would allow us to use a single report for the WorkApp instead of creating lots of identical reports. Situation I have data from different departments that I want to…
-
Dashboards and Reports
I'm building a Project Office (PMO) with 80 projects and looking to build a project dashboard for all 80 projects. We would need 4 reports per project (project summary info, project plan, issue/risk log, and project contact list). I'd rather not develop 320 reports (80 projects x 4 reports). Is there a way to do this more…
-
Merged: Create Workflows from Reports
This discussion has been merged.
-
Report Builder to return only current and unique items
I am creating a working report based on bi-weekly reports we receive to identify if any new items (Primary column) meet our criteria and would require to be assigned in the project. I'm using the Report Builder but having some difficulty understanding to get the builder to return only the most recent items, if multiples…
-
How can I automatically remove data with a value of zero from a Dashboard
I am looking for a formula to remove any line of data that has a value of zero in the Report, from the Dashboard. So, when the line of data is zero in the Report, it should eliminate that row from the Dashboard.
-
Smartsheet as Data Entry Form with Intertwined Filters in Drop-downs
Hi. I need to upload an Excel spreadsheet to have some of the columns there filled with text and dropdowns. The problem I am facing is that I would need the different dropdown filters to be intertwined (that is, if I have two columns with one named Continent and another one Country; making sure that when I do select in…