-
Technical Issues with Formulas in Smartsheet
I am currently experiencing significant technical issues with complex formulas in my Smartsheet. The formulas are extensive and connect multiple sheets, each containing over 3000 rows. Unfortunately, I am receiving error messages indicating that the formulas are unable to access all the rows, and I am also encountering…
-
When I upgraded from a trial account to a paid 'Pro' account I lost access to certain functions.
Hello, I recently upgraded my account from a trial to a Pro account and I am unable to do certain things. I am able to click 'Add column right' or 'Add column left' but not actually able to add a column. Additionally, certain functions are greyed out, such as 'delete column' and 'rename column'. I checked and I am still…
-
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…
-
From ESRI GIS to Smartsheet
I came across many articles regarding connection from Smartsheet to GIS, but I'm interested in getting attributes out of GIS and into Smartsheet. We have many program administrators need information from GIS and manipulate it to create and track projects.
