Microsoft Excel Fields Available to OnePager Express for Version 7.2
Overview
Microsoft Excel is very flexible when it comes to its column definitions. OnePager requires only that you prepare your Microsoft Excel source plan with at least three required fields before importing it to OnePager. These required fields serve the function for Task Name, a task Start Date and a task Finish Date. OnePager scans the fields that are imported from Microsoft Excel and attempts to find fields that are reasonably close to the three fields mentioned earlier. OnePager then posts then on page 2 of the OnePager choices form where you have an opportunity to confirm or change the mapping. For a typical Microsoft Excel source plan the second page (page 2) of the OnePager choices form looks like this:
-06082023.png)
Additionally, if you are creating a chart where you want to display constraints between tasks, we advise that you add and populate a Smartsheet column called Predecessor. OnePager's imported column analysis process is very good at finding and properly categorizing your user defined fields.
