-
Simple IF OR Formula
Hi, I would like for the 'Invoice to Cust' Column to update to "No" WHEN 'Cost Recovery' is either "Blank to Invoice" OR "Operation to Invoice". ^Apart from this, if it is doable; I would like to add to this formula of WHEN 'Status' is "To be Invoiced" will update 'Invoice to Cust' to "PENDING" However, if the last ask is…
-
Links are not working from published reports
Nov 20th the ability to click on links in reports stopped working! I have submitted tickets and not a single reply or any help of any kind! Example = https://goo.gl/maps/cX1j23VBCMX1Zxde7 returns this: This site can’t be reached https’s server IP address could not be found. * Search Google for https goo maps…
-
Reports not updating accurately from linked Smartsheets
Smartsheet appears to be a little slow today in updating charts, reports, etc. and with accurate data. Wondering if this is an anomaly or if this is due to a more global impact from Cyber Monday.
-
Formatting Reports
Today I built my first report, and I am bummed out because there was no option to format it. Because each cell's data contains the formatting (especially colors and shading) from its respective source sheet, the final look of the report ends up looking like a crazy mosaic. My only solution was to eliminate formatting in…
-
Will creating a baseline report duplicate resource allocation?
Hello, in Smartsheet's "Project Management Fundamentals" course, specifically in the section on Reporting, there's a great example on how you can compare the original plan (baseline) to actual project dates. The solution illustrated here is to Save As New the original plan (BEFORE you modify any dates), and save it outside…
-
Connect MS Power Query to Smartsheet?
Can anyone explain how to connect Smartsheet reports to MS Power Query? I have tried creating API Tokens to connect some of my reporting, but I’ve been unsuccessful. I can “halfway” Access the Smartsheet via Power Query, but I’ve not been able to figure out how to access my content through Smartsheet and manage the data.…
-
Trying to create a report to use on a dashboard.
How do I create an 'At Risk' report, from a sheet, to include on my dashboard?
-
Report Issue
Still having issues with reports even though the down detector says they have been solved
-
Creating a PMO functionality
I have just been assigned the task of setting up the Project Management Office in my company. For now I need two things, firstly a project tracker for tracking and monitoring individual projects and then a master portfolio tracker where all the info that's updated in the individual trackers feed into. This master tracker…
-
Track Daily Variance Between Forecast to Actuals Across Multiple Cells and Sheets into Master View
Hello, I am desperate for some guidance on the best way to handle my situation. First, I have 2 sheets that I'm attempting to provide an executive view for: * First sheet is a forecast that indicates the number of people we should be training in any product line. The individual product lines are listed in the primary…
