-
Finding cells that aren't linked
Hi everyone. I have created a mastersheet (A dashboard), where i link cells from 10-15 other sheets (Project sheets). What i want to do is to create a report, that will "catch" any rows that are added withing the project sheets. Basically what i want to do is to keep my Dashboard up-to-date when changes happen in the…
-
Ordering Search Results
Is there a way to order search results from the Current Sheet by their line number within the sheet?
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
Limit View within a Sheet (using Web Forms)
Hello, New to Smartsheet. We would like to utilize a web form to allow customers to place orders/requests whereby the web form would populate the smartsheet for ONLY OUR INTERNAL visibilty/tracking of all requests combined. Currently, when I test this I am brought back into the sheet where I can see ALL requests. Does…
-
Smartsheet Merge search
Is there a way to search when selecting rows during a Smartsheet Merge?
-
Unable to locate document on Smartsheet website
I am currently going through the Smartsheet Lab (and finding it very helpful). I found a pdf document last week called the Help Center. It's about 300 pages long and was a pdf on their site. I can't find that document anywhere!!!! Can anyone direct me to that pdf? Thanks in advance! Lainie
-
Smartsheet won't save changes after a sorting
This morning I did a sort on one of my columns so I could review and enter data easier. When I went to save the data Smartsheet told me it couldn't and to save data more often. I tried doing the sort and then saving after the first number update and I got the same error. The only way I can save my changes is if I don't do…
-
Using "Contains" for Numbers
I'm attempting to filter a column with the following type of data: 10007789001 10007796003 10007789001 10007789002 10007801001 I tried to filter this column using "Contains" 7789. I expected every row with 10007789001 and 10007789002 would be shown. However, Smartsheet indicated that 0 rows met filter criteria. This…
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
report repeated names
Is there a function to allow me to put together a report that identifies names that appear on more than one row in a given column. In this case I am trying to bring out information on people who appear more than once in the name column, and then have the report show certain fields for those