-
Random ODBC Errors AND SSIS Errors Saying Sheets doesn't Exist
Hi There I use Smart Sheet 32 bit ODBC component to connect to SmartSheet and pull data to SQL server. Suddenly I see errors randomly. There has been a random error appearing each time the SSIS package is run (SSIS package uses ODBC provided by Smarsheet), it is not stable with one sheet missing error. Each time the…
-
Working with dependencies is a nightmare
Dear Smartsheet, I have a two change requests, because at the moment working with dependencies is really inefficient and time consuming: 1. Auto calculate lag when creating dependencies: when I create a dependency it automatically changes start or end dates. This is very annoying and time consuming because you always have…
-
Smartsheet Automated Tasks
Can you create an update request to have Smartsheet read incoming data being added to a new row for duplicate information? We are considering creating a web form for people to "register" with us and want to prompt them (or our staff) if they try and register twice.
-
Will renaming a sheet change it's secure sheet link?
So I have a sheet shared with a community of engineers. I will call it Sheet A. It is also viewed by others. Recently we have brought in another team of engineers to assist with a project and I created a duplicate sheet which I will call Sheet B. Sheet B was to be identical in nature to Sheet A The new Sheet B has dates…
-
Charts From Drop down Data
I have a sheet which lists loads of data on one column there is a selection of option (open, closed, etc....) Is it possible to put a widget or chart on dashboard showing the quantity of each option?
-
Pulling Tasks into a Report Using Multiple IF(AND( formulas in the same cell
My ultimate goal is to pull data into a report from a project plan. I want to pull: * Current tasks (Tasks where TODAY falls between the Start Date and the End Date) * Upcoming Tasks (Tasks where the Start Date is within the next 7 days) * Previous Tasks (Tasks where the End Date is within the previous 7 days) * Late Tasks…
-
FORMULA - Pulling Data from last row filled
H E L P P L E A S E I have 5 rows (children) of possible data input areas. All 5 rows may not always be used. In Column "M" a number of 1,2 or 3 will be entered. Based on this number, Column "A" of the parent row should reflect "Closed" if the last row containing data is 1 "Work in Progress" if the last row containing data…
-
Automate RYGB and Children together
I have a standard project sheet. I added one column called Today that in Row1 links to a separate sheet that will be triggered everyday so that it gets Today's date (this gets you around using the Today function which only triggers when a sheet is opened), every row below that first row then has a =CellReference the cell…
-
Is there a way to know current sort criteria?
I got invited to edit a sheet, which I'm pretty sure is sorted. The sheet has way too many columns for me to quickly check the criteria. Is there a way to know what criteria the sheet is sorted on?
-
Formula Help Needed
I need a status formula for the parent row of up to 5 children rows. The children rows have a control rating of 1-3 If rows 1-5 have a control rating of 1, the status column should reflect "Closed" in the parent row. If rows 1-5 is 2 or 3 then parent row should show "Work In Progress" If ALL are blank then status should be…