Survey123 Feature Report - Conditional Formatting based on answer

[Jeff_VanEtten]

Wondering if there is a way to create conditional formatting inside the feature report template based on a response.  For example, if inside the survey it was recorded options of Priority A, B & C and this wanted to be displayed with Red, Amber and Green text, is there a way to use conditional formatting to do this?  I know that it would be fairly easy to do in Excel, but not sure about how this would be done in Word Template (mail merge).

Thanks

[Jeff_VanEtten · Accepted solution]

Well finally figured out a work around to this using conditional elements with some code that looks like this in a table: 

${if invest_priority==”A”}Priority A ${/}${if invest_priority==”B”}Priority B ${/}

Not perfect, but its a workaround for the time being.

[TCKauhi]

This was very helpful, thank you. We have it working for when values (integers) are greater or less than one value (refer to example below), however do you know what would the syntax be for a range of values? For example, if we want a certain formatting when the value is between >46 and <=60? 

${if mobilize_mins <= 45} ${mobilize_mins} minutes ${/} ${if mobilize_mins >= 120} ${mobilize_mins} minutes ${/}

[TCKauhi]

It appears the solution is in this feed, thank you and disregard. Solved: Conditional (if / then / else) logic in Survey123 ... - Esri Community

[MathieuBoonen]

I have found in order for this to work for me I have had to include quotation marks around the  conditioned format data if it has spaces in the response, or introduce a hidden character as in an unscrore colored white if you dont want the quotes marks to appear in the response on the report as per: showing both methods

${if invest_priority==”A”}Priority_A${/}${if invest_priority==”B”}"Priority B"${/}