-
Please could someone kindly help me with this INDEX/MATCH/IF /AND Formula
Hello There Smartsheet Community Please could you kindly point me in the right direction with my formula? Sheet 1 Contains the following sheet references "Status" = Jira Status "MMP" = MMP I need to update the value of "Validation NL" based upon the following criteria: If "MMP" in sheet 1 matches "Req ID" in sheet 2 and…
-
Create Formula in Sheet Summary field to pull only Month from another Sheet Summary Date Field
I have a date field for projected go live date for projects in my Sheet Summary. I would like to add another field with a formula that will display only the Month Name in another field so that when I run the Sheet Summary report I can summarize projects going live by month. I would appreciate any guidance!! Thank you!
-
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?
