Trying to use a URL field in Rich Text formula field to display and image

Maybe try this

"<a href=" & "<img src=" & [Photo Exterior Front from website] & "</a>"

... but I also offer some syntax below which I have used which should give you a clickable image, so that the initial display image can be set smaller, perhaps for a report and then you click the image to see the full size.

In my example, the fid for the image is 12 and the field name for the file attachment field is [Team Member Picture]

the 100 sets the height of the image, so you can try different heights.

var text image= "<img src=" & URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e12/v0' height='100' >";
var text URL= URLRoot() & "up/" & Dbid() & "/a/r" & [Record ID#] & "/e12/v0' target=_blank";

If([Team Member Picture]<>"", 
"<a href=" & $URL & ">" & $Image & "</a>")