I am trying to create a spreadsheet that tracks our patients fat loss from a first visit throughout their treatment schedule here at our Health/Fitness studio. The desired functionality of this spreadsheet would be:
- Patient Name
- Initial Visit weigh-in (Track date)
- Future visit weigh-ins (Track dates)
- Total the amount of weight lost by patient.
The trick is, we'd like to track the dates of each weigh in for each client, but they're going to be different for every client. Some clients weigh in every week... some weigh in once every other month.
I can't figure out how to associate dates to weigh-ins. I've attached my lame attempt at trying to build this spreadsheet. Any pointers are greatly appreciated!
Greg Frichette
Bookmarks