Show different results in a Dashboard view depending on smart filter queries

[Tim Zhu]

Hi, 

We have a few custom fields in our Jira tickets:

• CP1 (contains a date)
• CP2 (contains a date)
• CP3 (contains a date)
• Product Phase (contains a selection of text)

We would like to create a column in our Jira dashboard called Next CP.  The result of the column would be based on a query.  For example if Product Phase = "Phase 1" show CP1 date, if Product Phase = "Phase 2" show CP2 date.  


Is this possible to use smart filters or otherwise to show the appropriate CP date in the Next CP column?

Btw, we are on an internal server version of Jira and not the cloud.  But I don't think that matters how Dashboards are created.