Difference between revisions of "Testing Article1"

From OnePager Documentation
Jump to: navigation, search
(Related Links)
(Split Resources in the Chart)
 
(241 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
==Introduction==
 
==Introduction==
  
To use '''OnePager Bundle''' with Smartsheet you are required to have access to the [http://www.smartsheet.com/ www.smartsheet.com] website, possess an account, and have Smartsheet '''source plans '''that can be '''imported''' to '''OnePager Bundle Standalone'''.  With these requirements satisfied and the proper [http://www.smartsheet.com/ www.smartsheet.com] access credentials available, '''OnePager Bundle Standalone''' can connect you to your Smartsheet account, access your selected Smartsheet '''source plan''' and create a '''NEW '''chart, '''UPDATE''', an existing chart, or '''OPEN''' an already created chart residing on your computer.
+
This article is focused on using the ''' Column Splitting''' feature with OnePager Bundle '''Standalone''' and '''imported''' Asana '''source plans'''.
  
This article is a complete guide for using '''OnePager Bundle Standalone''' for '''importing''' Smartsheet files through the creation of a OnePager Chart, '''editing''' the chart, and incorporating the chart into a schedule conversation such as '''pasting''' the chart into a Microsoft PowerPoint presentation.
+
==About Splitting and Parsing Fields==
  
As a convention, whenever we refer to the '''OnePager Bundle''' in the context of Smartsheet, we'll just say '''OnePager''' when its absolutely clear that we are discussing '''OnePager''' with SmartsheetSince only the '''Standalone''' edition of '''OnePager''' can connects to Smartsheet files online, we'll just leave the suffix '''"Standalone"''' off.
+
The OnePager '''column splitting''' feature allows you to '''duplicate task bars''' when a task in your Asana '''source plan''' is assigned to '''multiple resources''' (or anything else)Because assignments from Asana often are '''comma-delimited''', this feature enables OnePager to '''parse the comma-delimited list''' and '''create a unique task bar''' for each instance in the '''comma-separated''' list.
  
==Launching OnePager Using Smartsheet Source Plans for the First Time==
+
===Split Resource Names Example===
  
===Preparing the Smartsheet Source Plan===
+
Say you want to use '''color-codes''' on task bars/milestone symbols based upon your Asana '''source plan’s Assigned to''' column as shown below:
  
Before you launch '''OnePager''', it is a good idea to make sure that the Smartsheet '''Flag''' field that tells OnePager which Smartsheet '''Flag''' field you intend to use to control the import of source plan data is defined and set up as shown in the Smartsheet source plan illustration below:
+
<center>[[File:P72-24_5_3-72-(1)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(1)-11022023.png</center>
  
<center>[[File:P71-3_0_3_3-71-(2A)-06012021.png]]</center>
+
Some of the entries in the '''Assigned to''' column consist of multiple, '''comma-separated''' items and some tasks only used one '''resource'''. Without the '''column splitting''' feature, a chart '''created''' from these data and assigned task bar/milestone symbol '''colors''' based upon the '''Assigned to''' column looks like this:
<!--<center>P71-3_0_3_3-71-(2A)-06012021.png</center>-->
+
  
To control which tasks are '''imported''', specify the Smartsheet field as shown above where the Smartsheet field named '''Show It''' was added as a '''text''' field and the tasks that we wish to '''import''' have this field's contents set to '''Yes''' for each task we wish to import.
+
<center>[[File:P72-24_5_3-72-(5)-11272023.png]]</center>
 +
<center>P72-24_5_3-72-(5)-11272023.png</center>
  
When making your first chart, we strongly recommend that you select 50 or fewer tasks. Please note that '''OnePager''' is shipped with a number of fully populated '''Templates Properties''' forms that are based on a typical Smartsheet '''source plan'''. Note that three field heading types must always be present: '''Task Name''', '''Start Date''', and '''End Date'''.
+
OnePager, in this case, treats the '''entire string''' as an individual '''Assigned to''' value.  To provide more flexibility in displaying task bars that have '''multiple resources''' assigned, OnePager supports the concept of a '''column splitting'''. This feature recognizes '''comma-separated''' values in a '''designated column''' and '''creates a separate task bar''' for each of the '''comma-separated''' values.
  
===Launching OnePager===
+
===Enabling Splitting===
  
With the requirements above satisfied, you can access your Smartsheet '''source plans''' by first launching '''OnePager''' from your '''Desktop''' using the '''OnePager Bundle Icon''' shown here:
+
To use this feature requires turning '''ON''' the feature in the Asana '''Template Properties''' form you intend to use to make the chart.  The setting must be turned '''ON''' before the chart is created so launch OnePager Bundle from the '''desktop icon''', click the '''NEW''' button on the '''OnePager Bundle Start''' form to access the '''OnePager choices''' form, '''select''' your Asana '''source plan''', and type in the chart's '''title''' as shown here:
  
<center>[[File:P71-3_0_3-71-(3-1)-10252021.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2A)-11022023.png]]</center>
<!--<center>P71-3_0_3-71-(3-1)-10252021.png</center>-->
+
<center>P72-24_5_3-72-(2A)-11022023.png</center>
  
Clicking the '''OnePager Bundle Icon''' causes a splash page to be displayed and then you are taken to the '''OnePager Bundle -- Chart Editor''' as shown in the sequence below:
+
When you click the '''Next>''' button at the bottom of the form, OnePager accesses the second page of the '''OnePager choices''' form shown below:
  
<center>[[File:P71-3_0_3-71-(5-1)-10252021.png]]</center>
+
<center>[[File:P72-24_5_3-72-(2AA)-11022023.png]]</center>
<!--<center>P71-3_0_3-71-(5-1)-10252021.png</center>-->
+
<center>P72-24_5_3-72-(2AA)-11022023.png</center>
  
The '''OnePager Bundle Start''' form provides you with three options:
+
Clicking the '''Edit current template''' button accesses the current '''Template Properties''' form.  Navigate to the '''Field Mappings''' tab on the form, check the '''Enable splitting on:''' checkbox to '''ON''' and (in this example) select the '''Assigned To''' column from the dropdown list provided.  The results are shown here:
  
:1) '''NEW'''  Clicking the '''NEW''' buttons bring up the '''OnePager choices''' ('''OPC''') form.
+
<center>[[File:P72-24_5_3-72-(2AAA)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2AAA)-11022023.png</center>
  
:2) '''UPDATE''' Clicking the '''UPDATE''' button allows you to '''BROWSE FILES''' for an existing chart file or select a recently-opened chart.
+
Click the '''Save and use''' button to complete the process and close the current '''Template Properties''' form returning you to the second page of the '''OnePager choices''' form show above.
  
:3) '''OPEN'''  Clicking the '''OPEN''' button allows you to '''BROWSE FILES''' for an existing chart or select a recently-opened chart.
+
===Split Resources in the Chart===
  
==Creating a NEW Chart from a Smartsheet Source Plan==
+
Clicking the '''Create new chart''' button completes the process and creates the chart with the '''column splitting''' feature in use.  The chart with '''splitting''' looks like this:
  
If we are launching '''OnePager''' for the first time and intend to use a Smartsheet '''source plan''', click the '''NEW''' button which accesses the abbreviated '''OnePager Choices''' form as shown below:
+
<center>[[File:P72-24_5_3-72-(2)-11022023.png]]</center>
 +
<center>P72-24_5_3-72-(2)-11022023.png</center>
  
<center>[[File:P71-3_0_3_3-71-(5-1)-10282021.png]]</center>
+
In the chart with '''column splitting''' shown above, there are now several more task bars in the '''Chart Editor''' than there were before.  The task bar for '''Plate Movement''' is now '''split into two (2) separate task bars''', one for each of the '''two resources assigned'''. The task bar for '''Centrifugal Barrier''' is now '''split into three (3) separate task bars''', one for each of the '''three resources''' that were assigned to this task in the Asana '''source plan'''.  Each of the '''resources''' has a unique '''color''' assigned.  Each of the '''resources''' appears by itself in the '''Legend'''.  The '''Legend title''' shows the '''column name''' that is used for '''splitting the columns'''.
<!--<center>P71-3_0_3_3-71-(5-1)-10282021.png</center>-->
+
  
Next, click the '''Select''' button to access the dropdown menu where you have the options shown in the illustration below:
+
With this feature, you can use '''column splitting''' just like any other column by using the dropdowns in the '''Template Properties''' form or '''Chart Properties''' form to assign '''colors, highlight task bars and milestone symbols, and to define and label rows and swimlanes'''.
  
<center>[[File:P71-3_0_3_3-71-(6-2)-09192022.png]]</center>
+
==Splitting Resources and Task Links==
<center>P71-3_0_3_3-71-(6-2)-09192022.png</center>
+
  
===Selecting the Smartsheet Region===
+
When task bars with '''Data-Driven''' or manual '''Task Links''' are '''split''', the '''Task Links''' ('''Data-Driven''' and manual) are '''not shown'''.  Further, the '''Task Links''' that are now '''hidden''' and '''do not''' have entries in the '''Where are My Links?''' form.
  
When you select the '''BROWSE Smartsheet...''' option shown above, OnePager displays a sub-menu to the right which asks you to select either the '''North America''' region or '''Europe''' region for your '''connection''' to Smartsheet.  The '''BROWSE Smartsheet... sub-menu''' looks like this:
+
==Related Links==
 
+
<center>[[File:P71-3_0_3_3-71-(6A-1)-09192022.png]]</center>
+
<center>P71-3_0_3_3-71-(6A-1)-09192022.png</center>
+
 
+
Clicking either the '''North America''' option button or the '''Europe''' option button continues the sign in process as described in the following sub-section.
+
 
+
===Connecting OnePager Bundle to Your Smartsheet Account===
+
 
+
For the purpose of this discussion, click the '''BROWSE Smartsheet ...''' option and make your '''Smartsheet''' region selection to access the '''Connect OnePager to Smartsheet (North America)''' form as shown below:
+
 
+
<center>[[File:P71-3_0_3_3-71-(7-5)-09192022.png]]</center>
+
<center>P71-3_0_3_3-71-(7-5)-09192022.png</center>
+
 
+
Selecting the '''Europe''' region option accesses the '''Connect OnePager to Smartsheet (Europe)''' form.
+
 
+
====Smartsheet Site Not Available====
+
 
+
If it should happen that the Smartsheet website is down for some reason, OnePager provides the message shown below instead of the '''Connect OnePager to Smartsheet''' form:
+
 
+
<center>[[File:P71-3_0_3_3-71-(7B)-02072022.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(7B)-02072022.png</center>-->
+
 
+
Clicking either the '''Ignore All''' or the '''Ignore''' buttons closes the '''error message''' form.  Clicking the '''Details>''' button provides the last two lines in the message form above.  OnePager remains open.  We recommend either waiting for the Smartsheet.com website to return to operation or call the Smartsheet support number.  Once the Smartsheet.com website is restored to operation, retry this procedure for '''connecting''' to Smartsheet.
+
 
+
OnePager  Bundle also displays the above form is Smartsheet becomes unavailable either at initial '''sign in''' as discussed above or during an '''editing''' session such as when you need to access your Smartsheet '''source plan''' to '''update''' your chart.
+
 
+
====Completing the Sign In Process====
+
 
+
Assuming that no '''error message''' was shown, after entering your '''email address''', click '''Continue''' and you'll be able to enter your '''Smartsheet password''' on this form:
+
 
+
<center>[[File:P71-3_0_3_3-71-(7A-2)-09192022.png]]</center>
+
<center>P71-3_0_3_3-71-(7A-2)-09192022.png</center>
+
 
+
After entering your credentials and clicking the '''Sign In''' button, read the form and click the '''Allow''' button to proceed as shown here:
+
 
+
<center>[[File:P71-3_0_3_3-71-(8-2)-02142022.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(8-2)-02142022.png</center>-->
+
 
+
====Saving Smartsheet Sign In Credentials Options====
+
 
+
Clicking the '''Allow''' button accesses the '''Optional: Store Smartsheet Credentials''' form which gives you the option to have OnePager '''save your Smartsheet credentials''' for later access to Smartsheet from OnePager.  If you select the '''No, do not store credentials''' option, on subsequent attempts to access Smartsheet from OnePager you are required to follow the sign in procedure described above.  Selecting the '''Yes, store credentials''' option, tells OnePager to '''store your sign on credentials''' safely on your computer for subsequent access the next time you use OnePager Bundle to select a Smartsheet '''source plan'''.  The '''Optional: Store Smartsheet Credentials''' form is shown below:
+
 
+
<center>[[File:P71-3_0_3_3-71-(8B-2)-02142022.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(8B-2)-02142022.png</center>-->
+
 
+
====Switching from One Smartsheet Account to Another====
+
 
+
In some cases it may be necessary to '''switch to another Smartsheet account''' to gain access to the '''source plans''' needed to create a chart.  The process for performing this '''account switch''' is described in this '''FAQ''':  [https://www.onepager.com/support/faq.php?id=198 Switching from One Smartsheet Account to Another]
+
 
+
====Selecting the Smartsheet Source Plan====
+
 
+
Selecting the desired '''option''' on the previous form accesses the '''Choose what to import''' form shown below:
+
 
+
<center>[[File:P71-3_0_3_3-71-(9-1)-10282021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(9-1)-10282021.png</center>-->
+
 
+
Clicking the desired Smartsheet '''source plan''' entry shown above tells '''OnePager''' which Smartsheet file to load under the control of the defined '''Show It''' flag field and expands the previously abbreviated '''OnePager Choices''' form shown here:
+
 
+
<center>[[File:P71-3_0_3_3-71-(10A-1)-12062021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(10A-1)-12062021.png</center>-->
+
 
+
Shown in the illustration above is the '''file name''' for the Smartsheet '''source plan''' and the distributed Smartsheet '''Template Properties''' form that '''OnePager''' selects as a starting point for you.  Also shown above is the name selected for the '''OnePager Bundle NEW''' chart.  '''OnePager''' also recognizes the Smartsheet '''Show It''' field as the '''import selection field''' because its contents are '''Yes''' and blanks.  At this point you can change the '''Template Properties''' form used to build the chart by clicking the '''Change''' button in the '''Starting Template''' sub-section of the '''OnePager Choices''' form.
+
 
+
===Options on the NEW OnePager Choices form===
+
 
+
The '''OPC''' form gives you more options for selecting '''source plans'''.  The illustration above shows that '''OnePager''' is initiated from Smartsheet with the '''source plan''' shown in the '''Selected File(s)''' group shown above.  The '''Add/Remove''' button gives you the capability to '''add''' more '''source plans''' to the '''source packet''' or, for multiple file packets, or to '''remove''' files. Clicking the '''Add/Remove''' button accesses the '''Data source selection''' form as shown below:
+
 
+
<center>[[File:P71-3_0_3_3-71-(7-5)-12062021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(7-5)-12062021.png</center>-->
+
 
+
The '''Data source selection''' form displays the current '''source plan''' that was loaded when you launched '''OnePager'''.  This form lets you '''Add''' more Smartsheet '''source plan''' to create a '''multi-project''' chart or '''Remove''' a '''source plan''' from a '''multi-file source packet'''.  These options are detailed below.
+
 
+
===Adding a New Source Plan===
+
 
+
When you click the '''Add''' button, '''OnePager''' gives you the option to access a Windows '''Open''' form when you select the '''BROWSE FILES…''' option as shown here:
+
 
+
<center>[[File:P71-3_0_3_3-71-(8-1)-06082021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(8-1)-06082021.png</center>-->
+
 
+
Clicking the '''BROWSE FILES…''' option displays a Window’s '''Open''' form so you can select an Smartsheet '''source plan''' to '''add''' to the '''source packet'''.  A sample '''Open''' form is shown below:
+
 
+
<center>[[File:P71-3_0_3_3-71-(9-1)-06082021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(9-1)-06082021.png</center>-->
+
 
+
When you select a desired Smartsheet '''source plan''' and click the '''Open''' button as shown above, '''OnePager''' adds the '''source plan''' to the '''source packet''' and displays it in the '''Data source selection''' window as shown below:
+
 
+
<center>[[File:P71-3_0_3_1-71-(10-1)-06082021.png]]</center>
+
<!--<center>P71-3_0_3_1-71-(10-1)-06082021.png</center>-->
+
 
+
The selected '''source plan''' is '''added''' to the '''source packet''' as shown above.  '''OnePager''' shows the '''path name''' of the '''source plan''' in the window if you hover the mouse over the '''source plan''' name. If you select a recently used '''source plan''' from the dropdown menu displayed when the '''Add''' button is clicked ('''Data source selection''' form), '''OnePager Bundle Standalone'''  adds that '''source plan''' to the '''source packet'''.
+
 
+
===Smartsheet Source Plan Not Found===
+
 
+
When selecting a Smartsheet '''source plan''' from the '''RECENT''' dropdown list or when making changes to the '''source plan packet''' there is a possibility that the selected '''source plan''' is no longer available to Smartsheet either because the '''source plan''' was '''deleted''', '''renamed''', or '''un-shared'''.  When OnePager cannot '''locate''' the requested '''source plan''' the message shown below is presented:
+
 
+
<center>[[File:P71-3_0_3_1-71-(10A)-03022022.png]]</center>
+
<!--<center>P71-3_0_3_1-71-(10A)-03022022.png</center>-->
+
 
+
Clicking the '''Ignore All''' or the '''Ignore''' button returns you to the '''OnePager Bundle Start''' form.
+
 
+
===Removing a Source Plan===
+
 
+
The '''Remove''' button allows you to remove a '''source plan''' from a '''source packet''' if that '''source plan''' is not needed to create the new chart.  To remove a '''source plan''', first select the '''source plan''' in the '''Data source selection''' form’s window so that it is highlighted in blue then click the '''Remove''' button as shown in the sequence below:
+
 
+
<center>[[File:P71-3_0_3_3-71-(11-2)-06082021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(11-2)-06082021.png</center>-->
+
 
+
 
+
<center>[[File:P71-3_0_3_3-71-(12)-06082021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(12)-06082021.png</center>-->
+
 
+
===Other Choices to Make===
+
 
+
Moving on to the other groups of the '''OPC''' form, you are asked to confirm a few things before you build the chart.  '''OnePager''' makes good guesses for each of these choices, but you can change any of them:
+
 
+
<center>[[File:P71-3_0_3_3-71-(15-4)-12062021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(15-4)-12062021.png</center>-->
+
 
+
====Starting Template Properties Form====
+
 
+
The current '''Template Properties''' form determines which fields are '''imported''' from Smartsheet '''source plan''' files and how the initial chart looks.  '''OnePager''' ships with many sample '''Templates Properties''' forms, but you can also customize your own '''Template Properties''' form. To choose which '''Template Properties''' form to use in building your chart, click the '''Change…''' button in the top group of the '''OPC''' form  as shown here:
+
 
+
<center>[[File:P71-3_0_3_3-71-(15A-2)-12062021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(15A-2)-12062021.png</center>-->
+
 
+
The dropdown list shown in the illustration above only shows '''RECENT''' and '''PERMANENT Templates''' selections for the '''source plan''' type you selected previously in the '''Selected File(s)''' sub-control group above.
+
 
+
When using '''OnePager''' with Smartsheet '''source plans''' it is required that you use Smartsheet '''Template Properties''' forms.  If '''OnePager''' detects that there is a mismatch between '''source plan''' file type and the '''Template Properties''' form, a warning message is provided.
+
+
For now, just stick with the default '''Template Properties''' form entitled '''Single Project Gantt View – Detailed for Smartsheet''', but you can always use a different '''Template Properties''' form to get a different type of chart.
+
 
+
====Title of the New Chart====
+
 
+
This is the '''Title''' of the chart and also the suggested '''save''' name.  You can change the '''save''' name when you save it.  We recommend that you enter a '''Title''' that helps you identify the chart later on as shown here:
+
 
+
<center>[[File:P71-3_0_3_3-71-(15B-2)-12062021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(15B-2)-12062021.png</center>-->
+
 
+
For each chart you create, '''OnePager''' remembers '''colors, titles, legends, font sizes''', and all other '''graph properties''' so that your work is saved. Later, you can '''update''' the chart with a snapshot of how the project looks on a different date. Then you can '''browse''' through the snapshots to see how the project is changing over time.  '''OnePager''' also '''saves''' the '''path name''' associated with the '''save''' name ('''.TAM''').
+
 
+
====Task Selection====
+
 
+
This is how you tell '''OnePager''' which tasks to '''import''' from your Smartsheet '''source plan''' as indicated below:
+
 
+
<center>[[File:P71-3_0_3_3-71-(15C-2)-12062021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(15C-2)-12062021.png</center>-->
+
 
+
Either click the '''Select all tasks''' radio button to create a chart with everything or choose a '''Flag''' field. You can make several charts from a single Smartsheet '''source plan''', each using a different '''Flag''' field.  In '''OnePager''', if no '''Flags''' are set to '''Yes''', provides you with a warning message shown below:
+
 
+
<center>[[File:P71-3_0_3_1-71-(15D)-06042021.png]]</center>
+
<!--<center>P71-3_0_3_1-71-(15D)-06042021.png</center>-->
+
 
+
Clicking the '''Select tasks by custom filter''' button enables the '''Edit filters...''' button.  Clicking the '''Edit filters...''' button takes you to a form that controls the '''Conditional Import Filters''' feature as shown here. 
+
 
+
<center>[[File:P71-3_0_3_3-71-(15E-2)-12062021.png]]</center>
+
<!--<center>P71-3_0_3_3-71-(15E-2)-12062021.png</center>-->
+
 
+
For more detailed information on '''Conditional Import''', please see the article at:
+
  
<center>
 
{| class="wikitable"
 
| [[Conditional Import for Version 7.2 (Portal) | Conditional Import Filters (Portal)]] 7.18.1-72
 
|}
 
</center>
 
 
====Snapshot Date====
 
 
This is the date of the chart and lets you keep track of how schedules change over time. The snapshot date is set by default from your Smartsheet '''source plan's''' '''Current date'''. You can change the snapshot date by clicking on the dropdown button at the window shown in the illustration below:
 
 
<center>[[File:P71-3_0_3_3-71-(15F-1)-12062021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(15F-1)-112062021.png</center>-->
 
 
Making a calendar date selection as shown above establishes the '''snapshot date''' for the chart and the '''snapshot''' being created. Each chart can have many snapshots. Snapshots and their management are important topics.  Snapshots are the basis of how '''OnePager''' helps you track the progress of your project. 
 
 
For more information on '''Snapshots and their Management''', please see the articles at:
 
 
<center>
 
{| class="wikitable"
 
| [[Managing Chart Data for Version 7.2 | Managing Chart Data (Portal)]] 23.0.1-72
 
|}
 
</center>
 
 
====Show Field Mappings====
 
 
The '''Show field mappings''' checkbox is near the bottom of the form.  When this box is checked '''ON''' you have a chance to review and change the Smartsheet '''field mappings''' to '''OnePager''' before you make your first chart. To do this, click the '''Next&gt;''' button as shown here:
 
 
<center>[[File:P71-3_0_3_3-71-(15G-3)-12062021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(15G-3)-12062021.png</center>-->
 
 
You now see the following form:
 
 
<center>[[File:P71-3_0_3_3-71-(16-2)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(16-2)-10282021.png</center>-->
 
 
Notice in the above form that '''OnePager''' has relied on the current '''Template Properties''' form to make some guesses on which Smartsheet '''source plan''' fields should be used in making the chart. You can easily change any of these '''field mappings''' by making selections from the dropdown menus. For example, shown below is how to change which '''Finish Date''' in Smartsheet is used to create the chart's '''Finish''':
 
 
<center>[[File:P71-3_0_3_3-71-(17-2)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(17-2)-10282021.png</center>-->
 
 
===Creating the Graph===
 
 
We've gone ahead and selected a more elaborate '''Template Properties''' form so when the '''Create new chart''' button is clicked, the Smartsheet '''source plan''' is used to create the '''OnePager''' chart shown here:
 
 
<center>[[File:P71-3_0_3_3-71-(11A-2)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(11A-2)-10282021.png</center>-->
 
 
===Copying the Chart to Microsoft PowerPoint===
 
 
'''OnePager Bundle''' provides access to the Windows clipboard so you can '''copy''' the chart and '''paste''' it into another application. To copy the current chart snapshot to the clipboard click the '''Copy''' button on the '''Home''' ribbon tool bar tab as shown below: 
 
 
<center>[[File:P71-3_0_3_3-71-(37A-1)-06102021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(37A-1)-06102021.png</center>-->
 
 
Then launch Microsoft PowerPoint and paste the clipboard copy of the chart into a Microsoft PowerPoint slide, as shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(37-1)-06102021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(37-1)-06102021.png</center>-->
 
 
That’s it! You’ve created a professional 1-page schedule summary from a complex Smartsheet schedule and copied it into a Microsoft PowerPoint presentation. You can also print the chart by selecting the '''Print''' button on the '''File''' tab. '''OnePager Bundle''' has other features that let you move task bars vertically to different '''rows and swimlanes''', change the number and levels of swimlanes, add swimlane titles, show graphic dependencies among tasks, change task bar colors, hide task bars, edit text items, add floating comment boxes, add comment boxes to task bars, and standardize on chart styles across organizations.
 
 
To learn more about these features, read about the specific workflows in this Wiki at:
 
 
<center>
 
{| class="wikitable"
 
| [[Basic Workflows for Version 7.2 (Portal) | Basic Workflows (Portal)]] 7.0.1-72
 
| [[Manual Editing Task/Milestone Shapes and Text Labels for Version 7.2 (Portal) | Manual Editing Task/Milestone Shapes and Text Labels (Portal)]] 9.0.1-72
 
|}
 
</center>
 
 
==Opening a Chart==
 
 
The '''OnePager Bundle Start''' form has two additional buttons for accessing existing charts built with '''OnePager''' ('''OPEN''') and for specifically '''updating''' an existing chart with '''updated source plan''' information ('''UPDATE''').
 
 
The right-most button on the '''OnePager Start''' form is the '''OPEN''' button. Clicking the '''OPEN''' button displays a dropdown menu which is the same for the '''UPDATE''' button. The options in the dropdown are discussed below:
 
 
<center>[[File:P71-3_0_3_3-71-(19A-1)-102872021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(19A-1)-102872021.png</center>-->
 
 
Clicking the '''BROWSE FILES...''' option accesses a Windows '''Open''' form from which you can select a '''.TAM''' that you want to open.  Selecting the desired '''.TAM''' causes '''OnePager Bundle Standalone''' to display the selected chart in the '''Chart Editor'''.  From the '''Chart Editor''', you can '''edit''' the chart, '''save it''', or '''share it''' with others. Clicking any of the '''RECENT charts''' items in the dropdown menu above causes '''OnePager''' to load the associated '''.TAM''' into the '''Chart Editor'''.
 
 
==Updating a Chart==
 
 
'''OnePager''' supports '''updates''' to your chart through the '''UPDATE''' button found on the '''OnePager Bundle Start''' form.  Clicking the '''UPDATE''' button provides the same options in terms of a dropdown list as described above for the '''OPEN''' button.  A sample '''UPDATE''' button dropdown is shown here:
 
 
<center>[[File:P71-3_0_3_3-71-(4A-1)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(4A-1)-10282021.png</center>-->
 
 
Updates to '''OnePager''' charts are performed by adding snapshots which are a series of charts produced from a sequentially updated Smartsheet '''source plan''' over time.  '''Updates''' can be made to existing charts in the set of existing snapshots.
 
 
Snapshots are identified by a '''snapshot date'''.  The management of snapshots with a chart is described in the sub-sections that follow.
 
 
===Replacing A Snapshot - Updating a Chart with Changes Made to the Smartsheet Source Plan's Data===
 
 
Suppose, after examining the chart you created and '''saved''', you realize that it might be best to show more task bars.  This, you think, would greatly improve your schedule presentation.  '''Updating''' the chart at this point is simple.  Recall that '''OnePager''' is active and the '''Chart Editor''' is displaying the current chart you want to update.  At this point the Smartsheet '''source plan''' should be '''updated''' in Smartsheet online and '''saved'''.  The original chart looked like this:
 
 
<center>[[File:P71-3_0_3_3-71-(11A-2)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(11A-2)-10282021.png</center>-->
 
 
Since Smartsheet is still an active program and the Smartsheet '''source plan''' you are using is still being displayed, go back to the Smartsheet application and change the '''Show It''' field setting from '''blank''' to '''Yes''' for the tasks you want to now '''import''' and display.  A section of the Smartsheet '''source plan''' where this is done is shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(19B-1)-06102021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(19B-1)-06102021.png</center>-->
 
 
Once you’ve made the '''Show It''' changes to Smartsheet '''Lines 8 through 15''' the '''source plan'''  looks like this:
 
 
<center>[[File:P71-3_0_3_3-71-(19C-1)-06102021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(19C-1)-06102021.png</center>-->
 
 
With the Smartsheet '''source plan''' updated, go back to '''OnePager''' and navigate to the '''Data''' ribbon tool bar tab where you see several buttons.  To '''update''' your chart to show the additional task bars from your Smartsheet '''source plan''', click the '''Replace Snapshot''' button as shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(19D-3)-03152022.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(19D-3)-03152022.png</center>-->
 
 
When you click the '''Replace Snapshot''' button, '''OnePager''' goes back to the Smartsheet '''source plan''' that you just changed, '''imports''' all the tasks that changed, and updates your chart.  At the conclusion of the operation, the updated chart looks like this:
 
 
<center>[[File:P71-3_0_3_3-71-(19E-2)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(19E-2)-10282021.png</center>-->
 
 
The example above is just one of many uses of the '''Data''' ribbon tool bar tab’s '''Replace Snapshot''' button when you need to update a chart.  You can do this as many times as necessary until the chart is the way you need it.  In addition to adding and removing tasks by changing the Smartsheet '''Show It''' field, you can change '''source plan''' task '''Start Dates''', '''Finish Dates''', or '''Percent Complete''' and display these data changes in the chart.  Using the procedure above you can do this very efficiently. You can now '''save''' the chart by giving it a '''save''' name.  When you '''save''' the chart, '''OnePager saves''' the '''.TAM''' and '''saves''' the Smartsheet '''source plan name''' and '''path''' information.  This is useful when you want to further update the chart or when you want to add a snapshot later on.  In the examples below we assume that the chart is '''saved''' as '''BlueGrass Project Report - Smart'''.
 
 
===Adding a Snapshot - Adding to the Chart with Changes Made to the Smartsheet Source Plan's Data===
 
 
The power of '''OnePager''' is illustrated when, after a period of progress on the project, it is time to produce another chart.  '''OnePager''' produces your next snapshot with the same look and feel as the original assuming that the Smartsheet '''source plan''' was updated with '''actual start and finish, percent complete''', and other relevant data during the reporting interval, '''OnePager''' can easily generate a new snapshot.  Suppose we have the original chart we created and we want to create another graph from the updated Smartsheet '''source plan''' on later on in the project.  The original chart is shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(11A-2)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(11A-2)-10282021.png</center>-->
 
 
Before creating a new snapshot to show updates to the plan, we need to update the Smartsheet '''source plan''' say by updating the '''Percent Complete''' for tasks that have progressed to , say, 95%.  After the Smartsheet '''source plan''' is updated, it looks like this
 
 
<center>[[File:P71-3_0_3_3-71-(11B-1)-06102021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(11B-1)-06102021.png</center>-->
 
 
When the '''source plan''' is updated with this revised information, we can proceed. Launch '''OnePager''' and click the '''UPDATE''' button on the '''OnePager Bundle Start''' form. Doing so accesses the following '''OnePager choices''' ('''OPC''') form shown here:
 
 
<center>[[File:P71-3_0_3_3-71-(20A-2)-12062021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(20A-2)-12062021.png</center>-->
 
 
In the '''OPC''' form select the '''NEW snapshot at date:''' as shown above.  You can also select a date for the snapshot so that this snapshot represents the project at the status date point in time.  To see which snapshot dates already exist, just position your mouse over the '''NEW snapshot at date:''' window to see a list of the existing dates. 
 
 
<center>[[File:P71-3_0_3_3-71-(20B-2)-12062021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(20B-2)-12062021.png</center>-->
 
 
You can use the built in calendar dropdown or type in the new snapshot’s month, day, and year in the window provided as shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(20C-2)-12062021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(20C-2)-12062021.png</center>-->
 
 
Un-check the '''Show field mappings''' checkbox '''OFF''' if you want to use the same '''field mappings''' as you used before. The bottom of the screen now looks like this:
 
 
<center>[[File:P71-3_0_3_1-71-(26)-06072021.png]]</center>
 
<!--<center>P71-3_0_3_1-71-(26)-06072021.png</center>-->
 
 
Pressing the large '''New''' button creates a new snapshot for the chart.  The chart opens at the new snapshot. The '''color''', '''fonts''', '''title''', and '''swimlane''' assignments are consistent between the two snapshots:
 
 
<center>[[File:P71-3_0_3_3-71-(20D-1)-06102021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(20D-1)-06102021.png</center>-->
 
 
You can go back and forth between the two snapshots by using the '''snapshot forward/backward''' buttons on the '''View''' ribbon tool bar tab as shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(20E-2)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(20E-2)-10282021.png</center>-->
 
 
==Editing the Chart==
 
 
Once the '''OnePager''' chart is created it can be '''edited''' in the '''Chart Editor'''.  The '''editing''' options are very robust with features available to move task bars up and down in the chart, change '''color''' and '''sizes''' of task bars and '''row heights''', and change the sizes of '''text font''' which is used below to illustrate how '''chart editing''' can be done.
 
 
===Editing Task Bar Name Label Font Sizes===
 
 
You can always '''edit''' the '''font sizes''' and '''label positions''' on task bars and milestone symbols to optimize readability.  To do this, hold down the left mouse button and '''drag''' a selection box ('''Lasso''') that encloses many task bars and milestone symbols at once:
 
 
<center>[[File:P71-3_0_3_3-71-(29-1)-06112021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(29-1)-06112021.png</center>-->
 
 
When you release the mouse, the enclosed task bars and milestone symbols are all be selected:
 
 
<center>[[File:P71-3_0_3_3-71-(30-1)-06112021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(30-1)-06112021.png</center>-->
 
 
Click the '''Increase Font Size''' button on the '''Home''' ribbon tool bar tab shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(31-2)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(31-2)-10282021.png</center>-->
 
 
The chart now looks something like this:
 
 
<center>[[File:P71-3_0_3_3-71-(32-1)-06112021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(32-1)-06112021.png</center>-->
 
 
Repeating this operation for the remaining task bars and milestone symbols (we could have done '''Select All''' and done it all at once!), we can now '''edit''' the chart so that all task bars and milestone symbols have larger '''fonts''':
 
 
<center>[[File:P71-3_0_3_3-71-(33-1)-06112021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(33-1)-06112021.png</center>-->
 
 
===Editing Task Bar Name Label Positions===
 
 
Another common '''editing''' action is to move the task bar's '''name label''' from their current positions to positions elsewhere around or on the task bar.  To do this, click the '''name label''' to select it and then click the '''Label Position''' button on the '''Home''' ribbon tool bar tab.  This action accesses the '''Label Position''' dropdown list where you can select one of the '''label positioning''' buttons as shown here:
 
 
<center>[[File:P71-3_0_3_3-71-(34-1)-06112021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(34-1)-06112021.png</center>-->
 
 
At this point, as an example, click the '''Left''' option in the dropdown and the selected '''name label''' is moved to the left side of the task bar as shown here:
 
 
<center>[[File:P71-3_0_3_3-71-(34A-1)-06112021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(34A-1)-06112021.png</center>-->
 
 
In case you change your mind about the '''last editing action''' you took, you can '''UNDO''' the '''last editing action''' by clicking the '''UNDO''' button above the '''OnePager''' ribbon tool bar tabs.  Successive clicking the '''UNDO''' button undoes '''editing''' actions in the reverse order that they were applied.
 
 
<center>[[File:P71-3_0_3_3-71-(35-2)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(35-2)-10282021.png</center>-->
 
 
'''Save''' the '''edited''' chart by pressing the '''Save''' button above the ribbon tool bar tab next to the '''UNDO''' button.  All of the '''font size''' changes, '''text-position''' '''edits''', and the new '''Legend''' position are now '''saved''' in case you need to '''update''' this chart with new data at a later time.
 
 
===Editing Other Chart Contents===
 
 
The examples above are just samples of '''Chart Editor''' capabilities provided for '''editing''' within the chart.  Making other '''edits''' to task bars and milestone symbols and '''name labels''' are covered in more detail in this article:  [[Manual Editing Task/Milestone Shapes and Text Labels for Version 7.1 (Portal) | Manual Editing Task/Milestone Shapes and Text Labels (Portal)]] <!--9.0.1-71-->
 
 
Additionally, you can add task bar and milestone symbol information related to each activity and milestone '''imported''' such as '''baseline data''', '''percent complete''' information, and '''critical path information'''.  You can add '''comment boxes''' to task bars, '''free floating comment boxes in the chart''', vertical '''curtains''', '''task links''' to show dependencies, '''multiple swimlane levels''' and '''background images'''. And you can change the chart's '''Start/End Dates''', '''add''' or '''hide''' the '''Legend''', and add '''time axis levels''' at the top, bottom, and within the '''graph''' ('''floating time axis rows'''). Further, you are able to '''edit''' task bar and milestone symbol '''shapes''', '''colors''', and '''fill patterns'''; you have controls for '''editing''' '''rows/swimlanes''', '''text columns''', '''headers and footers''' in the chart, '''background colors''', and other text information shown in the '''graph'''.
 
 
These capabilities and the articles that provide the detailed information on how to use them can be found at this index page:  [[OnePager Version 7.1#Ways to Make Changes to Your Chart | Ways to Make Changes to Your Chart]] <!--0.04-71-->
 
 
<center>
 
{| class="wikitable"
 
| [[OnePager Version 7.2#Ways to Make Changes to Your Chart | Ways to Make Changes to Your Chart]] 0.04-72
 
|}
 
</center>
 
 
==Enhanced Capabilities Provided with OnePager==
 
 
All editions of '''OnePager''' are distributed with all the enhanced capabilities previously available in OnePager Pro and Express.  These capabilities include '''Multiple Swimlane definition and editing''', display and editing of '''Task Links''', and additional features for displaying and editing on the '''Time Axis'''. 
 
 
===Multiple Swimlane Levels===
 
 
'''OnePager''' now supports '''three  swimlane levels''' which can be '''nested''' inside one another to better display a hierarchy relationship for a Program, it’s Projects, and their Phases as shown here:
 
 
<center>[[File:P71-3_0_3_1-71-(40)-07042021.png]]</center>
 
<!--<center>P71-3_0_3_1-71-(40)-07042021.png</center>-->
 
 
In the illustration above, the '''first swimlane level''' is “Program” and under it as the '''second swimlane level''' are its “Projects”.  The '''third swimlane level''' under each “Project” are “Phases” and the '''rows''' within each '''Phase''' show the '''task bars''' at their appropriate '''start/end dates'''. Definition and '''editing''' of these '''multiple swimlane levels''' is accomplished in the '''Template Properties''' and '''Chart Properties '''form’s '''Rows/Swimlanes '''tab that is modified to provide all the controls necessary to manage these '''multiple swimlane levels''' in the chart.  The '''Rows/Swimlanes '''tab  of the '''Chart Properties '''form is shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(41-3)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(41-3)-10282021.png</center>-->
 
 
In addition to adding '''multiple swimlane levels''', the tab shown above is simplified by reorganizing the controls associated with '''Rows''' and '''Text Columns'''. '''Sorting''' controls for '''rows''' and '''swimlanes''' are in separate sub-control groups as shown above. There is a '''Row Borders Formatting… '''button in the '''Rows '''control group with the controls for defining and '''global editing''' of '''row borders''' and access buttons for '''Swimlane Formatting… '''and '''Text Column Formatting…'''  The controls shown above for the '''Chart Properties '''form are also found in the distributed '''Template Properties '''form’s '''Rows/Swimlanes''' tab. More detailed introductory information on the new '''Multiple Swimlane Levels''' feature can be found at these links:
 
 
<center>
 
{| class="wikitable"
 
| [[Using Rows and Swimlanes for OnePager Version 7.2 | Using Rows and Swimlanes]] 4.0.1.5-72
 
|-
 
| [[Creating and Editing Rows and Swimlanes for Version 7.2 (Portal) | Creating and Editing Rows and Swimlanes (Portal)]] 12.0.1-72
 
|}
 
</center>
 
 
===Displaying Data-Driven Task Links===
 
 
'''OnePager''' is enhanced to assist you with displaying Smartsheet '''Predecessor''' fields in your chart.  Typically, this feature is turned '''OFF''' in all '''Template Properties''' forms distributed with '''OnePager Bundle'''.  However, the feature can be turned '''ON''' either before or after the creation of a chart. To turn the '''Data-Driven Task Link''' feature '''ON''' prior to creating a chart, go to the '''Template Properties''' form you plan to uses and click on the '''Task Links''' tab and then click the '''Import predecessors''' checkbox in the '''Data-Driven Task Links''' control group as shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(42A-2)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(42A-2)-10282021.png</center>-->
 
 
With the '''Import predecessors''' checkbox checked '''ON''' in the '''Template Properties''' form, the chart first created looks like this:
 
 
<center>[[File:P71-3_0_3_3-71-(43-3)-10282021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(43-3)-10282021.png</center>-->
 
 
To turn the '''Data-Driven Task Link''' feature '''ON''' after the chart is created, go to the '''Chart Properties''' form's '''Task Links''' tab and then click the '''Import predecessors''' checkbox '''ON''' in the '''Data-Driven Task Links''' control group as shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(44-1)-06102021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(44-1)-06102021.png</center>-->
 
 
Once imported, '''Data-Driven Task Links''' can be '''shown''' or '''hidden''' and can be '''edited''' globally using the '''Template Properties or Chart Properties''' forms as shown above or individually using a '''task link''' right-click '''context menu'''. '''OnePager Bundle''' continues to support manual '''Task Links''' which in previous OnePager versions were called '''Event Links'''. The '''OnePager Data-Driven Task Links''' feature is flexible and powerful. 
 
 
More details are provided in the series of articles at: 
 
 
<center>
 
 
{| class="wikitable"
 
{| class="wikitable"
 +
| [[Templates versus Charts for Version 7.2 | Templates versus Charts]] 4.0.1.3-72
 
| [[Linking Task and Milestones Using Manual and Data-Driven Task Links for Version 7.2 | Linking Task and Milestone Using Manual and Data-Driven Task Links (Portal)]] 19.0.1-72
 
| [[Linking Task and Milestones Using Manual and Data-Driven Task Links for Version 7.2 | Linking Task and Milestone Using Manual and Data-Driven Task Links (Portal)]] 19.0.1-72
|}
 
</center>
 
 
===Editing the Time Axis===
 
 
All editions of '''OnePager''' are also enhanced with new capabilities and feature so you can '''edit''' the '''time axis''' and configure it to focus on specific time periods of interest in your project schedule presentation. As an example of the enhancements made to the '''time axis''' is the addition of the '''time axis cell stretch''' feature where you can lengthen the horizontal extend of any '''time axis cell''' so as to provide more space to focus on details within that time period.  An example of a stretched '''lower level time axis cell''' is shown below:
 
 
<center>[[File:P71-3_0_3_3-71-(45-2)-06112021.png]]</center>
 
<!--<center>P71-3_0_3_3-71-(45-2)-06112021.png</center>-->
 
 
For additional detailed information on the '''editing''' of '''time axis cells''' and other related capabilities please see this article at:  [[Modifying the Time Axis for Version 7.1 (Portal) | Modifying the Time Axis (Portal)]] <!--22.0.1-71-->
 
 
==Related Links==
 
 
{| class="wikitable"
 
| [https://www.onepager.com/support/video_tutorials/smartsheet.html Getting Started with Smartsheet]
 
| [https://www.onepager.com/support/video_tutorials/onepager_71.html What's New with OnePager Release 7.1? Video]  <!--Update when ne video is available-->
 
 
|-
 
|-
| [https://www.onepager.com/support/faq.php?id=198 Switching from One Smartsheet Account to Another]
+
| [[Editing with the Chart Properties form for Version 7.2 (Portal) | Editing with the Chart Properties form (Portal)]] 21.0.1-72
| [https://www.onepager.com/support/faq.php?id=77 OnePager Doesn't Launch when the Standalone Icon is Clicked]
+
| [[Template Only Features for OnePager Pro for Version 7.2 | Template Only Features for OnePager Pro]] 24.1.1-72
 
|-
 
|-
| [http://www.onepager.com/about/contact_us.php Contact OnePager Support]
+
| [[Template Only Features for OnePager Express for Version 7.2 | Template Only Features for OnePager Express]] 24.2.1-72
|}
+
| [[Template Only Features for Primavera P6 Source Plans in OnePager Version 7.2 | Template Only Features for Primavera P6 Source Plans in OnePager]] 24.2.2-72
 
+
{| class="wikitable"
+
| [[OnePager Version 7.2#Ways to Make Changes to Your Chart | Ways to Make Changes to Your Chart]] 0.04-72
+
| [[Installing and Activating OnePager Bundle for Version 7.2 (Portal) | Installing and Activating OnePager Bundle (Portal)]] 2.0.3-72
+
 
|-
 
|-
| [[Getting Started with OnePager Pro Version 7.2]] 3.0.1-72
+
| [[Template Only Features for Smartsheet Source Plans in OnePager Version 7.2 | Template Only Features for Smartsheet Source Plans in OnePager]] 24.2.3-72
| [[Getting Started with OnePager Express Version 7.2]] 3.0.2-72
+
| [[Splitting and Parsing Columns for OnePager Pro for Version 7.2 | Splitting and Parsing Fields for OnePager Pro]] 24.4.1-72
 
|-
 
|-
| [[Using Oracle Primavera P6 Source Plans with OnePager Version 7.2 | Using Oracle Primavera P6 Source Plans with OnePager]] 3.0.3.1-72
+
| [[Splitting and Parsing Columns for OnePager Express for Version 7.2 | Splitting and Parsing Fields for OnePager Express]] 24.5.1-72
| [[Using Microsoft Project/Excel Source Plans with OnePager Bundle Version 7.2 | Using Microsoft Project/Excel Source Plans with OnePager Bundle]] 3.0.3.2-72
+
| [[Splitting and Parsing Columns for Primavera P6 Source Plans in OnePager Version 7.2 | Splitting and Parsing Columns for Primavera P6 Source Plans in OnePager]] 24.5.2-72
 
|-
 
|-
| [[Using Rows and Swimlanes for OnePager Version 7.2 | Using Rows and Swimlanes]] 4.0.1.5-72
+
| [[Splitting and Parsing Columns for Smartsheet Source Plans in OnePager Version 7.2 | Splitting and Parsing Columns for Smartsheet Source Plans in OnePager]] 24.5.3-72
| [[OnePager's Ribbon Tool Bar Home Tab for Version 7.2 | OnePager's Ribbon Tool Bar Home Tab]] 4.0.2.2.1-72
+
| [[Splitting and Parsing Columns for Project for the Web Source Plans for Version 7.2 | Splitting and Parsing Columns for Project for the Web Source Plans]] 24.5.5-72
 
|-
 
|-
| [[OnePager's Ribbon Tool Bar Data Tab for Version 7.2 | OnePager's Ribbon Tool Bar Data Tab]] 4.0.2.2.7-72
+
| [[Splitting and Parsing Columns for Planisware Enterprise Source Plans for Version 7.2 | Splitting and Parsing Columns for Planisware Enterprise Source Plans]] 24.5.7-72
| [[OnePager's Ribbon Tool Bar View Tab for Version 7.2 | OnePager's Ribbon Tool Bar View Tab]] 4.0.2.2.9-72
+
| [[Splitting and Parsing Columns for Wrike in OnePager Version 7.2 | Splitting and Parsing Columns for Wrike in OnePager]] 24.5.11-72
|-
+
| [[Basic Workflows for Version 7.2 (Portal) | Basic Workflows (Portal)]] 7.0.1-72
+
| [[Conditional Import for Version 7.2 (Portal) | Conditional Import Filters (Portal)]] 7.18.1-72
+
|-
+
| [[Manual Editing Task/Milestone Shapes and Text Labels for Version 7.2 (Portal) | Manual Editing Task/Milestone Shapes and Text Labels (Portal)]] 9.0.1-72
+
| [[Creating and Editing Rows and Swimlanes for Version 7.2 (Portal) | Creating and Editing Rows and Swimlanes (Portal)]] 12.0.1-72
+
|-
+
| [[Linking Task and Milestones Using Manual and Data-Driven Task Links for Version 7.2 | Linking Task and Milestone Using Manual and Data-Driven Task Links (Portal)]] 19.0.1-72
+
| [[Managing Chart Data for Version 7.2 | Managing Chart Data (Portal)]] 23.0.1-72
+
 
|}
 
|}
  
(3.0.3.3-72)
+
(24.5.9-72)
  
 
[[Category:Version 7.2]]
 
[[Category:Version 7.2]]
[[Category:Getting Started with Version 7.2]]
+
[[Category:Editing the Chart]]
[[Category:Add-in]]
+
[[Category:Task/Milestone Editing]]
[[Category:Standalone]]
+
[[Category:Column Splitting]]
[[Category:Smartsheet]]
+
[[Category:OnePager Bundle Start Form]]
+
[[Category:OnePager Choices Form]]
+
[[Category:Snapshots]]
+
 
[[Category:Charts]]
 
[[Category:Charts]]
[[Category:Tool Bar]]
 
[[Category:Templates]]
 
[[Category:Editing the Chart]]
 
[[Category:Sharing Output]]
 
 
[[Category:Task Links]]
 
[[Category:Task Links]]
[[Category:Time Axis]]
+
[[Category:Ribbon]]
[[Category:Multiple Swimlane Levels]]
+
[[Category:Snapshots]]
[[Category:OnePager - Tool Bar]]
+
[[Category:Template Properties Form]]
[[Category:Help]]
+
[[Category:Chart Properties Form]]
 +
[[Category:Asana]]
 
[[Category:OnePager Bundle]]
 
[[Category:OnePager Bundle]]

Latest revision as of 20:52, 27 November 2023

Introduction

This article is focused on using the Column Splitting feature with OnePager Bundle Standalone and imported Asana source plans.

About Splitting and Parsing Fields

The OnePager column splitting feature allows you to duplicate task bars when a task in your Asana source plan is assigned to multiple resources (or anything else). Because assignments from Asana often are comma-delimited, this feature enables OnePager to parse the comma-delimited list and create a unique task bar for each instance in the comma-separated list.

Split Resource Names Example

Say you want to use color-codes on task bars/milestone symbols based upon your Asana source plan’s Assigned to column as shown below:

P72-24 5 3-72-(1)-11022023.png
P72-24_5_3-72-(1)-11022023.png

Some of the entries in the Assigned to column consist of multiple, comma-separated items and some tasks only used one resource. Without the column splitting feature, a chart created from these data and assigned task bar/milestone symbol colors based upon the Assigned to column looks like this:

P72-24 5 3-72-(5)-11272023.png
P72-24_5_3-72-(5)-11272023.png

OnePager, in this case, treats the entire string as an individual Assigned to value. To provide more flexibility in displaying task bars that have multiple resources assigned, OnePager supports the concept of a column splitting. This feature recognizes comma-separated values in a designated column and creates a separate task bar for each of the comma-separated values.

Enabling Splitting

To use this feature requires turning ON the feature in the Asana Template Properties form you intend to use to make the chart. The setting must be turned ON before the chart is created so launch OnePager Bundle from the desktop icon, click the NEW button on the OnePager Bundle Start form to access the OnePager choices form, select your Asana source plan, and type in the chart's title as shown here:

P72-24 5 3-72-(2A)-11022023.png
P72-24_5_3-72-(2A)-11022023.png

When you click the Next> button at the bottom of the form, OnePager accesses the second page of the OnePager choices form shown below:

P72-24 5 3-72-(2AA)-11022023.png
P72-24_5_3-72-(2AA)-11022023.png

Clicking the Edit current template button accesses the current Template Properties form. Navigate to the Field Mappings tab on the form, check the Enable splitting on: checkbox to ON and (in this example) select the Assigned To column from the dropdown list provided. The results are shown here:

P72-24 5 3-72-(2AAA)-11022023.png
P72-24_5_3-72-(2AAA)-11022023.png

Click the Save and use button to complete the process and close the current Template Properties form returning you to the second page of the OnePager choices form show above.

Split Resources in the Chart

Clicking the Create new chart button completes the process and creates the chart with the column splitting feature in use. The chart with splitting looks like this:

P72-24 5 3-72-(2)-11022023.png
P72-24_5_3-72-(2)-11022023.png

In the chart with column splitting shown above, there are now several more task bars in the Chart Editor than there were before. The task bar for Plate Movement is now split into two (2) separate task bars, one for each of the two resources assigned. The task bar for Centrifugal Barrier is now split into three (3) separate task bars, one for each of the three resources that were assigned to this task in the Asana source plan. Each of the resources has a unique color assigned. Each of the resources appears by itself in the Legend. The Legend title shows the column name that is used for splitting the columns.

With this feature, you can use column splitting just like any other column by using the dropdowns in the Template Properties form or Chart Properties form to assign colors, highlight task bars and milestone symbols, and to define and label rows and swimlanes.

Splitting Resources and Task Links

When task bars with Data-Driven or manual Task Links are split, the Task Links (Data-Driven and manual) are not shown. Further, the Task Links that are now hidden and do not have entries in the Where are My Links? form.

Related Links

Templates versus Charts 4.0.1.3-72 Linking Task and Milestone Using Manual and Data-Driven Task Links (Portal) 19.0.1-72
Editing with the Chart Properties form (Portal) 21.0.1-72 Template Only Features for OnePager Pro 24.1.1-72
Template Only Features for OnePager Express 24.2.1-72 Template Only Features for Primavera P6 Source Plans in OnePager 24.2.2-72
Template Only Features for Smartsheet Source Plans in OnePager 24.2.3-72 Splitting and Parsing Fields for OnePager Pro 24.4.1-72
Splitting and Parsing Fields for OnePager Express 24.5.1-72 Splitting and Parsing Columns for Primavera P6 Source Plans in OnePager 24.5.2-72
Splitting and Parsing Columns for Smartsheet Source Plans in OnePager 24.5.3-72 Splitting and Parsing Columns for Project for the Web Source Plans 24.5.5-72
Splitting and Parsing Columns for Planisware Enterprise Source Plans 24.5.7-72 Splitting and Parsing Columns for Wrike in OnePager 24.5.11-72

(24.5.9-72)