-
How do I get a response and update from smartsheet support?!!
Does anyone know how to get them to respond? we are paying for a licence, but you have any issues there is an initial response and any further update requests you make are ignored. This is not a new issue, as it has been like this for all the years we have been using it ……. Great when it works, but no support when you need…
-
NETDAYS returning #INVALID DATA TYPE
Hi - I'm trying to calculate the number of days between two dates in a sheet. I have both of my columns that contain the start and end dates set up as DATE column type. They both contain dates. I use the formula "=NETDAYS([Hotel Check-In Date]@row, [Hotel Check-Out Date]@row)". I have tried making the results column a…
-
How do I export a list of Group members/names?
Hello, we have a lot of Groups with many members. I need to do an audit of each Group's members to make sure people are in the right Group (we've had some turnover/people changing teams). I am looking for a way to export to Excel each Group's member list so I can easily do that audit. I don't see an obvious option for…
-
Customer Service
Has anyone experienced that Smartsheet Account Reps are not responding? I have been waiting for an answer for weeks, despite multiple follow-ups. We wanted to purchase Smartsheet licenses for our team, but our Account Rep is not responding to my emails. I would think that Smartsheet would want to sell their licenses…
-
How long should it take for Smartsheet support to respond?
I've had a case open for like three weeks now with nothing but the initial autoresponder response saying Smartsheet would get back to me as soon as possible. I've replied a couple times to try and get a response with no luck. After two weeks, I also tried contacting Sales and one of the random Smartsheet marketing email…
-
Open files in a new window
A recent update in Smartsheet changed the way we view files. Previously, when you clicked on a file it opened automatically in a new tab and this meant you could have several files open at once and the ability to move between them. The update removed this function and now the file opens in a preview window with little…
-
CONTAINS formula not working
I am trying to count the number of times the number "1" appears in a range using CONTAINS formula. There can be multiples numbers within the same cell seperated by comma. I have tried doing it via a dropdownlist too but its not working. Hoping for someone to help. Thanks
-
#INVALID COLUMN VALUE error
Hello Community, I'm trying to combine two formulas but keep getting an error. The first formula sums children if it's a parent row or leaves the cell blank. The second look for the most recent data in a row (I have month in the columns from July to June). They work independently but when I combine them I keep getting an…
-
Smartsheet Support Ticket Emails: Include More Details in the Emails!
Whenever I get an email from Smartsheet about a support ticket that was updated, closed, requests more information, or about anything for that matter, it almost never includes important details of the ticket. Easy-to-implement recommendations for EVERY email sent by support regarding a ticket: Include a direct link to the…
-
In a Gantt with many rows, how to color a date range that spans all rows in a column?
In other words, I have a developed Gantt with many rows. There's an event that I'd like to track in the Gantt that occurs over the course of several weeks. I would like to highlight that date range but not just have it on one row, I want it present on all rows in order to show impact on all activities.