Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.

Discussion List

  • Count Function
    In Formulas and Functions
    My excel spreadsheet that I'm attempting to replicate uses the following formula to count if any value is listed in column M. =COUNT(All!M:M). So if I have 3 items/rows listed in Column M it would return a 3, regardless of the value o…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Darin Wagner Formulas and Functions
  • Count if older than
    In Formulas and Functions
    Trying to count the number of dates that are older than "Todays" date by 14 days. So if today is 4.16.21, anything that was listed in my date column that is 14 days older than 4.16.21 would be counted. Example: Date Colum has 2 r…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Darin Wagner Formulas and Functions
  • Parent Child Formulas
    In Formulas and Functions
    Good morning! I have child rows with column formulas to find the average from other columns. Is it possible to add a parent row formula to find the average of the child rows? Hard to explain hopefully the image will help. The parent row …
    Accepted
    14 10
    Accepted Answer 14 views 10 comments Most recent by Autumn Montegna Formulas and Functions
  • Data validation for multiselect dropdown lists?
    In Using Smartsheet
    I am embedding a Smartsheet form in an online training module, to collect and validate the answers in the absence of an LMS. For a single dropdown, I found it easy - I create a question column, in which I collect the answer, and an answer …
    Unanswered
    13 0
    Question 13 views 0 comments Started by Karoly Ban Matei Using Smartsheet
  • Dynamic View Attachments in Mobile View
    In Premium Apps and Integrations
    When viewing Dynamic View on a phone through a mobile browser, is there a way to add attachments? I see the option to add attachments on the desktop view, but not in the mobile view.
    Unanswered
    9 0
    Question 9 views 0 comments Started by Alyssa Steinruck Premium Apps and Integrations
  • Stacked Bar Chart with Percentages
    In Formulas and Functions
    Hi There! I am trying to track and present progress on key milestones made by multiple countries to share with our donor. I want to be able to show the average percentage completed overall for the milestone, but comprised of that show the …
    Answered - Pending Review
    26 18
    Answered - Pending Review 26 views 18 comments Most recent by Sophie Knudson Formulas and Functions
  • Lock Request Update Action
    In Using Smartsheet
    Is there a way to lock/stop being able to use the button sent in a Request Update Action in the workflow? For example this button gets sent via email and after a certain date if they click that "open update form" button, I want t…
    Unanswered
    9 0
    Question 9 views 0 comments Started by Kimberlee Maciel Using Smartsheet
  • New Dashboard Editor/View
    In Using Smartsheet
    We are using dashboard views of data, where the underlying reports have a criteria based on the current user. Typically if these reports are empty they would show as such in the dashboard. With the new dashboard editing tool these report…
    Answered - Pending Review
    38 5
    Answered - Pending Review 38 views 5 comments Most recent by Rob Hagan Using Smartsheet
  • Help on formula: count if with multiple criteria
    In Formulas and Functions
    Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, &quo…
    5611 26
    5.6K views 26 comments Most recent by Benjamin Brunnette Formulas and Functions
  • Calculate days between first and last instance
    In Formulas and Functions
    Need help calculating the number of days between an items first entry on a list to it's latest entry. List is populated via Forms with newest entries at top of list. For example below (in yellow) would return 84 days. If possible, would li…
    Accepted
    19 10
    Accepted Answer 19 views 10 comments Most recent by Dave Schierman Formulas and Functions