Auto-check checkbox upon import?

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!

Find more posts tagged with

Sheets

Importing and Exporting

Accepted answers

All comments

jmyzk_cloudsmart_jp

Hi @amy_ilearning

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."

https://help.smartsheet.com/articles/2482299-change-cell-value-in-an-automated-workflow

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.