Auto-check checkbox upon import?
Options
Hi, I have a Smartsheet sheet that is fed by Formstack submissions. I added a checkbox to a column - how do I auto-check that checkbox on all imported rows?
Some background: this sheet feeds into a report along with several other sheets. All the rows on this sheet are from one district, and I want to note on the report that these are from that district with a checkbox.
Any insights are greatly appreciated!
Answers
-
You can use the change-the-value-of-a-cell-automation.
In your case, set the trigger when rows are added, then change the checkbox's value to "checked."
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!