Is it possible to have 2 different format options for the same column?
I have a gSheet displaying live weather and one of the columns is labeled [Forecast]. When I bring it into AppSheet, I format it so that all of the text is green, in color. The forecast column gets populated with words like โMostly Cloudyโ, โCloudyโ, โRainโ, etcโฆ
I want to be able to highlight the text in the color Red, whenever the words โRainโ or โShowersโ or โT-stormsโ shows up in the [Forecast] column. Please see attached. Iโve tried a bunch of different AND, NOT, OR comboโs and canโt seem to figure out. Anyone have any ideas?
Thanks
@Brady_Lovell Make a format rule with the condition OR([Forecast] = โRainโ, [Forecast] = โT-Stormsโ, [Forecast] = โShowersโ). Make sure to select the columns you want formatted.
Also, if you have an existing โall green everythingโ format rule, make sure your overriding rainy weather rule appears after it. From the docs:
" If two matching rules conflict in their formatting information, the last rule takes precedence."
help.appsheet.com - Format Rules: The Essentials Format Rules: The Essentials help.appsheet.com
Hi @Brady_Lovell, have you tried CONTAINS. eg
CONTAINS([VENUE],โCANCELLEDโ)
etc. Just use your data.
You could write that expression also likeโฆ IN([Forecast],LIST(โRainโ,โT-Stormsโ,โShowersโ))
User | Count |
---|---|
41 | |
27 | |
26 | |
20 | |
13 |