-
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…
-
Does Smartsheet email support respond?
I have been using Smartsheets for about a year and don't seem to have much luck getting any response from Smartsheet support via email. Recently noted when they introduced multi select drop downs that the dropdown fields do not appear when you use the gmail add on. Reported this to Smartsheet via email seeking a solution…
-
We're doing something that's never been done in F1. Help us power work that matters.
Community, as an official sponsor of McLaren F1, Smartsheet has been given a permanent spot for our logo on their cars. But during the upcoming Australian Grand Prix on April 10, it's not our logo that you'll see. We're giving our spot to DeadlyScience, an Australian nonprofit that provides STEM resources and learning…
