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 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

Power Automate - Post Attachments to Row/Sheet
Hello everyone! I spent WAY to long looking for this answer so I thought I would share it with the Community in hopes of helping someone else. Problem: Adding attachments to rows/sheet is not possible through the standard SmartSheet Connector Solution: This can only be done by creating a Custom Connector. It CANNOT be done…
Script in Python to download all PDF attachments in a Sheet
Hi Guys, Created a basic script to download all PDFs from a sheet. Use case: I use Document Builder to create documents from field inspections. However, we need to store these in sharepoint for redundancy. This script basically pulls all "PDFs" so you can then migrate them where you need to. I don't want to pay an…
HOW TO: Duplicate / Copy a Group
Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…