-
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…
-
2 sheets for daily production and production schedule for a PO (month) =Status
I have two sheets. One sheet for tracking daily production and another sheet that tracks the production for the month. I have a status column that matches on both sheets. On the production schedule I have that status of the reference number. If production is working on that reference number it has a status of Work in…
-
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…
-
Daily PO Status tracker, with visual alert, if delay in any of multiple department's queues
Need to combine multiple department's reports into I'm assuming a dashboard that visually shows the status of the parts on order for the PO with status of the queues after flipped to an order. I can't figure out how to push daily status of the parts on order for the PO to a central report, but maintains the history of the…
-
How Generate Quotes Via Smartsheet
I am looking at making our internal quote system entirely through smartsheet. Is there a way in which i can expand a row in order to make relatively complex quoting system which almost acts as a mini excel sheet per row. the output would be a price but if needed the breakdown is seen. I would like the the Quote numbering…