Best Practice

Learn best practices, tips and tricks, and more from fellow Community members!

Discussion List

  • New Community Category: Best Practice
    In Best Practice
    Welcome to the Best Practice Category in Community!  With so many great discussions happening we see incredible solutions being built out by our members. This category is a place to find creative solutions, tips and tricks, and best practi…
    124 6
    Announcement 124 views 6 comments Most recent by Genevieve P
  • Formula To Indicate A Task Is Ready Because Predecessors Are Complete [Solution]
    In Best Practice
    I have seen many posts about people wanting the ability to indicate a particular task/row is ready to begin because all of the predecessors are complete (many of them archived). All of the proposed solutions had short comings (e.g. only wo…
    205 6
    205 views 6 comments Most recent by Matt Stewart
  • Using a nested IF to determine a range
    In Best Practice
    Here's a little tid-bit I just figured out today... You can use a nested IF statement to output ranges/cross sheet references that are to be evaluated. The particular use case that led to this was an INDEX/MATCH where we wanted to INDEX o…
    28 6
    28 views 6 comments Most recent by [email protected]
  • Formulas for Calculating Time
    In Best Practice
    I have decided to create a post that consolidates all of the different time based solutions that I have put together. Some of these solutions can be made more efficient or condensed into fewer but larger formulas. I am still going through …
    6567 94
    6.6K views 94 comments Most recent by Helen Rim
  • Work Breakdown Structure (WBS) - Column Formula Configuration
    In Best Practice
    Hello Everyone, Recently myself and two fellow Smartsheet Sales Engineers, @Lea Gikas and @Dave Stanley got together to create a WBS solution powered by Column Formulas. We wanted to provide the resulting configuration to the community in…
    403 6
    403 views 6 comments Most recent by Sing Chen
  • @row referencing cell above
    In Best Practice
    Is there a way that I can use @row to reference the cell above? I'm creating a formula to check for duplicates and I want to compare details in the current row to the one above.
    Accepted
    321 4
    Accepted Answer 321 views 4 comments Most recent by Frank Falco
  • Tips & Tricks for the new experience
    In Best Practice
    Hi everyone, I hope you're well and safe! I thought it would be a good idea to start a thread with tips & tricks for the new experience. Here's my first one, and it's a big one, IMHO. Full-Screen View Have you found any? I hope th…
    59 0
    59 views 0 comments Started by Andrée Starå
  • List of date formula I have used repeatedly
    In Best Practice
    Doing this so I have an ongoing list of functioning optimized formulas , keeping it in the community in case it helps someone else. Please feel free to comment with your own, but I'm keeping the most basic of the formulas out of this. Bel…
    152 11
    152 views 11 comments Most recent by [email protected]
  • Working with Symbol Formulas
    In Best Practice
    Hello Smartsheet Community! As our Community grows, I am starting to see some trends about features and workarounds users want to learn more about. For these topics, I am starting a new series of announcements. In this series, I will write…
    11683 17
    11.7K views 17 comments Most recent by Mike Wilday