Dynamic View and Formulas on smartsheet
We have created a source sheet to collect data, in the source sheet we used formulas to pull in (cross-reference) data from other smartsheets. When we created the dynamic view from this source sheet our team members are unable to update the information in the dynamic view.
From digging around we have found out that using formulas in the cell source sheet makes the fields 'read-only'. Is there a workaround?