-
List of column names?
This might be a long shot but does anyone know if there is a way to get a list of all of the column names? We have a sheet that has over 100 columns and I would love to get some kind of vertical list that has them all listed so I can review them and their order...without having to scroll horizontally and getting confused.…
-
Cloning a column within a sheet
Has the cloning of a column within the same sheet feature been developed? I saw the discussion back in 2016. Thanks Christi
-
Renaming Columns
Is there a way to rename multiple column headers using a control sheet inside or outside of Smartsheet? For example, we have 36 budget sheets set up in Smartsheet. The columns are named either Budget or Actual by month. When we post Actuals, we have to manually rename each current month column to read, Actual. For this…
-
Stacked IF statement not evaluating all "value if false" options
I have 6 columns of dates that outline a chronological study process: Phase 1 Forecast date & Actual date, Phase 2 Forecast date & Actual date, and Phase 3 Forecast date & Actual date. I would like to consolidate these 6 dates into 1 column ("IX Study Status") that simply gives the current study status. I wrote a stacked…
-
COPY ROW - How to sort destination sheet and display NEW row at top
Hello SS Community, I am using a COPY ROW Workflow to add new row to a destination sheet. However the new ROW is always showing at the very bottom of the sheet and user needs to always scroll down. Is there a way to set up the destination sheet to sort and always have the NEW rows come in at the top of the sheet? I have a…
-
Correct Formula Syntax for checking for excluding blank cells
I have a RAID log sheet where I want to add a helper column to capture the aging (duration) of each issue row that has not been marked as complete (and I want to convert the formula to a column formula). This sheet is generated for each project via our control center solution so there are several rows at the top of the…
-
Impossible to set a Date Constraint (Blue Anchor) - Predecessor is being deleted instead
Hello,I'm struggling with date constraints on child rows. Setup: Dependencies are Enabled. I have a standard Parent/Child hierarchy. I want a child row to have a Predecessor but also a "Start no earlier than" date (manual constraint). The Issue: Every time I manually enter a Start Date on a child row that already has a…
-
Poor support
After having been an advanced user of Smartsheet over several years I cancelled my subscription for a few months and then went back onto the Pro level on 11th Feb - paying $156 AUD for the year in advance. The Pro level includes: Unlimited free Viewers Gantt, table, board, and calendar viewView your projects, programs,…
-
Report Grouping
How do I get the report to group by primary key? I have the sheet organized by primary key, but its not carrying over to the report. I want to see a header for 13100C in between lines 12 and 13.
-
Rule-Driven Column Visibility for Workflow-Based Sheets
Conditional Column Visibility Within Sheets (Dynamic Columns Based on Filed Selection) Forms in Smartsheet support conditional logic. However, the sheet interface itself does not currently support rules-based column behavior. We are requesting the ability to define logic that dynamically controls column visibility based on…