Auto increment a custom value | Community
Skip to main content
I
ibmfur
Level 3
January 30, 2023
Solved

Auto increment a custom value

  • January 30, 2023
  • 1 reply
  • 738 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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
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
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity AdvisorAccepted solution
Community Advisor
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

I
ibmfurAuthor
Level 3
January 31, 2023

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

Terms & ConditionsAccessibility statement

Loading footer...