Join us on December 8th for a free webinar "Intro to WorkApps" in this webinar we will be learning about how to create and share a customized experience of data, content, and resources, bas… (View Post)

Hey Smartsheet Community, The Community Team is excited to announce a new and exciting way to search, giving you the confidence to find exactly what you’re looking for when you need it most. We’ve en… (View Post)

Hi @Jake Gustafson You could use a VLOOKUP, you're correct! However I personally prefer INDEX(MATCH because it evaluates the two columns separately. In a VLOOKUP you put in one range that spans acros… (View Post)

Hi @Amy Shank Try simply: =AVG([LE Total Days]:[LE Total Days]) AVG won't be able to identify extra criteria, you would either need to use AVERAGEIF or AVG(COLLECT. If you want to try filtering cells… (View Post)

Not sure when it was added...but here is the silver bullet: =JOIN(SUCCESSORS([Task Name]@row), ", ") (View Post)

Hi Community, We just enabled a forms enhancement that many of you have requested: field validation. You can now add real-time validation to Text/Number fields to help collect error-free numbers, per… (View Post)

The only way to back-up a dashboard is to manually save it as a PDF. However... When creating the back-ups of the sheets and reports, the data that drives the dashboard for that particular point in t… (View Post)

Hi @lkrobot Are you referring to conversations in the Smartsheet Application, or here in the Community? Here in the Community, you can adjust your notification settings in order to be alerted wheneve… (View Post)

Hey Jessica - I think you're closer on your second formula. Instead of COUNTIF and AND, just use COUNTIFS: =COUNTIFS({Internal Comms Intake Range 2}, "New Request", {Internal Comms Intake R… (View Post)

Hi @Stepheni Norton It looks like you're missing an open parentheses after an AND, and you have extra parentheses after an IF! I've bolded the correction. Try this: =IF([email protected] = "Complete&qu… (View Post)