Best Practice

Archives for June 2020

Can you use 2 match criterias in an index/match formula?
I am looking to structure an index and match formula, but it needs to match two columns of data and having some troubles. Is this possible or will I need to create a work-around with a Join function in another column?
Formulas for Calculating Time
I have decided to create a post that consolidates all of the different time based solutions that I have put together. Some of these solutions can be made more efficient or condensed into fewer but larger formulas. I am still going through these working on making them more efficient and tweaking them, but all of them have…
Month Name written as Text for Today's Date
what function return month name from date "i.e =TEXT(MONTH(TODAY()),"MMM")"?

Other Best Practices

Smartsheet Bridge: Iterate over an array using JavaScript - Column names from a sheet
Here is the full solution for how to iterate over an array using JavaScript. Smartsheet provides a partial and incorrect solution at . Below is the actual solution. Using Bridge and JavaScript, this example extracts the list of column names from a sheet and provides them as the only elements in an array. The JavaScript…
TIP: Calculations on an AutoNumber Column
I've noticed when trying to run formulas on my AutoNumber column, that it doesn't always work. Here's a table of some of the results. For each row I changed the autonumber "Numerical Places" from 0 to 00 to 000 to 0000. You'll see that the results conclude that Formulas on an Auto Number column MUST USE SINGLE DIGIT…
Fixing Form Submissions Not Appearing in your Sheet
Issue: Have you ever filled out a form and noticed that the submissions aren't showing up in the sheet where they should? This is a common problem, but there's a simple solution! Cause: This usually happens because rows with previous data in your sheet were cleared using the "backspace" key instead of using the "delete"…