-
Sync columns across sheets
I created a workspace for requesting/approving/tracking projects. If a project request is declined I move it to another sheet. When I made the new sheet I copied the columns so initially things were sync'd. When a project moves to the declined sheet, any missing columns are added at the end (far right) so things stay…
-
Contact List Functionality in Forms
I've noticed this request a few times over the years, but still don't see that Smartsheet has addressed this. When using sheets, the "Contact List" column works wonderfully and will populate any user within our Smartsheet account when you begin typing a name. However, when attempting to use this within a form, it DOES NOT…
-
How? Column Formula to Pull Level 1 Parent Task Name
Hi Smartsheet Community, Please see image of setup! I am trying to create a column formula for the column 'TEST' that pulls the name of the Level 1 parent task for each row. Essentially, I want every cell in the 'TEST' column to display the name of its Level 1 parent, such as "baseline estimate" or "estimate R1," depending…
-
Ability to remove a column formula from individual cells for manual updates
Adding a column formula is convenient, but there are times when the formula doesn't apply to everything listed on the sheet. It would be nice to be able to remove the formula just for that cell so it can be manually updated.
-
Merged: Copying Columns
This discussion has been merged.
-
Smartsheet Bridge: Iterate over an array using JavaScript - Column names from a sheet
Here is the full solution for how to iterate over an array using JavaScript. Smartsheet provides a partial and incorrect solution at . Below is the actual solution. Using Bridge and JavaScript, this example extracts the list of column names from a sheet and provides them as the only elements in an array. The JavaScript…
-
Email Addresses from Contacts
Is there a way to convert / extract the email address from the values in a column set up as a contact? I have a need for the email address associated with contacts. Thanks
-
Add Work Insights to Dashboards
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…
-
No longer able to widen first column
I am an admin and the creator of a sheet but I've lost the ability to widen the first column -- the one that shows the row icons for comments, attachments etc. I can widen any of the other columns but not the first one, and the column is so narrow that I can't even see the aforementioned icons. Any idea what happened and…
-
Column Formula to populate a Helper Column
EDIT: I just realized this is listed in the Add Ons and Integrations section rather than elsewhere, but I cannot move it. I have created separate helper columns to return the value in [Plan Start Helper] for any of the matching [Opp #] where [Plan] contains the word "Plan" (I have other helper columns that need to search…
