-
REFRESH A SHEET
I 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 the dropdown list cells. Finally, by choosing a country name in the drowdown list I have…
-
Task Management Best Practices/Solutions
Hello 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 "Changes" field, and then flags the row. This sends an automated notification to a partner,…
-
Returning last entry in a database column
I 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 database and return the last entry in a column. It seems that Lookup, Vlookup or Index…
-
Workaround for when you require COUNTIFS with OR?
I'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 acceptable criteria. This is the formula I'm trying to use and not getting any luck…
-
I lost my Executive access
Hi 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 support number.. I sent e-mail but until now I haven't status.
-
How to keep changes in chart colors?
I 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 the range of data in the dashboard. When I try to update the dashboard range, the app…
-
Automation Not Working for Reminders
Hello! 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 start date. I haven't seen any emails come through and I'm not sure what the issue is. If…
-
How to create report with rows instead of columns?
Why 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, etc) and I need to take information from only certain rows to create a report for…
-
Send automated alert when a cell changes from a specific value to a different specific value.
Hi 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 alert sent if it was being changed from that specific value to another specific value.…
-
Relational Database Capabilities
I 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, project indicators, etc.), customers, customer contacts, development requests (SCRs), etc.…
