-
Imported Contacts
I have an excel import that has names of persons. I need a contact list to generate items, dashboards, reports, etc. How can i make the imported column with names a contact list so that when it is updated upon a refresh it will not affect the contact list. or do i need to create a different contact list/column? if so, how…
-
Rolling 12 month column chart
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…
-
Download Column Names & Column Types
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…
-
Sum Entire Column Starting at Row 4
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…
-
Merged: Searchable Columns
This discussion has been merged.
-
Copying Contacts into a Smartsheet Contact Column
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…
-
Merged: Capability to add more than one column at a time
This discussion has been merged.
-
Can an automation reference a column from a cell value?
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…
-
Merged: Edit Row - ability to hide columns
This discussion has been merged.
-
Calaulate activity health based on % complete and Planned Finish date
In my sheet I have a column "% Complete" and "Planned FInish". Is it possible to create a formula which can highlight the row color in red, blue or green or yellow if % complete is less then 100% and planned finish is over a certain date (example 10 Dec 2024). I am new at smartsheet, need help from our community.