-
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.
-
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…
-
Formula Question
This is my current formula that is producing error - Unparseable, I can't seem to figure out what the issue is. =OR(IF(INDEX({Min_Skill_LTT}, MATCH([Job TItle]@row, {Minimum Skill Requirement Range 1}, 0)) = ([LTT Matrix Use]@row - 1,{Min_Skill_LTT}),"True", "False"),(IF(INDEX(MATCH([Job TItle]@row, {Minimum Skill…
