Using Smartsheet
Archives for July 2019
Discussion List
-
REFRESH A SHEETIn Using SmartsheetI linked two sheets (A and B) On sheet A are the name of customers from all country with other informations about them. Sheet B is the active sheet, I choose a country in a cell with a dropdown list. On other cells, I use VLOOK link to …
-
Task Management Best Practices/SolutionsIn Using SmartsheetHello all! I'm currently designing an updated workflow and I'd love to gather some best practices/what's worked well from other users. Right now, the project team makes an update in the sheet, notes which column they changed in the "…
-
Returning last entry in a database columnIn Using SmartsheetI have created a database that adds a new line against a date each day. From this I am building some metrics and then a dashboard which will show Daily Performance but also week to date, annual etc. I am struggling to reference the databa…Answered - Pending Review 523 views 12 comments 0 points Most recent by Adam Kinney Using Smartsheet
-
Workaround for when you require COUNTIFS with OR?In Using SmartsheetI'm building a dashboard based off my grid and am doing a bunch of COUNTIFS to get the data I need for the dashboard, since we don't want to have to update it manually. I'm stuck when it comes to doing COUNTIFS where there are multiple…
-
I lost my Executive accessIn Using SmartsheetHi guys, I have support ticket opened and I need asap status. pls help me. tk number: 03466957. I lost my executive access and my all professionals are stopped. We use the smartsheet to all tasks with Kanban, timesheet, etc. I haven't su…
-
How to keep changes in chart colors?In Using SmartsheetI have created dashboards that include charts, for which I have selected specific colors for each category. Data for the charts come from different sheets. However, everytime I add a new row to the source sheet, I have to update manually t…
-
Automation Not Working for RemindersIn Using SmartsheetHello! I've set up a Reminder automation and its not sending an email. Here's an example of what ive tried. I have set this up to reminder me once a day before the start date. I have also tested out sending the reminder on the actual…
-
How to create report with rows instead of columns?In Using SmartsheetWhy does Smartsheet only allow you to make a report with columns and not rows? I'm using my sheet to coordinate data for events. Each row has a specific event, each column has different details for the events (date, location, hotel, meals,…
-
Send automated alert when a cell changes from a specific value to a different specific value.In Using SmartsheetHi team, I was attempting to build out a process for an automated alert to be sent based on a value in a cell (drop-down list(constant)) changing to a different value (also from the dropdown list) of that same cell. I would like want the…
-
Relational Database CapabilitiesIn Using SmartsheetI am looking at relating multiple tables of data together for both data presentation/data entry and reporting purposes. I have the following tables: implementation projects (high level project info like scope, start date, end date, projec…
