Product questions?
Ask it here! The community's got your back.

Best Practice

Review best practices, tips and tricks, and more from fellow Community members.

Using Forms & Automation to Drive Leads
Good 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 clients in a timely manner. I broke it down step by step with video walkthroughs below:…
Using a nested IF to determine a range
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 on a single date column, but MATCH on one of 4 different columns depending on an Asset…

Other Best Practices

Speedometer Chart: Core Product
I've noticed a few people asking for Speedometer Charts in Smartsheet, so I figured I would go ahead and publish this solution that I developed. It was some years ago, so there may be better ways and / or more efficient formulas, but this should at least help get everyone started… A few notes to kick things off… This…
Sheet automation notification email tracking using a PowerAutomate Flow and Outlook
This post details how to track all sheet automation notifications emails. This solution is medium complexity and will likely require you to use an AI for some simple coding. Smartsheet allows users to automatically send email notifications from sheets. There are a few significant problems with these automated emails.…
When to use = and "" in COUNTIF formulas
I came across some weird COUNTIF functionality recently in one of my duplicate check column formulas. I wrote some exploratory formulas and wanted to share! Key Takeaways Numbers with leading 0s requires both = and "" Regular text requires "", but = is optional Regular numbers do not require = or "", but work with one or…