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

  • Announcement

    Join the new group for Bridge by Smartsheet!
    In Premium Apps and Integrations
    We've launched a new group for Bridge users! We hope this is a space for you to find answers to your questions, provide help to others, and connect with people with similar interests and use cases. Ask your questions about building workflo…
    57 0
    Announcement 57 views 0 comments Started by Diana Yeh Premium Apps and Integrations
  • Lookup formula instead of value
    In Formulas and Functions
    I am trying to use vlookup to use a formula based on the lookup value, instead of used nested if statements.. is there a way to return the formula instead of the value on the lookup tablet?
    Unanswered
    4 0
    Question 4 views 0 comments Started by Sean Morford Formulas and Functions
  • Calendar App- Multiple date display
    In Premium Apps and Integrations
    Hi there, I've been searching the learning center but can't find my answer. Our projects track events by EITHER a start/end date OR Due Date/Activation Date. Is there a way to display BOTH dates on the calendar app? The settings …
    Answered - Pending Review
    53 2
    Answered - Pending Review 53 views 2 comments Most recent by Ross Novotny Premium Apps and Integrations
  • Roll up not working as expected
    In Using Smartsheet
    I have a project with several tasks that are children of a parent task. The roll-up of the Work and Duration fields of the parent item are not working as expected. For some parent tasks, the roll-up seems fine, but I have other parents who…
    Unanswered
    2 0
    Question 2 views 0 comments Started by Michael Sisco Using Smartsheet
  • Formulas and functions in forms
    In Formulas and Functions
    Hi, When building a form I am wondering if there is any way to include formulas or other ways to use logic to solve the case described below: I have two input fields that the user will populate with numbers. Is there a way to compare the c…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Formula Woes
    In Formulas and Functions
    My old formula: =COUNTIFS({Implementation Rollup Type}, OR(FIND("new", LOWER(@cell)) > 0, FIND("exist", LOWER(@cell)) > 0), {Implementation Rollup Work Start}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) <= [1/7/19…
    65 11
    65 views 11 comments Most recent by Cat Werbeck Formulas and Functions
  • Accessing form fields in form submission URL
    In Premium Apps and Integrations
    Is it possible to access form field values to pass them as a query string in the form submission URL Example below; (Image)
    Answered - Pending Review
    6 1
    Answered - Pending Review 6 views 1 comment Most recent by Andrée Starå Premium Apps and Integrations
  • Inbound cell link loses timestamp info and only shows date
    In Using Smartsheet
    Hello! I am trying to capture times clocked in and out by a team. I created 2 input sheets, one that captures time in via a system timestamp of last modified, and another to capture the timestamp for when one clocks out. I am then pulli…
    Unanswered
    5 0
    Question 5 views 0 comments Started by Archita Dasgupta Using Smartsheet
  • COUNTIFS + FIND Question
    In Formulas and Functions
    Hi I am trying to figure out how to count the number of times during the week that there is a revision to a project. The revisions are figured out by looking at the Estimate #. If the Estimate # has an "R" in them then I need the…
    Answered - Pending Review
    10 3
    Answered - Pending Review 10 views 3 comments Most recent by David Tutwiler Formulas and Functions
  • Checkbox formula with percentage
    In Formulas and Functions
    Smartsheet guru's-- I'm still learning how to use all of Smartsheet's assets. I am trying to show a percentage for checked boxes. Can someone help me with the formula part? Thank you! (Image)
    Accepted
    15 10
    Accepted Answer 15 views 10 comments Most recent by David Tutwiler Formulas and Functions
  • Referencing a sheet
    In Formulas and Functions
    Hi! I'm wondering if there is any way to reference a full sheet. If you are able to do that and then write formulas that include columns within that referenced sheet, will that work? Thanks!
    Answered - Pending Review
    5 2
    Answered - Pending Review 5 views 2 comments Most recent by clairee42221 Formulas and Functions