Can I use Advanced Roadmap Warnings in a "regular" Jira Filter?

Question

I'm working on a Jira Dashboard for a Program in Advanced Roadmaps.

I'd like to use a Dashboard Filter Gadget to display all issues that are flagged with a warning in the Advanced Roadmap?

Is that feature available at this time?  Or is it only available in the Advanced Roadmap display?

Matt Henson_w20w2w · Answer

Actually, I just needed to use "@row" function suggested above, and it returns the text value which works just fine for my needs.  Thank you!

Bill Sheboy · Answer

Hi @Matt Henson

I am not using that add-on, so I cannot answer your question. Have you asked the vendor what the possible values are so you may query them?

Matt Henson_w20w2w · Answer

Got this from SmartSheet support:

Thanks for contacting Smartsheet Support. I can see that you're using an IF function to translate the Symbol into a text but you're getting an #UNPARSEABLE error in your formula. I'd be glad to assist!

Upon reviewing the formula that you've provided, I was able to determine that you have an incorrect formula syntax. To resolve, insert the Green between the ""  in your formula and include @RoW after [project status].

=if([project status]@row= "Green","G","No"))

For more information, please check out the following Help articles:

* IF Function.
* Create Efficient Formulas with @cell and @row.

Thanks for using Smartsheet! If there are no additional questions on this topic or your issue has been resolved, there is no need to reply to this email. As a valued customer your feedback is important. Please let me know how I did by clicking on the stars at the bottom of this email.

Kind Regards,

Aldous

Smartsheet Support

***************************************************************

This suggestion resolved the #UNPARSEABLE error.

However, when the symbol in Project Status was a GREEN CIRCLE, the result of the formula was "No".

So, now my question is what are the values for the Green/Red/Yellow/Blue symbols in the IF function for comparison purposes ??