-
How to export column properties with the column names
We are planning to redo our master IS and enterprise project sheets. My first step is to do an inventory on the current columns and determine what is useful and what is redundant. I am going to export to Excel for ease of use, but I really also need the data properties of each column. So, I am looking for a way to access…
-
How can I document formulas used on a sheet?
I have a fairly involved project management solution using multiple sheets, reports and dashboards, and want to document the inner workings of the sheets in the event we have to recreate them. The SmartSheet backup system will back up the data but not the actual sheet itself leaving me to recreate all of them and remember…
-
Make bundled notifications or request an update optional
We have a workflow where the sheet refreshes daily. We need to trigger request an updates at the row level for advisors based on flag parameters. Advisors have domains our instance of Smartsheet doesn't support, so we need to send the request an update to a mailbox and then have Power Automate aggregate them by advisor -…
-
Help Escalating an Issue?
Hi Community, Has anyone successfully escalated an issue with Smartsheet billing or support? I’m struggling to get meaningful resolution. I paid our invoice in December, and shortly after received a second invoice. During my initial call, I was told this was a duplicate related to an account change we discussed but…
-
Generating Documents
Am I able to generate a document with children rows reporting out as rows? I want to make a header followed by multiple rows of data supporting that header.
-
Welcome to the Project Management Office (PMO) Community!
This is a space for Smartsheet users that work in Project Management Office (PMO) functions to connect, share ideas, challenges, best practices and how you are using Smartsheet to transform your specific use case. Our Smartsheet team will be sharing helpful resources, upcoming industry events, discussion questions, and…
-
Inconsistent Formatting in Dynamic View
I have added colors to columns, but it seems to inconsistently format in the Dynamic View as seen in this screenshot. Does anyone have any advice or feedback? Thanks, Jeanna Wright
-
Ability to hide attachments and comments on published reports
I have the need to share published reports with customers, but i don't want them to see the conversations that exist on the line or the attachments we use either. It would be great to be able to hide those for published reports.
-
Planned Dates vs. Actual Dates with Date Variance and Gantt Chart
Good evening Smartsheet Community, Question 1 - Does anyone know the formula I would use for the "Date Variance" (variance between planned and actual) column to populate? Question 2 - I have set the baseline of the project, however when I populate the "Actual Start Date and Actual End Date" there is no visual change on the…
-
Workaround for Assigning Two Random Task Owners/Multiple Auto Number Columns
Hi. I am trying to randomly assign two different tasks within the same sheet, one person who will sign a form and one person who will create the IT ticket with the signed form. Each row in the sheet will be an individual form to be processed. I have figured out how to assign the approver using an Auto Number column on the…