-
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…
