-
"Save As New" doesn't retain Auto data...
I use a separate sheet to track projects in each calendar year. This means I need to carry over partially completed projects rows from the previous year's sheet to the next year's sheet. I've used a "Save as New" to duplicate the sheet, formatting and data, but my "Submitted" column which contains the "Date Created" now…
-
SmartSheet Names and Same Sheetnames in SSIS Differ
Hello, The sheet names differ in Smart Sheet and SSIS, the same sheet is shown with different names in SSIS when reading it via smart Sheet ODBC. Sheets in SmarSheet.Com Sheet in SSIS 801 Centre Road801 Centre Road__8524479023343492s_(Home) Canterbury Road Canterbury Road__4221359879415684s_(Home) Burke Road Construction…
-
Gantt chart & conditional formatting
Hi! Currently the conditionial format of gantt Chart bars is limited to the format option "entire row". As we use the entire row format for visualize the sheet structure (levels), it would be nice to have also the bar Color depending on a single column. Kind regards Michael
-
Alerts & Actions
Hi Everyone, I am looking to see if you can set up an alert that will trigger and email say if the dollar value is over 1500. Has anyone run across this? Thanks. J
-
OFFSET FUNCTION
Hi SC, Does Smartsheet have an equivalent of the EXCEL OFFSET FUNCTION ? Thanks
-
Collapsing option for filter
Hi. It would be very helpful, if there would be an additional option within filters. With the help of this option it should be possible to preset the collapsing in the filtered list. E.g.: Option is set to level 2 => the filtered list is reduced to levels 1 and 2 but single lines can be expanded to deeper levels (if…
-
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…