-
Beta of New UI?
Is there any way to get a beta view of the new UI? Just encountering UI issues while working in currnet view. Small things like makin the tabs smaller or multi row. Using more of the screen etc. I saw the new release will have many of my concerns addressed. But really wondering how to get on the inside track of beta views…
-
Want to track resource allocation
Has anyone had any luck with this? Want to do something similar to the features in Microsoft Project. I have a lot of design projects going on and want to be able to allocate resources (my designers) to projects and be alerted to when a resource is exhausted. Has anyone been able to figure this out? I would really…
-
Formula - Multiple IF rules
I have the following formula working fine! In short, based on the value of the “Application/Product” value, I auto populate the value of a Contact column. =IF([Application/Product]1 = "Edits", "Jane Smith", IF([Application/Product]1 = "Scripts", "John Doe", IF([Application/Product]1 = "Matrix", "Billy Bob",…
-
Losing Data #2
There was a previous post on this topic (called Losing Data), and I tried commenting on there first. However I don't think my comment was picked up by anyone as there is no obvious way to show all new comments in the forum instead of just new posts. Anyway I have come across a losing data scenario a few times in the short…
-
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…
