-
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…
-
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…
-
Smartsheet Gov JAWS (Screen Reader) Computability and Accessibility
In the current build of Smartsheet Gov, the highlighted cell in a sheet does not have the cell text / input connected to the name of the cell to be read by a screen reader. Three different screen reading software's were not successful in trying to read aloud the text in the highlighted / in focus cell. Having this issue…
-
Help to select a value based on row number
Hi all - I am trying to determine if a task is ready to start based on all of the predecessors being 100% complete. I have numerous tasks with more than 1 predecessor and I've parsed out all the predecessors into individual columns (pred_1, pred_2, etc) like this I'd like for the ready to start column to indicate yes, if…
-
Collapse and Expand
Is there anyway to stop the sheet from expanding all children every time someone goes into the sheet? Annoying is all. Thanks in advance for any advice.