Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for February 2017
Discussion List
Is there a way to see all sheets that have been shared?
As one of our Company user with a license, I do some overviews of Smartsheet with new Users. Is there a way to view all of the sheets a non-licensed user has been shared? This would allow me to go over those sheets specifically. It would also be helpful in the cases where a user changes roles and some of the access may…
Finding text between two parenthesis
I am trying to pull the text between two parenthesis and place in another field. In the screen shot attached I am wanting to get the data between the two parenthesis in the "Requested by (NetID) field and place it in the "Requested by NetID"). In other words, I want "dj32" to be in the second field. Anyone have any ideas…
Auto fill with data from another sheet
So I'm not sure if this is possible. I have a sheet that has all of our employees on it. The list has four regional directors as the parent. Under them as the child are 5-10 field managers. What I'd like to have happen is if I made another sheet and set it up so if entered "Tech 1" it would auto fill who their "Field…
Webform Responder Tracking
How do you- or can you track a responder who has filled in a webform request- appart from asking for details in the actual webform itself- ie can you see the email addresses for responders?
Sum up data NOT using parent rows
Hi team, got a tricky one me thinks..... (screen show below for assistance). I need to add the quantity required on any given day. I was using parent rows - which worked fine, until the dates went out of sequence - which will happen and must happen given our workflows. Basically I want to know at any point in time the…
JOIN formulas
Hi team, Just discovered JOIN formaula - very helpful! However, I can't seem to get it to join THREE coloumns together. I'm using this formaula for joining two which is working perfect: =JOIN([Quantity (m3)]1:[Time required]1, "-") However, when I try and add in another (so a third coloumn) it errors. =JOIN([Quantity…
Gannt Chart headers
Hi Team, Curerntly, the ganntt view has a couple of customisable options - to change how the dates are shown. Pic one named 'current' is one of the current views. However, what i really need is the abiolity to break it down from one day into hour slots - see my poorly scribbled 'can this be done' pic.... Please please…
MIssing +/- icons next to my parent rows
Today - I think after an update. I don't see any +/- icons next to my parent rows for collapsing/expanding. Behavior still works but no icons. I think I am also missing icon in predecessor cells, when you want to add a lag time. I think it looks like an apostrophe. Anyone else notice this today.
View your Card View by Assigned To
I think I have found a novel way of using an Assigned to column that has a contact list column property as the lanes in Card View, BUT I wanted to check with the community if this approach wont cause problems. What I do is when I want to view my Card View by all the people in lanes to whom I have assigned tasks but to do…
SUMIF with check mark
I have a column (Have we paid for this container?) and it contains checkmarks. I want to add up the total cost in another column (Cost) IF the checkmark is checked in the other column. This is what I have come up with, I get the #Unparseable error. Where am I going wrong? =SUMIF([Have we paid for this container?]1:[Have we…