-
Blueprint - Update a sheet summary column for all projects
Hi, I am using blueprint to manage over 600+ projects. It has come to my attention that the working team wants to add 10 new data points. What I have been doing is adding those 10 new data points in a "Site detail & metric" sheet for each project, then going into the blueprint to add the new columns. I know it won't…
-
SmartSheet Integration with OpenAir for Budget Management
Hi, Could you please confirm if there is any recommended way for integrating SmartSheet with OpenAir? The details are as follows - SmartSheet is used for Portfolio level reporting. It includes the list of projects, status, health indicator columns for tracking purposes OpenAir is used by the project teams to book the…
-
Portfolio Dashboard - best way to showcase multiple phases within each project
Hello Community, We have multiple projects that are in not just ONE phase but have overlapping of phases within a project. We are trying to find a way to be able to display this in a visual representation? Not sure if we would filter out the full list of phases and only show key milestone phases? this is for development of…
-
Smartsheet data in Power BI Date fields - Remove Timestamp?
When I import my Smartsheet data to Power BI, the start and end date fields consistently pull with a timestamp that is nowhere in my sheet. I need these date columns to just have dates, timestamps removed entirely, so that I can tell Power BI the data type is "date" rather than "text." Is there a way to do this on the…
