Survey123 Feature Reports - Conditional format question

[TCKauhi]

We created a feature report in ArcGIS Online from a survey created in Survey123 Connect. We would like to format the text or table cell a different color based on the number reported in the survey.  For example, 0-40% cell/text would be red, 40-80% cell/text would be orange, and greater than 80% cell/text would be green (refer to screenshot attached for example). Is this possible through feature reports?  I have seen an example of putting records in separate tables, but we would like all of the results to be in 1 table. Thank you.

[TCKauhi · Accepted solution]

It appears there are workarounds posted in these previous posts. Solved: Survey123 Feature Report - Conditional Formatting ... - Esri Community and Solved: Re: Conditional statement syntax in Survey123 repo... - Esri Community

Here is an example of the syntax to change colors based on value ranges:

${if mobilize_mins <= 45} ${mobilize_mins} minutes ${/} ${if mobilize_mins >=46 && mobilize_mins <=60} ${mobilize_mins} minutes ${/} ${if mobilize_mins >=61 && mobilize_mins <120} ${mobilize_mins} minutes ${/} ${if mobilize_mins >= 120} ${mobilize_mins} minutes ${/}

[wprcevans]

Any chance you could share a screen shot of how that looks in your word template?

[EdKnowles]

Is there a way to change the cell colour?

[RobertAnderson3]

I wonder if you could set up conditional formatting on the table in Word and it processes based on what the value the report provides is?