Discussion List

  • Auto Sort
    In Using Smartsheet
    Hello, Is there any way to create automation that will automatically sort a sheet when a cell is updated or changed? Thank you, Sean
    197 4
    Accepted Answer 197 views 4 comments Most recent by latheobald89201 Using Smartsheet
  • Locating the parent of a parent
    In Formulas and Functions
    I am trying to take the value from the primary column of a level 0 parent and insert it into another column in a level 2 child. =PARENT([Task Name]@row) works fine when there is only level 0 and level 1. Something like parent of a parent i…
    427 5
    Accepted Answer 427 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Row ID (ignoring blank cells)
    In Formulas and Functions
    I am trying to create a sheet which identifies batches of 25 rows and creates a specific batch ID, before moving onto the next 25 rows. (Batch Column) I also need to formula to ignore rows with blanks entries. (Row ID) I hope somebody is…
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by Jen R Formulas and Functions
  • Conditional Logic for Header fields in Forms
    In Formulas and Functions
    Hi all, With the new update to Smartsheet forms, we are able to add conditional logic to designated fields within a form. However, I noticed that while you can set logic to only populate designated fields when a certain option is selected,…
    Answered - Pending Review
    447 10
    Answered - Pending Review 447 views 10 comments Most recent by Genevieve P. Formulas and Functions
  • Is there a way to set up Cumulative Roll Up Notification Emails
    In Formulas and Functions
    We have a large team all working within a workspace, and they already get a TON of email. Is there a way to set up a single daily notification for new items assigned to team members, without it being an email for each sheet? We have abou…
    Answered - Pending Review
    45 8
    Answered - Pending Review 45 views 8 comments Most recent by specoop Formulas and Functions
  • SUMIFS Formula
    In Formulas and Functions
    I am attempting to get the sum of two separate columns Number of Participants Reached (Adults) + Number of Participants Reached (Students) for FY 2021 only All 3 sets of numbers are in different columns I can get the total sum of the two …
    14 2
    Accepted Answer 14 views 2 comments Most recent by ashleeco Formulas and Functions
  • Flag is others are flagged
    In Formulas and Functions
    I have an "At Risk" column and I want one row to flag if any in a set range of others are flagged. For example, on a project template, I have a "Planning Milestone"; I want the milestone to flag if any rows within the …
    12 3
    Accepted Answer 12 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Is there a way to refer to another "row" within comments/conversations? Refer to unique rows via URL
    In Using Smartsheet
    As a Smartsheet user, I want to be able to refer to a row when typing a comment so I can better give context and easily give URL's to navigate quickly to the other row. ---------------------- Use Case: I leave a comment on Row 1. Row 1 is…
    138 6
    Accepted Answer 138 views 6 comments Most recent by Brett Wyrick Using Smartsheet
  • Project Phases of Development
    In Using Smartsheet
    Hello! I am trying to find a way to show the development stage of a project so it can be rolled into a report. Basically if all of the tasks in a section are complete, then the development stage would be the name of the next header task. F…
    190 18
    Accepted Answer 190 views 18 comments Most recent by Sharon B Using Smartsheet
  • Lock or Store Date/Value Solution without using Zapier
    In Best Practice
    Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another shee…
    2747 26
    2.7K views 26 comments Most recent by Andrée Starå Best Practice