-
Reports Book Not Working
Hi, Not sure if anyone can help me on this, as Support haven't responded after emails sent 3 weeks ago... I have created a report that pulls in information from different sheets, on specific criteria. when i set this criteria in the filters section on each individual sheet, i return 243 results from all 3 sheets combined…
-
Multiple references to another sheet
Hi, so obviously if I want to have a given cell in one sheet reference another cell in a different sheet, this is easily achieved. But let's say I want cell A1 in one sheet to reference A1 in a different sheet, followed by B1 referencing B1 and so on... do I have to set these up one cell at a time??? If I try to grab the…
-
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…
-
Web Content Widgets
Is the Web Content Widgets available in the free version of Smartsheet? Which plan do I get this Widgets, Individual, Business, Enterprise ou Premium Options?
-
Sheet froze and won't open now
I was working in a very important sheet and it froze. It is still listed under sheets on my home screen, but I get an error message every time I open it. It's an errorCode: 6. Anyone else run into this? I have logged out and logged back in, but this one sheet won't open in any browser and I need to access it asap.
-
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.
-
count cells with the same date that are NOTBLANK
Hi, I have 2 Grids (Sheets) and I would like to insert the formula in every row that counts the rows that are NOTBLANK in other sheet with the same date. Sheet1 has several ROWS with the same dates. Sheet2 has only one date per ROW. I would like to COUNT Sheet1 rows that have equal Dates and insert it in every row in…
