Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!
SOLVED

Auto increment a custom value

Avatar

Level 3

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!

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

 

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

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

 

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

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