Insert Colorful Status RYG Images in the Reports

[jkevz]

Can you please confirm if this option inserting color in the doc template is still working until now? If yes, can you please check my formula below? I checked it before I apply in my template however, it is not working.

<<CONCATENATE(“https://placehold.jp/”,IF(TEXT([Date (From)],“Ddd”)=“Fri”,“ffffff/150x150.png?text=OFF”,“”),SELECT(Attendance Report[Overtime Hours],and([Refhouse ID]=“REF0358”,[Date of Attendance]=[_THISROW].[Date (From)])))>>

What I am trying to do is to highlight the color of the cell in my google doc template when the [Date (from)] column value is “Fri” or Friday and Saturday.

[Suvrutt_Gurjar]

Based on understanding of your requirement, please try an expression something like

<<CONCATENATE(“https://placehold.jp/”,

SWITCH(TEXT([Date (from)], “Ddd”),“Fri” ,“228C22”,“FFCC00”)

,“/ffffff/150x150.png?text=”,SWITCH(TEXT([Date (from)], “Ddd”),“Fri” ,“OFF”,ANY(SELECT(Attendance Report[Overtime Hours],and([Refhouse ID]=“REF0358”,[Date of Attendance]=[_THISROW].[Date (From)])))))>>

Please use the desired color codes in place of “228C22”,“FFCC00” in the suggested expression above.

[jkevz]

@Suvrutt_Gurjar

CONCATENATE(“https://placehold.jp/”,

SWITCH(TEXT([Date (from)], “Ddd”),“Fri” ,“228C22”,“FFCC00”)

,“/ffffff/150x150.png?text=”,SWITCH(TEXT([Date (from)], “Ddd”),“Fri” ,“OFF”,ANY(SELECT(Attendance Report[Overtime Hours],and([Refhouse ID]=“REF0358”,[Date of Attendance]=[_THISROW].[Date (From)])))))

Your formula is valid, however the result is the url address. Please find below screenshot

[Suvrutt_Gurjar]

The column type needs to be thumbnail type. Please ensure that. It was mentioned in the original post.

@Suvrutt_Gurjar

The app formula for the thumbnail type color image column [StatusCMonth] in the example is something like

[jkevz]

@jkevz

CONCATENATE(“https://placehold.jp/”,IF(TEXT([Date (From)],“Ddd”)=“Fri”,“ffffff/150x150.png?text=OFF”,“”),SELECT(Attendance Report[Overtime Hours],and([Refhouse ID]=“REF0358”,[Date of Attendance]=[_THISROW].[Date (From)])))

Hello! Sorry for late response. I followed all your formula. But still not displaying the color in my document. Can you please check below?

Below is my app formula

CONCATENATE(“https://placehold.jp/”,

SWITCH(TEXT([Date (Start)]+5, “Ddd”),“Fri” ,“f08c00”,“FFCC00”)

,“/ffffff/150x150.png?text=”,SWITCH(TEXT([Date (Start)]+5, “Ddd”),“Fri” ,“OFF”,ANY(SELECT(Attendance Report[Regular Working Hours],and([Refhouse ID]=[_THISROW].[Employee No.],[Date of Attendance]=[_THISROW].[Date (Start)]+5)))))

Below is my column that is set for Thumbnail

And below is the result when I run the test

[Suvrutt_Gurjar]

Not sure why you are adding 5 to the date ([Date (Start)]+5) . This means, a date on Sunday will show it as off and not Friday.

In my testing the expression is perfectly working. In the example below the thumbnail turns orange on 5th and 10th October because those are Sundays.

[jkevz]

Thanks for responding! The value of column [Date (Start)] in my table is 21-Sep, so if you add 5, then it will be equal to 26-Sep which is Friday.

In your app, you are right that the color yellow is working properly. However, please try to apply this color in your google doc template if it will work or not.

[Suvrutt_Gurjar]

Hi

It works for me in the template as well. Please note that the date is in the US format mm/dd/yyyy in the test app that I tested.

So 10/5/2025 is the date of 5th October 2025

I set up the test expression similar to yours

CONCATENATE(“https://placehold.jp/”,

SWITCH(TEXT([Order Date] +5, “Ddd”),“Fri” ,“228C22”,“FFCC00”)

,“/ffffff/150x150.png?text=”,SWITCH(TEXT([Order Date]+5, “Ddd”),“Fri” ,“OFF”,ANY(SELECT(Customers[Name],and([State]=“WA”,[City]=“Bellevue”)))))

Other day