I am trying to add summary charts to a dashboard, however it requires numerical values which are impossible to add for what I am trying to show in the chart. Excel can easily create a variety of charts to show me how many cells in a column show specific data, and the Work Insight in Smartsheet also shows me the data in the…
Hey All, I submitted this product enhancement request through a feedback request a while back but I think this idea has a lot of merit and would really benefit the community as a whole. If you are like me, I'm sure you are all using and loving the AI feature! One thing that has been cumbersome about it has been that in…
I have a column chart as seen below: The summary sheet i use as the data source is formatted as below: I used a summary sheet instead of a summary report as it gives me more options to manipulate the data, but also structure it correctly in terms of month order. The months and years will have to manually be inputted and…
We are making a master sheet to combine all of our 15 intake forms and sheets to help track metrics and more easily send intake rows/projects amongst teams once their portion of the project is complete and/or work on a project simultaneously. Is there a way to only view the columns for each sheet and their column…
I want to insert a Sum formula into Row 3 that will Sum all the rows in the column beginning at row 4 and continuing to sum any new rows that are added to the column. It seems like it should simply be =SUM([ColumnA]4:[ColumnA]) but this gets an #Unparseable error. How might I create a Sum excludes everything above Row 4…
This discussion has been merged.
When using the Salesforce Connector, there was an unintentional overwrite of cells in a contact column in my Smartsheet table. I have an exported file in Excel which has all the contact names (First and Last) that I could copy/paste into the Smartsheet contact column. I have tried copying this data in a group of column…
I'm trying to track which users are granted access to various systems. What I would like to do is to have one grid which lists all the System IDs (and various properties as columns) with one system per row, and a unique System ID for each system. Then I would like a grid that lists each user as a row, and the column…
