Is it possible to replicate Excel-like spreadsheet capability in AdaptiveWork?

Question

I had a excel sheet with multiple tabs. Now i want to add similar data in planview on run time without using data loader or without uploading file. E.g sku name, description, units, cost. Which component can best handle such dataset? I want this data to be available in all milestones. Can anyone share configuration?

DrewMiddleton · Accepted Answer

Hi Deepti,Many of my customers wantto replicate Excel-like spreadsheet capability in AdaptiveWork. In these cases, Itypically advise my clients that a grid view of related items will probably be the closest they can get to emulating rows in an Excel sheet. For example, think of a Milestone that has a number of Risk records associated with it. A view of the Milestone can include a Risks panel that has one row for each related Risk. In the case of SKUs related to a Milestone, the same concept can apply. Each SKU would need to be a SKU record, and would need to be related to the Milestone via either a link or a reverse reference-to-object field (thought that limits the capability). Since there’s no native SKU record type in AdaptiveWork, best practice would be to create a SKU Custom Object, including a custom link between SKUs and Milestones. Fields on the SKU record would include sku name (standard field), description (standard field), units (custom field), and cost (custom field).

Planview Customer Community

Login with SSO

Planview Customer Community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded