-
Scanner won't "Enter" after scan
Hi! When I scan data in Word or Excel, after I scan it will auto "Enter" to the next line but when I scan in a SmartSheet form, I have to "Tab" to get to the next line after a scan. Are there specific settings in SmartSheet to be able to automatically "Enter" to the next line after a scan or is this not possible with…
-
How do you use Smartsheet in a Learning & Development Enviroment?
I am relatively new to Smartsheet, and I never knew how robust this product was and learning everyday! I'm curious to know how you utilize Smartsheet in a Learning & Development enviroment. Please share your feedback and examples (if you are able) I'm looking to be inspired to how to leverage Smartsheet next.
-
How to Allow People viewing a shared link to change views
Hello, I want people outside of my organization who are viewing a live link of my sheet to be able to view the sheet in calendar or board view. Is this possible? If not, any recommendations on how a sheet can be manipulated to offer a beeter viewing experience than just the default grid view? For people viewing outside the…
-
Dashboard
I have a dashboard roll-up sheet that is using a COUNTIF =COUNTIFS({sheetname}, [Column2]10) formula to count the number of cases an employee has. I know the employee has cases on the sheet, but the field shows zero, instead of the number of cases that are assigned to them.
-
How can I create a Dynamic View to show contact field information by hoovering over the contact?
In a regular sheet, when you hover over a contact field it will show the contact's information. (Email, Phone etc). Is there a way to create a Dynamic view to all be able to display the contact field's information by hovering over it?
-
I have some questions about using smartsheet for managing sign ups for courses
The aim is micromanage / manually edit lists as little as possible. I would like to use automation for situations below: Is there a way to automatically stop/block the option for duplicate enrollments from the same person ( based on email address)? Set a default maximum limit for enrollments? ( stop registration option…
-
Index match returns a wrong value
Anyone able to help with an Index/match formula that returns a wrong value? We've a formula that is returning a wrong value. I believe the formula is correct (it's the same way I write it in .xls). We are referencing another Smartsheet in the formula. I understand if I was getting an error (#invalid value, #No match), but…
-
Automatically move rows within a single sheet
I pulled a template for a Team Productivity Hub (https://app.smartsheet.com/b/publish?EQBCT=f29e0f2c058f4563853d6497ce554bcc) from the solution center and the sheet for tasks had originally moved completed tasks to the "completed" hierarchy automatically, but now that i've made copies for my team and input some formulas…
-
Finding 'send' history form a row
Hi - Is there a way to see what was sent when using the function "Send" when selecting a specific row? I see the activity log notes some information, but I don't see this anywhere. Am I missing it? Is it a better practice to always CC myself to keep track of what I am sending? Thanks! SarahB
-
Consolodating rows with the same primary column
My company is looking to replace an Excel spreadsheet that we use to record the results of an order report in SAP. The problem we have is that SAP populates each order by the lines on that order. So for example; if an order has 8 lines on it, it lists that order 8 times with the quantity of each line rather than showing…
