What Smartsheet column types are supported for editing?

SmartSyncApp's Smart Form supports the most common Smartsheet column types for editing: Text/Number, Dropdown List, Multi-Select Dropdown, Date, Checkbox, and Symbol columns. This comprehensive support covers over 95% of typical data entry and operational update use cases within the Smartsheet ecosystem.

Optimized Rendering for Data Consistency:

Our rendering engine is designed to mirror Smartsheet's native constraints to maintain data integrity. For example, a Dropdown column in Smartsheet will automatically render as a searchable select menu in the Smart Form, complete with all your pre-defined options. Date columns trigger a mobile-friendly calendar picker, and Multi-Select fields allow users to tag multiple items which are then written back to Smartsheet in the correct internal array format. This ensures that your sheet-level formulas and conditional formatting continue to work perfectly after every submission.

Read-Only and System Column Handling:

To preserve the structural integrity of your sheets, certain specialized columns are handled as read-only. Contact List columns can be prefilled to show who is currently responsible for a task, but changes must be made via Smartsheet directly to ensure notification workflows trigger correctly. Similarly, System Columns (like Auto-Number, Created By, and Modified Date) are strictly read-only and updated automatically by Smartsheet upon your form submission. This prevents users from accidentally breaking your internal tracking logic.

Displaying Calculations with Helper Columns:

A powerful advanced feature of Smart Forms is the ability to display read-only formula results. By including a formula-based "Helper Column" in your form, you can show users real-time calculations like "Total Days Overdue" or "Current Variance" based on their prefilled data. This transforms the form from a simple entry point into an interactive dashboard, providing stakeholders with immediate context before they submit their updates. If your sheet contains an unsupported column type, SmartSyncApp gracefully skips it, ensuring the rest of your form remains functional and responsive.