-
Unhiding Individual Columns
Hello, Having to unhide all columns at once can be overwhelming for new users. From a developer stand point, it's horrible. I usually have to unhide all columns to develop automations and procedures through multiple sheets and reports. Just to properly set up a lookup function can be difficult for new employees who haven't…
-
Set Contact field display type to name or email
When using Assigned To or any other contact field across a large number of sheets, and then aggregating that data in a report or pivot that groups by the contact field, it becomes quickly painful that the same contact appears as both their email address and their name, depending on how someone entered them into the Contact…
-
Include Column Origin in Properties
This request stems from my copying and moving rows from sheet to sheet. It would be very helpful for me to click on a column and see where the column originated from (Sheet name). If it was copied/moved and carried over from a different sheet, or if it was created within the current sheet. I'm running into very frustrating…
-
If I lock columns down so that users cannot edit them, can I still use the "Copy Row" automation
-
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…
-
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…
-
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 https://help.smartsheet.com/articles/2482603-javascript-module-reference. Below is the actual solution. Using Bridge and JavaScript, this example extracts the list of column names from a…
-
Merged: Column Formulas Display Forms
This discussion has been merged.
-
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…