-
Link to Unknown Sheet
We are experiencing issues with "links to unknown sheets" popping up. See image attached. * We are saving the sheet that the link is going to as a new sheet (almost like using it as a back up), but we are clicking so that the "links do not carry over", so it should not be happening from this task. * We have no way of where…
-
Dynamic Drop Down list
Hello! As you have already seen in forums, many customers demand drop down lists, that uses master column as the list entires. Whenever you add a new entry, the list in all other sheets updates with this new item. Do you have any other way to get this done, for example, external database linking or other solutions. We are…
-
Dropdown and Pick Lists
Hello, Is it possible to populate a dropdown list with the column of a seperate sheet. Scenario. We have a Sheet containing all our Assets and one for all our Work Orders. When creating a work order (new row) in the work order sheet, or via a webform, we would like to pick the relevant asset the work is linked to. If we…
-
Drop down list at the cell level
Hello, Is it possible to create a drop down that is held within a cell level or are all drop downs required at the column level? We want different potentials for each cell in a column as apposed to one large data set. Thanks!
-
Conditional Formatting Cell Level
Hi, I need help or guidance in Conditional Formatting at CELL Level not all rows or all columns. For example: if the % is Below 30 its RED, 30 - 80 its Yellow and 80 + is Green. Please see attached the photo for more clarification. Thanks and please help.
-
Formula help
How would i add the children rows, that has the below sum? Grandparent - SUM??? Parent - ="Total: " + COUNTIF(CHILDREN(), 1) Child - Tick box Hope this makes sense.
-
Embedding / Linking Images
Hi, I was wondering if there is a way to embed/link an image to present itself in the cell if that cell was to presented as 'true'. I want to be able to tick a checkbox and for the 'true' value to present an image. Thank you.
-
Feature Request: We need advanced functions to connect and control multiple sheets
I am a project manager at a construction company so we use Smartsheets pretty heavily for everything from vehicle mileage reporting to project forecasting. The single biggest improvement that I would like to be done for Smartsheets is for greater links between multiple sheets. We are thinking about migrating to Sage 100, a…
-
IF Function and Checkboxes
Hi, I am currently working on a project where I will have multiple check boxes on a row where each checkbox is going to of different values (true/false). I need a formula that will look over the checkboxes and only give me the value of the selected checkbox and then with this the value of that cell with be presented at the…
-
Toolbar Inconsistencies
I have created a "Master Sheet" that I have to import each day and have linked up other tabs/sheet to that Master Sheet to filter out on the information my technicians need to see. On the Master Sheet I have the full options on the toolbar, but on the linked tabs/sheet there are hardly any options. For example, my…