Discussion List

• Using CountIfs to track a column will multiple options

  In Formulas and Functions

  Hi everyone I have a multi select column that I am trying to use a countifs statement to count of instances of a name. However it only returns cells where only the name exist and nothing else. Does anyone know how to make it that it counts…

  Earl P

  04/21/22

  Accepted

  27 4

  Answered ✓ 27 views 4 comments 0 points Most recent by Paul Newcome 04/21/22Formulas and Functions
• Smartsheet Object ID - Where is it?

  In Apps, Integrations, and Add Ons

  Can anyone help with above, I urgently need to find the location of this to set connection to teams? Thanks

  Dan Harris

  04/20/22

  Answered - Pending Review

  63 4

  Answered - Pending Review 63 views 4 comments 0 points Most recent by Genevieve P. 04/20/22Apps, Integrations, and Add Ons
• How to Back-up Sheets?

  In Using Smartsheet

  Is there is a backup in the cloud of our sheets? Do you have any recommendations to prevent loss of data should something happen? Should we be saving a back up daily or regularly?

  Stephanie Bauder

  04/13/22

  Accepted

  431 5

  Answered ✓ 431 views 5 comments 0 points Most recent by marc4 04/13/22Using Smartsheet
• Smartsheet Mobile - Active Directory

  In Using Smartsheet

  When providing access to Smartsheet Mobile in the Active Directory can we specify only specific people to have access to the Smartsheet Mobile App.

  SSBridges

  04/12/22

  Answered - Pending Review

  14 1

  Answered - Pending Review 14 views 1 comment 0 points Most recent by Genevieve P. 04/12/22Using Smartsheet
• Open a Hyperlink In Excel App

  In Apps, Integrations, and Add Ons

  I have a sheet with a SharePoint link to an Excel file in a cell. When I click on that link, it opens by default in the Excel online app. Is there a way to change the default so that it opens in Excel's desktop version?

  DylBlake

  03/27/22

  Answered - Pending Review

  27 1

  Answered - Pending Review 27 views 1 comment 0 points Most recent by Gia Thinh 03/27/22Apps, Integrations, and Add Ons
• contacts

  In Using Smartsheet

  I have entered my smartsheet contacts manually including their email and name. Afterwards when using my contacts to send out update requests, only the email for the person is displayed for about 1/2 my list, the other 1/2 has both email an…

  Kristy Moreno

  03/17/22

  23 2

  23 views 2 comments 0 points Most recent by Fabien Soullier 03/17/22Using Smartsheet
• Send alert to task's assignee when predecessor task's status changes to complete

  In Formulas and Functions

  Hi all. New, enthusiastic user here hoping for some guidance. In setting up a repeating process, I have dependencies/predecessors clearly identified. Wonderful! Now, how does one set an alert/notification to auto-send to a task's assignee …

  quinn.farley85191

  03/17/22

  457 5

  457 views 5 comments 0 points Most recent by Paul Newcome 03/17/22Formulas and Functions
• User Access Review and Approval

  In Using Smartsheet

  Hello, I am trying to create a workflow for role owners to review and approve their user access. Role Owners have multiple users- so I don't want to have an email go out for each user. Has anyone created a report like this?

  Tanya P

  03/16/22

  Accepted

  74 3

  Answered ✓ 74 views 3 comments 0 points Most recent by Genevieve P. 03/16/22Using Smartsheet
• Can a one to many relationship be created in Smartsheets?

  In API & Developers

  For example I have sheet A that has my master list and all components within a "Kit".  On sheet B I have multiple kits and would like to reference all the included components.  I get that you can link cell to another just like an…

  Dean Sund

  03/14/22

  584 3

  584 views 3 comments 0 points Most recent by Pam Parrish 03/14/22API & Developers
• Contact list in forms

  In Using Smartsheet

  My sheet has an "assigned to" column, but I am wanting to reference my contact list for the available options.  I know when I am directly editing the sheet, I can begin typing the contact name/email address and will see a list of…

  lleslie001

  03/10/22

  2238 13

  2.2K views 13 comments 2 points Most recent by Andrée Starå 03/10/22Using Smartsheet