-
Linking cells based on matching criteria
I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link…
-
Multiple discussion for one row - MISSING
Hi, Since the last update it is not possible to make more than one discussion per line. Please make this undone. I'am really unhappy! Best regards
-
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…
-
Updates to SmartSheet - do other editors/viewers get notified?
When a smartsheet is updated or changed, do other editors/viewers get notified of changes? Or, do they simply see them when they login?
-
Adding current location to Web Form from mobile device
Hi Everybody! Health care providers are using WebForms to submit invoices from mobile units (RVs). Since the location of the RVs change (and we're in NY so addresses = intersections <> map-friendly), is there any way to add location from the mobile device being used to submit the Web Form? Apologies in advance if this…
-
Calculating the task completion
I know this must be simple but unfortunately so am I I am managing a project and I have set it up with a fairly standard heirarchy of task (parent) and sub tasks (child). The sub tasks have a number of individual work items associated with them and I want to use the number of individual work items completed to…
-
Two Smartsheets- linked- add row in one- can it auto add linked in 2nd?
Hi, I"m working with two smartsheets for test planning.... The primary sheet goes over the what is being tested, which teams, the planned volume & dates. The second sheet is for results reporting and links back to some key fields in the primary sheet. Problem I have- if i add data to the primary (ie new test event)- is…
-
native dynamic drop down functionality- Card View & Reports
I know there are many different discussions requesting dynamic dropdown functionality native in Smartsheet without a third party solution but I feel the need to start another to emphasize the importance. I believe the need makes even more sense with Card View functionality Smartsheet recently introduced…especially in an…
-
Kanban Project management
Hi Would it be possible to have a Kanban view of the projects I have setup? It could be organized easily by have a collumn with the different Kanban collumns as menu items in a dropdown menu. Then, when entering Kanban view all tasks displays as items in the Kanban collumn they belong to. This would alow a flexible…
-
How to automate Harvey Balls based on % Complete Summary Field
Hi everyone, I'm looking to find a way to automate the Harvey Balls symbols based on a % complete Summary field where the percente complete is 25% 50%, 75% or 100%. Any help is greatly appreciated. Thanks, Robert
