Continuing our series on unique IDs, this week’s post will cover how to correctly establish and maintain a unique ID in an Excel spreadsheet that you are planning to use with OnePager Express. The focus of this article is for project plans that you are building from the ground up in Excel.
If you are using Excel to transfer data from another PPM tool like Planisware, Primavera, or Smartsheet, you’ll want to wait for our next article, which will provide specific instructions for each of those platforms.
When creating a unique ID in Excel, you want to use a field where all the values can be (1) unique and (2) consistent. It doesn’t really matter what you name the field as long as you adhere to these two principles. The unique IDs themselves can be any format that you like. Most users prefer a simple numeric ID, but if you want to create something different, you certainly can.
Continue reading
