Here are some of the codes and additional info:
Sharepoint List:
Dropshadow:
"data:image/svg+xml;utf8, " & EncodeUrl("<svg xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink' width='1126' height='56' viewBox='0 0 1126 56'> <defs> <filter id='Rectangle_32' x='0' y='0' width='1126' height='56' filterUnits='userSpaceOnUse'> <feOffset dx='0' dy='3' input='SourceAlpha'/> <feGaussianBlur stdDeviation='3' result='blur'/> <feFlood flood-opacity='0.161'/> <feComposite operator='in' in2='blur'/> <feComposite in='SourceGraphic'/> </filter> </defs> <g transform='matrix(1, 0, 0, 1, 0, 0)' filter='url(#Rectangle_32)'> <rect id='Rectangle_32-2' data-name='Rectangle 32' width='1078' height='48' rx='4' transform='translate(24 4)' fill='#fff'/> </g> </svg>")
Status Text Field:
If(And(ThisItem.Status = 1, ThisItem.AssignedName = Blank(),IsToday(ThisItem.SubmittedDate)),"New",And(ThisItem.SubmittedDate < Today()+1,ThisItem.Status = 1),"Overdue",ThisItem.Status = 2, "On Hold", "In Progress")
コメント