Discussion List

• Can a report contain a query string or prompt?

  In Using Smartsheet

  I'm looking for a way for a user running a report to input a query response that is then used as the filter in a report. For example, a report lists all projects assigned to a variety of sponsors. Can I somehow create a prompt so that ea…

  RDarmstadt

  10/06/21

  Accepted

  13 4

  Accepted Answer 13 views 4 comments 0 points Most recent by Andrée Starå 10/06/21Using Smartsheet
• I'm creating a form that will require hundreds of entries, how do I make this easy for the end user?

  In Apps, Integrations, and Add Ons

  I'm recreating a form that was once a multi-tab excel spreadsheet. This link will be hosted on our webpage and will require users to list up to hundreds of names. What is the most efficient way for them to do this? Should I have them attac…

  JSapp

  10/02/21

  Answered - Pending Review

  30 4

  Answered - Pending Review 30 views 4 comments 0 points Most recent by Andrée Starå 10/02/21Apps, Integrations, and Add Ons
• Formula Assistance (COUNTM??)

  In Formulas and Functions

  Hello all, My team and I are hoping to build a formula to do the following: First, identify all items that belong to "Group A," then count how many items the rows that belong to group A have in "Color." So, for examp…

  Alison

  09/30/21

  Accepted

  76 7

  Accepted Answer 76 views 7 comments 0 points Most recent by Paul Newcome 09/30/21Formulas and Functions
• How to have a Date and Time format for Date Column Properties?

  In Formulas and Functions

  Hi, Do we have Date and Time format now for Date columns?

  Benjo09

  09/29/21

  Answered - Pending Review

  2358 14

  Answered - Pending Review 2.4K views 14 comments 3 points Most recent by AmyB 09/29/21Formulas and Functions
• workflow to be triggered when cell is changed to specific value

  In Using Smartsheet

  Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!

  Brennan Montoni

  09/29/21

  Answered - Pending Review

  15 1

  Answered - Pending Review 15 views 1 comment 0 points Most recent by Andrée Starå 09/29/21Using Smartsheet
• Is there a way to automatically share editing access to underlying reports?

  In Using Smartsheet

  I have created a dashboard and would like anyone with access to be able to add information on rows in the underlying reports that are embedded. I'd prefer to be able to do this without adding each individual to the workspace. In WorkApps, …

  Kim Goldsmith

  09/29/21

  Answered - Pending Review

  3 3

  Answered - Pending Review 3 views 3 comments 0 points Most recent by Paul Newcome 09/29/21Using Smartsheet
• Contact List - Extract First / Last Name?

  In Formulas and Functions

  Is it possible to target the first or last name of a contact inside an alert email? So e.g. if I have a contact called "John Doe" in a [Contact] column, and I send an alert with Dear {{Contact}} I will get the full name. Is there…

  Manu

  09/28/21

  Accepted

  1040 16

  Accepted Answer 1K views 16 comments 0 points Most recent by Paul Newcome 09/28/21Formulas and Functions
• Card View - way to adjust lane width?

  In Using Smartsheet

  This there a way to adjust the width? Using it for a daily check-in of tasks and unless we switch to grid view.... we can't read the entire task. TIA!

  Julie Fleming

  09/28/21

  Accepted

  3 1

  Accepted Answer 3 views 1 comment 0 points Most recent by Krissia B 09/28/21Using Smartsheet
• I want to count items within current month without needing to change the month manually

  In Formulas and Functions

  I need to report on the number of items that appear in the current month to date. Is there a formula that can be applied without necessitating manual entry of changing the month manually?

  TeeM

  09/28/21

  Accepted

  532 22

  Accepted Answer 532 views 22 comments 0 points Most recent by Raul Cabrera 09/28/21Formulas and Functions
• How do I auto-save a sheet without opening the sheet?

  In Using Smartsheet

  I use conditional formatting. When I review the dashboard, the formatting doesn't update until I go to the sheet and save. I would like the sheet to save automatically when conditional formatting makes changes. Thank You.

  Lawrence West

  09/27/21

  Answered - Pending Review

  207 17

  Answered - Pending Review 207 views 17 comments 1 point Most recent by Andrée Starå 09/27/21Using Smartsheet