-
Smartsheet named to Fast Company's Annual List of Most Innovative Companies 2023 ⚡️
Have you heard the news? Smartsheet was just named to Fast Company's annual list of the Most Innovative Companies 2023 in the Enterprise category! We were recognized for creating a unified digital workplace, allowing users to drive meaningful change. They specifically called out DataTable, Brandfolder, and Outfit. 🎉 Read…
-
Is the Docusign Integration Bidirectional?
Can anyone tell me if the Docusign Integration is Bidrectional or not? Use Case Present users with a Docusign form which ask them to read a waiver and enter three pieces of information: Name Email Event identifier And then sign the form. We want the data from the three fields to populate a Smartsheet grid and then attach…
-
NEW! Clickable Title Widget in Dashboards
Hi Community! Dashboard editors can now configure the title widget to be a hyperlink. This means you can now redirect dashboard viewers to a location of your choosing when the title widget is clicked, giving you greater flexibility to decide how you want your audience to interact with your dashboard. This feature is…
-
Notify an assignee that the predecessor has complete his task.
I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario. The task in row 27 needs row 25 & 26 to be done ( active checkbox in column "done").…
-
Multi-select fields with INDEX/MATCH (or COLLECT) with multiple values
Hello fellow Smartsheet users! I am running into unique problem and more importantly finding the way to do something within Smartsheet. A little background. I build a request intake/workflow management tool for my Marketing department at a global organization. Users make Design, Content, Web, and Video requests through…
-
COUNTIFS formula for criteria in two columns in another sheet not working
I am counting how many ads are live out of how many total and I'm unable to get the COUNTIFS formula to work. The cell should reference another sheet and count how many ads are live in each category. The formula I'm using is coming up unparesable even though I referenced Smartsheet's many help pages on this topic. What am…
-
How to create Data Shuttle filters to replicate "has any of" for an offload of data
Hi there! I am trying to recreate a report that we have in the Data Shuttle offload so we can quickly access the csv files. I can't quite figure out how to recreate "Has any of" in the filters options. As you can see in the screenshots we use it a few times for our logic to get the correct subset of folks into the list.…
-
Formula help - reference data from 2nd sheet, with conditions
Hi, I’m looking for help with a formula for my sheet. Images of my sheets are below Goal: I want to auto-populate the Holiday column in Sheet 1 with data from Sheet 2, based on certain conditions. Populate Sheet 1 Holiday column with data from Sheet 2 Holiday column, only if: Sheet 1 Date matches Sheet 2 Date, AND Sheet 2…
-
Ticketing Solution Use & Building the Sheets/Forms
hello! i have created a form to receive marketing requests. many fields required but many not, as the submitter will not have all of the necessary info at the time of making the request. i have thus shared the sheet with all users as editors so they can provide that additional info as they acquire it and created a checkbox…
-
Automate your campaign management process with the Facebook Ads integration on Bridge by Smartsheet
Hi Community, Before this release, customers were not able to automate work actions between Smartsheet and Facebook Ads. With this release, we now have an out-of-box integration with Facebook Ads that provides a way for customers to automate their campaign management process between Facebook & Smartsheet Licensed users…