-
Feature Request - Sort/filter by History
OK, so there are many useful applications for being able to sort rows by the history of the cell. In one way this is possible if you have the 'date modified' column in your sheet, but this only shows that something in the row was modified. If you have multiple columns, this requires you to check the cells for which changed…
-
Advanced User Training
Does anyone know if Smartsheet has ever had (or is planning) advanced user training available, similar to the Smartsheet Academy you can attend in person? or a User's Conference? It would be much easier to sit in a room with other advanced users and share ideas in person vs. on the web.
-
Autonumbering does not always work?
Hi there I have an order reference column set to auto number. It is prefixed by the date and then an autonumber for the order on that day. For one user the autonumber does not always seem to work, if he creates a new line it uses the same number as the line above. This means we end up with two identical order numbers. For…
-
Workflows with alerts
How do I create templates for common workflows that trigger alerts when predecessor tasks are completed?
-
Date-based formulas now broken across 100+ sheets
As a result of the latest release and supposed "formula enhancements", we now have more than 100 client-facing project sheets whose "status" column is entirely broken. Previously our status column looked at the task Start Date, End Date, and Target Date, and intelligently spit out a text value such as Due Soon, In…
-
Problems with formula AVGW
Hi The formula AVGW is not working anymore with the column duration. I mean when we write: AVGW(CHILDREN([% Planned]8), CHILDREN(Duration8)) and duration is in days 1d, 2d, etc... the formula doesn't count the column duration as a number. This starts after the Smartsheet update!
-
How can i see who has changed which portion of the sheet?
Hi, I am having a situation wherein we are 2 Admins sharing the same Project sheet. I know that this is not the best way of handling the project/sheet. I would like to know, how do i see which portions of the plan is updated by my counterpart? I see a message that some changes are done and i need to refresh the sheet. I…
-
Pulling data from column on drop downlist
Hi, Is it possible to pull the data of "column-1" of "Sheet-1" to dropdown list in "column-1" of "Sheet-2" ? What actually my requirement is: I have a task list defined on "Column-1" of "Sheet-1". I need to create a RFI (Request For Information) webform for site engineers ("Sheet-2") where they select the task list from…
-
Excel spreadsheet with calendar and schedule
Good afternoon, I hope someone could please give me some ideas if it's at all possible to do with smartsheet or in excel??? I have an excel spreadsheet that was created by a professional. I'll try to explain the information it has on it and what I'd like to do with it. It has the date, Hebrew date, and then in in many…
-
Custom View on Grid/Gantt
Often when I setout a new schedule layout I end up with a number of columns either auto- calculating, which I subsequently hide, or tracking finance, progress, comments etc and the view is busy... I'd love to be able to Save custom views, so I can select chosen columns to view. IE. Custom View 1 - Finance. Shows me the…
