-
Filter per user
I already submitted the request several years ago, but we would like to have a sheet with filters that are available only to certain users. For example: the “Bryan” filter would display only the rows containing the “Bryan” department, and only he would be able to access that filter. Another filter could be available to two…
-
updating predecessor automatically
Hi, if I add a new row above an existing row which has a predecessor, does Smartsheet automatically update the predecessor number ?
-
Columns Moving Automatically
Has anyone had any issues with column headers moving around the sheet automatically. I have multiple sheets referencing each other using vlookups to report back and also to use tools I have created. Therefore the location of certain columns are highly critical to my companies daily workflows. I have already confirmed that…
-
Expand and collapse ALL on the mobile app
I really think it would make things better if I could easily expand and collapse all on the mobile app. It's too much to scroll through on a small screen, and also very time consuming to manually collapse each parent. Especially when it needs 2-5 seconds to save after each change. Please add this feature. I' very fond of…
-
How to visualize the same timestamp that I see in the grid(sheet) and in dynamics view?
I created a dynamics view but the problems it's that the timestamp that I visualize its a different. I already reviewed the timezone an its set similar in my computer also I review the time format and its the same. Any solution or suggestion?
-
Use index, match and left to match a set of strings from another sheet
Hello, I am using the formula below in order to match two data sets together. It works fine. For my next task I am trying to limit the match to only the first 12 characters of the string. I am trying to fit in the left function and using 12 as the character count, but I am getting errors. Here is the current formula I am…
-
Wrong Date Showing, Seems to be 4 hours off the difference between GMT and my Time Zone.
As can be seen in the attached screenshot I have data that is brought into the sheet from a web form. A time and date stamp is attached at posting (this time and date is correct) however, the date column beside it that is derived from the function Created is not correct is not. This issue is on all of my sheets and seems…
-
Using predecessors to dictate duration
Hello, I have a line in a sheet that I would like to start when another line starts and end when a different line ends. For example, I have 4 lines in a sheet: Line A, Line B, Line C, Line D. I want Line A to begin when Line B begins and end when Line D ends. I want the duration to be malleable and change automatically if…
-
Dependency columns: Automations or Formulas in Start / Finish & Duration Columns
With so many posts about this why has this feature not been added or fixed? The fact that this is not a feature in Smartsheet makes it extremely difficult and inefficient to accurately determine schedules. We are utilizing Smartsheet to build out our schedule the production and forecast the completion of our products. All…
-
Inventory check
Help please! I have an inventory issue I need to work on. I have a production schedule where my production team adds line items for the PO they are supposed to work on. Each Line item may have the same item number, and could have the same quantity. I am using data shuttle to pull in my available inventory. From there I am…