Forum Discussion

JakeandSnake's avatar
JakeandSnake
Frequent Visitor
5 years ago
Solved

To Show the latest Status based on Columns Value

Hi Experts,   I have one table as below: Conditions: 1. In reality, I have thousands of projects. More than 500K rows.  2. I have a lot of steps, could be 30 steps columns.   Expectation...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey JakeandSnake ,

     

    for the example you provided it worked 😉

    Rename the columns to give the step an order and put the number first, then it will work:

     

    And the result:

     

    When you have more than 10 columns make sure you have the same amount of numbers at the beginning everywhere:

     

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey JakeandSnake ,

 

for the example you provided it worked 😉

Rename the columns to give the step an order and put the number first, then it will work:

 

And the result:

 

When you have more than 10 columns make sure you have the same amount of numbers at the beginning everywhere:

 

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 
JakeandSnake's avatar
JakeandSnake
Frequent Visitor
5 years ago

Thanks~ It works for me now!