-
External URL
How can I make a link to an external url so people can click on the link and it takes them to open up a webpage?
-
Average Value Errors
Hello, Was hoping someone could see what i am doing wrong here; i am attempting to take the value of two cells and average them. Both are percentages. i use the formula =AVG([average calc]33, [average calc]34) and i get the "DIVIDE BY ZERO" error. From what i read this may be due to the particular column is a dropdown list…
-
Links
Is there a way to globally add/delete links between sheets or does each link need to be added/delted individually?
-
Cell contents into Text String
Hi, I'm trying to create a column that essentially mail merges within the cell by pulling from previous columns. For example: "[Name] is [Age] and attends [School Name] school." where the bracketed terms are columns in the sheet. Can I do this in Smartsheet or is it restricted to Excel so far? Thanks!
-
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…
-
# of Attachments in a Cell
I would love to log the amount of attachments a line has in a cell. IE 3 attachments, I would like to have one of the cells read "3" so we can at a glance see how much documentation is added to the line. Does anyone know if this is possible with Smartsheet?
-
How to write VLOOKUP to source data from multiple sheets
I have a Master Project sheet and multiple individual project sheets. I need to gather one piece of data from the individual project sheets to write into the row on the Master Sheet. While VLOOKUP will work, the wizard requires me to know the sheet that I want to search. I need to reference all sheets in a workspace as 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…
-
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…
