Auto increment a custom value

[ibmfur]

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!

[Doug_Den_Hoed__AtAppStore · Accepted solution]

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

TIP: if this solved your problem, I invite you to consider marking it as a Correct Answer to help others who might also find it of use

[ibmfur]

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