Hi my friends, I am creating report for my Ap...

(Rafał Fick) #1

Hi my friends, I am creating report for my AppSheet. I wonder is there a possibility to force the report to show me conditional formatting for few cells.

Table look like in attached picture.

What I would like to have is that <> (value in %) will be green when it is 100% and if it is less then 100% will turn red if the <> is in the past

Do you think it is possible in Google docs?

(Aleksi Alkio) #2

<<IFS([DONE]=1,[DONE])>><<IFS([DONE]<1,[DONE]>> and use the green color for the 1st statement and red for 2nd statement.

(Rafał Fick) #3

@Aleksi_Alkio thank you very much.

Is there a way to make it talented also to date? Like if [date]>[now] then <<IFS([DONE]=1,[DONE]>><<IFS([DONE]<1,[DONE]>> and if [date]<[now], [DONE] ? Like this only late deliveries will show colors and the one which are not late will stay with normal color.

I just don’t know how to make this statement :confused:

(Aleksi Alkio) #4

Something like… <<IFS(AND([DATE]>NOW(),[DONE]=1),[DONE])>> <<IFS(AND([DATE]<NOW(),[DONE]<1),[DONE])>>

(Rafał Fick) #5

@Aleksi_Alkio Thank you very much. You solved all my problems :slight_smile:

(Aleksi Alkio) #6

You’re welcome