-
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"…
-
Smartsheet Dashboard Accessibility Color Themes
When designing Smartsheet dashboards, accessibility should be a top priority. This is when Smartsheet Dashboard Color Themes come to action! No more picking random colors or spending painstaking amounts of time making sure the colors you want to use actually work together. Now you can access 9 different color themes…