Auto increment a custom value | Community
Skip to main content
New Participant
January 30, 2023
Solved

Auto increment a custom value

  • January 30, 2023
  • 1 reply
  • 724 views

Hi everyone

 

Say I have a list of 4 projects. Each project has a custom field "ranking" and their values are 1, 2, 3 respectively for each project:

i.e.

Project 1 ranking = 1

Project 2 ranking = 2

Project 3 ranking = 3

 

Say now I have a new project created, and I assign the "ranking value" of this project to be 2:

 

Here is the tricky part - I want Workfront to be able to update the projects that fall beneath this rank to have their ranking value incremented. So the result I am looking for would be:

 

Project 1 ranking = 1

(new) Project ranking = 2

Project 2 ranking = 3

Project 3 ranking = 4

 

Is this even feasible in Workfront? 

 

Thanks in advance!

Best answer by Doug_Den_Hoed__AtAppStore

 

Hi @ibmfur,

 

Unfortunately, this post didn't transfer from 0ne.workfront.com very smoothly, and the underlying link to the specific Portfolio Optimizer article is broken (so here is a generic article), but in short, Workfront's built in sorting and/or drag'n'drop functionality to move projects up and down within a Portfolio will automatically populate each such project's "Portfolio Rank", which is an ordinal number (1, 2, 3...) that you could then use to solve your reordering requirements.

 

Regards,

Doug

1 reply

Doug_Den_Hoed__AtAppStore
Doug_Den_Hoed__AtAppStoreAccepted solution
New Participant
January 30, 2023

 

Hi @ibmfur,

 

Unfortunately, this post didn't transfer from 0ne.workfront.com very smoothly, and the underlying link to the specific Portfolio Optimizer article is broken (so here is a generic article), but in short, Workfront's built in sorting and/or drag'n'drop functionality to move projects up and down within a Portfolio will automatically populate each such project's "Portfolio Rank", which is an ordinal number (1, 2, 3...) that you could then use to solve your reordering requirements.

 

Regards,

Doug

ibmfurAuthor
New Participant
January 31, 2023

This is great Doug. Many thanks for pointing me to the interesting post