Best Practice
Learn best practices, tips and tricks, and more from fellow Community members!
Discussion List
-
For Every one want to have More color symbol for health Status column.In Best PracticeDear Community Memebers, I saw many equations asking to have More color symbol for health Status column, so i added this post to be a simple reference to solve this issue and with your help and comments we can develop it to match the most …
-
Using Forms & Automation to Drive LeadsIn Best PracticeGood afternoon Smartsheet Community, We use Smartsheet Forms sometimes for some client contact forms to track real estate or other sales leads. We found it helps to use Forms and Automations to make it super easy to contact potential clien…
-
Formula To Indicate A Task Is Ready Because Predecessors Are Complete [Solution]In Best PracticeI 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…
-
Using a nested IF to determine a rangeIn Best PracticeHere'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…
-
Tips & Tricks for the new experienceIn Best PracticeHi 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…
-
Working with Symbol FormulasIn Best PracticeHello 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…
