Best Practice

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…

  Genevieve P

  07/19/21

  124 6

  Announcement 124 views 6 comments 6 points Most recent by Genevieve P 07/19/21
• 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…

  Tanner Polzin

  07/24/21

  205 6

  205 views 6 comments 6 points Most recent by Matt Stewart 07/24/21
• 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…

  Paul Newcome

  07/23/21

  28 6

  28 views 6 comments 6 points Most recent by [email protected] 07/23/21
• 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 …

  Paul Newcome

  07/23/21

  6567 94

  6.6K views 94 comments 12 points Most recent by Helen Rim 07/23/21
• 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…

  Tom Zylstra

  07/17/21

  403 6

  403 views 6 comments 16 points Most recent by Sing Chen 07/17/21
• @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.

  Kirstine

  05/05/21

  Accepted

  321 4

  Accepted Answer 321 views 4 comments 0 points Most recent by Frank Falco 05/05/21
• 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…

  Andrée Starå

  04/22/21

  59 0

  59 views 0 comments 7 points Started by Andrée Starå 04/22/21
• 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…

  [email protected]

  01/15/21

  152 11

  152 views 11 comments 6 points Most recent by [email protected] 01/15/21
• 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…

  Travis

  12/02/20

  11683 17

  11.7K views 17 comments 6 points Most recent by Mike Wilday 12/02/20