Hello, we currently utilize amazon QuickSight to build automated dashboards from other websites. Would it be possible to connect the data collected on Smartsheet to build automated dashboards on QuickSight?
I've built a Smartsheet (with some help from the ProDesk) that assigns a task to a contact based on the date/time of a request. The sheet looks at the date stamp on the request then references another sheet (using WEEKNUMBER and WEEKDAY) to see who's "on duty" at that time. That contact's name is pulled into an "Assigned"…
I need a formula that will do the following: When the Date in WKU column has past place the latest NewPromiseDate from the AllPromiseDates column in the cell.
I'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like additional rows to automatically be included in my summary calculations. The formulas I'm…
Hi, We have need to Automatically sync data from Smartsheet into Googlesheet, please advice, how this can be achieved. is there a way to have Smartsheets automatically sync to a Google Sheet? Please advice. tx Dhananjay Nagarkar
Is it possible to connect a drop down column in a sheet to another sheet as a lookup for relevant values? This would enable centralized control of values ensuring they are accurate for form submission. Looking at articles on Data Uploader, this would be too powerful for the specific use case below. Obj: Users are only able…
I am hitting the users endpoint(https://api.smartsheet.com/2.0/users) to get all of our user information. I am trying to find out inactive users based on last login date. The API call doesn't return me the last login information for any user. I can see this information when I export the csv of the users from the admin…
I need to link about 50 cells in my Inventory sheet to the SAME cell in my Inventory Price sheet. Can I do that as a group? I tried selecting all the cells in my Inventory sheet, then selected the linking option, navigate to the Inventory Price Sheet and select the cell I need linked to ALL 50 cells. Using this process it…
We are looking to move away from Excel based 'status reports' that are emailed each week to something that is more readily accessible and easier to manage/track. At a high level, each week an employee completes a status report on the projects/tasks they are working on or have completed. Our requirements would include: Have…
I'm creating a dashboard for our team on submitted tickets but the requestor wants this data to show total ticket amount per team member and also have it broke down into completion dates. Ex: Jane Doe: Total Tickets 100 Completed 1 day or less - 50 Completed in 2 days - 25 Completed in 3 or more - 50 I'm pulling this data…
