Fill colors in Excel template - possible?

AppSheet AppSheet Q&A
, ,
1

I recall reading some time ago in this community that there’s no way to load conditional colors in an Excel sheet template based on column values. Does anyone know if there’s a workaround for this please?

Eg, I have a text column Risk that has three possible values, “Low”, “Medium” and “High” - I would ideally like there to be a filled cell in the Excel row that was Green, Amber or Red depending on this status.

thanks for any help

James

2

This is still not supported from AppSheet. One work around is to use a script to update the resultant sheet generated off the template. You may also be able to use integrator tools like “Make” to update the sheet after generation.