-
SmartSheet Reports have limitations that make them useless for business
We recently learned the hard way that there is a limit to how many sheets a report can access! We use the report feature to create individual task lists throughout our company. Each task list searches all sheets for names in an Assigned To column and refines the search looking for a value of "Needs Action" in the Status…
-
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.…
-
Show changes made in the last 24 hours (only)?
Is there a way to have a smartsheet highlight only those changes that have been made in the last n hours? I look for changes to one of our smartsheets every morning and copy them to another file. We have yellow change highlights turned on but I'm finding that they can remain there for days, making it hard to see only…
-
Creating Yes/No Checkboxes in a Web Form
Hi, I'm trying to create a web form using a Smartsheet with about 30 questions in it, and I want to add in check boxes so that the user can answer a question Yes or No. However, the only way I can think to do this is to create the question as a column, and then create a seperate Yes and a seperate No column to give me the…
-
Cut and paste rows from Excel without importing an entire sheet
I have created a sheet for registrations and only want to add new registrations from an existing spreadsheet. How do I cut or copy and paste the new rows without importing the entire Excel spreadsheet? I only need to add the new information.
-
Creating multiple row entries from one submitted web form?
Back with (what I believe to be) another obscure question that I don't know how to search for nor find an answer to. I'm attempting to work around the issue of not being able to have more than two dates in a row - we run news stories to multiple audiences so would prefer to have one row for each story, with up to ~10 date…
-
Report Request: Show new discussions added within a time period
I would like to be able to publish any rows that have recieved new comments over the past 7 days along with what those comments are. Is that possible?
-
Improving the context of answers to community questions
Hi all, can I suggest that as there are lots of new users to the community since it was launched only a few months ago, that existing and new members add a little detail about themselves? That extra info should make it easier to see the context in which a question is being framed, so the answer is more appropriate?…
-
Setting up alerts on a Report
We have a report that is populated when a cell is checked off from a tracking list. I would like to send an alert to co-worker when a new row is added to the report.
-
TICKBOXES IN SMARTSHEET
I am trying to record telemarketing results for multiple users, who want a simple sheet to "tick" one of four boxes as to the quality of the call, every time they make one. This needs to be automatically updated, and centralised onto a single sheet, with the ability to breakdown into user and date. Ideally, we dont wish to…