-
Linking to data on SQL server
Does anyone know how I can link to data on an SQL server so that I can create a dynamic sales pipeline with data drawn from estimates actually created?
-
Link to cells in a different sheet
Hi SC, I need to link cells across two different sheets and I am looking for a way to avoid having to create the link one by one. The cells to be linked are located in adjacent columns so ideally, I would just need to create the first link for the first column and then drag the formula through all the columns. I tried it,…
-
Restrict to List values only
I noticed when I create a drop down list for contacts and select "Restrict to list values only" it works great in the main sheet, but when I view the same column in a report it is not restricted to list values only. All the contacts shown on that sheet also shows in that list. Am I doing something wrong? or is there a…
-
Round the clock schedule
Hi, when planning / executing big IT application cutover or implementation, which sometimes can span for 1 week, the involved teams will work in shifts in a 24 7 schedule. To track all this work and its dependencies, a detailed schedule is created including start date, start time, finish date and finish time with time…
-
How do I link a project worksheet into the row of a separate worksheet?
Hi, I'm new to Smartsheet and hoping to find a solution to the following: How do you link a worksheet to a row of another worksheet? For example, I have a worksheet for my Master Project List that lists about 70 projects. Each project has a separate worksheet for its individual project tasks/deliverables. I am hoping there…
-
Hyperlinks in Smartsheet
Is it possible to configure the Hyperlink in Smartsheet to open a local program in my computer like what we do normally in Excell ?
-
Add Trend Lines/Line Graphs to SIGHTS
Looking for a way to visualize my data in an easier way. Love how I can create trend lines for others to look at in Excel. Would love to have this feature in Smartsheet.
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.
-
Adding "color & logo" formats to existing Workspace & Sheets
Hello, I have a workspace with 3 sheets in it and I would like to change the color & logo settings. EAch time I go to the Color & Logo settings it takes me back the to the main "Sheets" area on the left and doesn't allow me to change the Workspace or sheets on that workspace. What am I missing ? Thanks.
-
Task Duration - Partial day at beginning of period, not the end
Hi, I notice when you add a half day duration to a task, it places the half day at the end of the period, for example a start date of 13/11/17 (Monday) with a duration of 2.5 days will result in the half day being on the Wednesday. Is it possible to make the half day on the Monday and the full day on the Wednesday? I'm…
