I've seen more than one question in the community about determining if predecessor tasks are complete for the purpose of notifying the successor task owner that the task can be started. I wanted to create a demo to show that this can be done. It's a bit time intensive and requires quite a number of helper columns. Here's…
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…
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…
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"…