Using Smartsheet

Archives for September 2021

Discussion List

  • NETWORKDAYS Formula using TODAY() not returning expected results
    In Using Smartsheet
    I'm using a Formula to calculate the pays past due from today. The current formula I'm using is =NETWORKDAYS([Due Date],TODAY()), but the results aren't coming out as I would have anticipated. 9/29/2021 returns 2 days past due 9/30/2021 …
    Accepted
    12 5
    Accepted Answer 12 views 5 comments Most recent by Jsmaldo2 Using Smartsheet
  • "Other Sheets" in Resource View
    In Using Smartsheet
    Hello- My username is identified as a resource on "Other Sheets" in the Resource View - which I can't identify. Is there a way to see what those unlinked sheets are? I suspect it might be from a client's Smartsheet - is there a w…
    Answered - Pending Review
    30 2
    Answered - Pending Review 30 views 2 comments Most recent by Amanda V Using Smartsheet
  • Tracking automated emails sent
    In Using Smartsheet
    I have been using the Automated send function to send emails to specific people on a specific date. I am wondering if there is a way to track if the email was opened from the backend of SmartSheets. Staff I work with say that the emails ar…
    Answered - Pending Review
    58 1
    Answered - Pending Review 58 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Moving from Test Smartsheet to using real data - Smartsheet
    In Using Smartsheet
    This Community is awesome. Thanks for all the help you didn't know I got from here. This is a question whose answer I can't find. We recently created a Smartsheet for tracking procurement data. In testing, we've used 15 or so rows. It doe…
    Answered - Pending Review
    12 4
    Answered - Pending Review 12 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • How to set what day and time I want Task Owners to be notified?
    In Using Smartsheet
    I want to set notifications up for my staff that only occur during business hours. Monday - Friday at 8AM
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • How can I create a page visit tracker for my Smartsheet portal
    In Using Smartsheet
    I am not looking to use the activity log as I do not find it useful for actual visit tracking because it also tracks other things like changes I make to pages - and I am always updating things. I was looking at Zapier but no idea how to …
    Answered - Pending Review
    25 2
    Answered - Pending Review 25 views 2 comments Most recent by Kristine Gagne, CSM, CSSGB Using Smartsheet
  • Remove or Suppress Blank Rows in Report
    In Using Smartsheet
    Hello. I have a report that is displaying 15-20 rows of data (will never exceed 25 rows). The problem is that the report appears to default to showing 50 rows regardless of the data. As a result, in the current state, there will always …
    Accepted
    37 3
    Accepted Answer 37 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Distribution Lists and cell contacts
    In Using Smartsheet
    I have two questions regarding contacts and automation... 1) When setting up an automated workflow, instead of entering for example 25 individual emails (sending to specific people), can you enter a distribution list? Many times we need a…
    Answered - Pending Review
    22 3
    Answered - Pending Review 22 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • Date format is wrong
    In Using Smartsheet
    Hi Expert, I did a data upload via data shuffle from an excel file including the following English dates e.g. Dec 1., Feb 1, April But in Smartsheet it looks like this: So it switch the month with the day. My settings are english in smart…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Cell linking to sheet summaries
    In Using Smartsheet
    Hello friends, I'm attempting to create a new grid that links to sheet summary data in a few different spaces so my one grid autopopulates while the other sheet summaries change. Is this possible? Thanks!
    Accepted
    23 6
    Accepted Answer 23 views 6 comments Most recent by Paul Newcome Using Smartsheet