I've come across a portion for the HSA Value Smart Worksheet. It is asking me my Year-end HSA Value. Where do I find that?

Look on form 5498 HSA in box 5  That is the fair market value of your HSA.  If you don't have one, contact your HSA trustee.