I created a custom worksheet field for my features, and every row in my worksheet contained formulas that were derived from other fields. The formulas in my worksheet only produce values after I manually click on the worksheet field in every record individually. If I run a List report with the worksheet information included, only those records where I have previously clicked on the worksheet show up with values, even though the data is there to calculate the formulas without entering anything into the worksheet.
It would be great if the worksheet values were populated automatically, or if I could create an automation or run a bulk edit that would trigger the worksheets to calculate.
|Release time frame||6 months|
Worksheets in newly created records will now be activated automatically. This includes records created through create modals, user story maps, the starter roadmap, and any records imported through CSV import or integrations. Worksheets on records that already existed will not be automatically activated.
Custom worksheets now update automatically for all fields. You no longer need to refresh the worksheet manually — if a worksheet is able to reference a field, then the equation will stay up to date.
We also removed the "one hop" limitation for advanced equations in custom worksheets. You can now reference fields on records more than one hop away from the initial record. For example, you could now create a worksheet on a feature that looks at a release and all features within that release to calculate remaining release capacity.