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?
<<IFS([DONE]=1,[DONE])>><<IFS([DONE]<1,[DONE]>> and use the green color for the 1st statement and red for 2nd statement.
@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
Something like… <<IFS(AND([DATE]>NOW(),[DONE]=1),[DONE])>> <<IFS(AND([DATE]<NOW(),[DONE]<1),[DONE])>>
@Aleksi_Alkio Thank you very much. You solved all my problems
You’re welcome
User | Count |
---|---|
41 | |
36 | |
30 | |
23 | |
16 |