NEW! Your survival guide to formulas is here. Meet the Formula Handbook.

Allegra Silcox

Hi Community, 

Whether you’re summing child rows, calculating budget minus actual, or doing cross-sheet data lookups with multiple criteria, formulas are a must for tailoring solutions to your needs.

The new Formula Handbook is here to help formula beginners and pros alike. This template contains: 

• A glossary of all Smartsheet functions
• 100+ examples of commonly used and advanced formulas
• A dashboard packed with resources

Have a great idea for the template set? Let us know in the comments or come tell us in person at our customer conference, Engage, this fall! 

Licensed users on Business and Enterprise plans can download the template set today! You can also find it and other useful templates by accessing the Solution Center via the marketplace, or by hitting the + button in the left rail in Smartsheet.

You can also stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements for the platform of your choosing, delivered to your inbox. As new releases occur, you will receive a daily email with news of what's released. (Emails will only send daily, Monday-Friday, as new releases are available).

Allegra

Jeff Reisman

I love it! Great idea!

Nick Burrus

This is pretty awesome! Perfect for those learning formulas or need visual examples!

heyjay

@Allegra Silcox How did you get the GIF to work on your dashboard?

https://community.smartsheet.com/discussion/93946/new-your-survival-guide-to-formulas-is-here-meet-the-formula-handbook

Allegra Silcox

@heyjay thanks for the question! The GIF was embedded into a Web Content Widget, using a BrandFolder CDN link. You can learn more about BrandFolder + Smartsheet here.

del314

It would be nice if the EU account got access to this handbook. It's quite ridiculous that it is restricted to US account.... how does one justify it even? no privacy, no GDPR, no anti-trust, no GAFA BS.... just formulas... Sorry but being told by the IT support that EU accounts can't access but to submit a feature request here it drove me a tad bit crazy.

seriously!

Thanks for fixing this!!

Allegra Silcox

https://community.smartsheet.com/discussion/comment/356165#Comment_356165

Thanks for your feedback, and we agree, which is why we are pleased to announce that the Formula Handbook is finally live in the EU region Solution Center as well! You can download in-app here, from the marketplace here, or by searching the Solution Center for "Formula Handbook". And don't forget to check back in periodically for updated versions!

Cheers,

Allegra Silcox | Sr. Product Marketing Manager

del314

Thank you!!!!!!!

it'll be so useful for our users!

TrippK

This is an outstanding resource @Allegra Silcox 👏 Thank you!

Brandi T

This is amazing! Thank you, @Allegra Silcox, for organizing this resource! We have been trying to put together something similar but this is WORLDS better! ❤❤

Roger_B

Thank you, @Allegra Silcox - this is amazing!

Paula Cosentino

This is amazing!! Great work!

Kristine Candela

Is there an easy way to make sure the information is up to date/ comprehensive? Or are the current formulas static and no new functionality is coming? For example, if we get a DUPLICATE (column1,[column2],...) in the future the users will not see it as this is a downloaded at a moment in time template, it won't include new formulas.

Jeff Reisman

@Kristine Candela Probably a good idea to set a reminder every few months to refresh the template.

Personally, I use the Functions List (which links to Help Pages) and the Formula Error Messages page much more often, so much so that there's a "Formula Help" folder in my browser's bookmark bar so I can get there quickly. They're linked in my signature.

K.Candela.KCS

I do reference those as well but usually just search them. I like the idea of a bookmark folder, to which I will also add the formula dashboard template so thanks for sharing!

What is nice about the Dashboard Template is the use cases. I was struggling with finding the sequence of form entries for a specific group (first occurrence, second, etc.) without having to worry about a sheet being sorted and the Advanced Formula Examples helped me find a solution. Also fun to see what people have come up with to solve advanced challenges. I look forward to AI making things easier in the future. Maybe that will also remove the need for the Template altogether?