-
Can't figure out why one column in report has non-matching column name?
We've created a report consolidating 31 separate sheets each with a "Station" column. However, when selecting the columns, Smartsheet creates a second "Station" column that only references a single sheet out of the 31 source sheets. This column includes the help text "Includes 1 non-matching column name(s)". All "Station"…
-
Representing Multiple Phases on a Single Gantt Chart Row
Hello Smartsheet community, I’m working on a project where I need to visually represent different phases on the same row of a Gantt chart. For example, I have a project that runs in three phases: Phase 1: January to March (Yellow) Phase 2: March to June (Green) Phase 3: June to July (Red) Is there any native solution or…
-
Format Parent Rows Only with 'Helper' Columns Not Helping...
Hello, New to Smartsheet and trying to learn! None of the posts on the community have worked but I believe this is a basic question. Using indentation, we're creating parent/child rows for individual projects. I simply want the parent row to be able to highlight a color for that whole row once created to visually separate…
-
Problem with a form
I have a form, when the requester clicks send, it appears that there was a problem submitting, but the data is inserted into the spreadsheet, is this some type of visual bug? If I recreate the form does it still give me this problem? Well, I already did it and it happened to give me the same error. Anyone have the same…
-
Rolling "instagram" Style View
Current Smartsheet views are limited to Timeline, board, grid, card, and calendar views. I would like a "instagram" style view which would incorporate photo and video attachments with additional info below from the sheet. This would be extremely helpful when using forms to generate content for media and communication…
-
How to rename multiple files in folders in a workspace com node.js?
Hi everyone, everything fine? I'm creating code consuming the smartsheet node.js SDK API. In this case I'm creating code to rename all the files that exist in folders in a workspace, not actually renaming completely just adding something in front of the name like the project name, but I couldn't do that, is there someone…
-
The New Board View
The new board view looks nice and works well for some members on my team, but most are having a lot of issues with it not loading or page is freezing. I even have some people on my team not able to change the view and is just stuck on the page. Any one else having issues? Any suggestions on how to fix or what maybe…
-
How to create a view/filter based off of a building column?
Is there a way to create a dynamic view/filter where all users assigned to a specific building can see all users within that same building?
-
Having Formula Troubles
Hello, I am trying to count a certain number of product types within a certain work week, both referenced in other sheets. I am able to count my work week data for all product types in one column using =COUNTIFS({Calculation - Defect Rate Run Chart Range 1}, =[Work Week]@row) I have another cell that I am trying to grab…
-
Trouble referencing values in a "CONCATENATE" cell
Hello, I am having issues trying to reference the values in a CONCATENATE formula. I am trying to pull a "Yes" or "No" value based on the product numbers provided in the CONCATENATE cell. The CONCATENATE cell is the combination of product numbers added just for TODAY only (old lines do not show a value unless it is today).…
