-
Relational Smartsheets
I would love to be able to connect sheets via a unique ID that is common to the sheets. Making sheets relational would be very helpful because we could have multiple related sheets, and avoid having to add common fields across all sheets. I'm maturing a program using SS, and if I had the ability to relate sheets it would…
-
Is there any way to select only specific columns to be included in alert messages that are sent out
Is there any way to select only specific columns to be included in alert messages that are sent out using the SmartSheet Automation feature? Currently, I set up an alert. And it displays all of the columns, even if I hide certain columns in the sheet. I'd like to be able to select which columns are sent and included as…
-
How do I create a IF(AND formula combining multiple cross references?
In this screenshot I am sharing my rollup data sheet. Of the 6 Total Amex CB Count, I am trying to determine how many of those each of our Branches has but I keep getting different errors using formula: =COUNTIFS({Dispute & Chargeback intake sheet branch}, CONTAINS([Data Points]32, @cell), IF(AND({Dispute & Chargeback…
-
Line Breaks in Text Fields on Forms
We would like to be able to use line breaks in the text fields of forms. For example, if you are typing data into a form linked to a smartsheet, it would be helpful to have the capability to skip lines or "enter" to the next line to continue inputting information. This would be helpful in both data organization and…
-
Editable Date and Contact Fields in Outlook Add-In
Presently the Outlook add-in for Smartsheet does not allow you to edit date or contact fields. I feel like it would be beneficial for those that track tasks in Smartsheet (from email requests) to assign due dates and email addresses in contact fields. We currently use a department smartsheet and a contact column to tell…
-
Dashboards Updating With Weekly Metrics
Hello, I'm trying to figure out how to have our dashboard update automatically when we work off of weekly periods. In other words, we are adding daily metrics that tally into weekly periods. Those weekly periods are collapsed and saved for historical data. Currently, I have to edit the data in the dashboard widget every…
-
Quickbooks & Smartsheet
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for invoices): The power of Smartsheet i.e. (approvals, communication, notes) makes this a beautiful…
-
Work Flow and Automation help
I am attempting to set up a workflow sheet between operations, sales, and owner. The idea would be to have master sheet where information is fed to it through multiple sources. Once the master sheet has all of the data needed it would then feed to sales and the owners to give them a snapshot of their work. Is it possible…
-
Resource Management Question
Hello, Using the PMO SmartSheet template, I have created a PMO to organize all of our Information Technology projects. It is working well and rolling up to the Portfolio Level. What I am struggling with and need advise on is my IT team has a lot of little projects that they can complete in 1-2 weeks and usually requires…
-
Printing a dashboard
I have a Dashboard/Portal that I'm using to display reports that (at this time) collectively take about 2-3 screens to page through. This components of the dashboard change many times daily, so we want to be able to take a daily snapshot to maintain as a running status (and send it out by email). However, roughly one-third…