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 i…
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 lar…
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 e…
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…
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 h…
