Forum Discussion

serene06's avatar
serene06
Copper Contributor
Apr 12, 2022
Solved

Weight loss in lbs. and body fat %

Hi, I am tracking weight and body fat % bi-weekly.  I was wondering if there Is a way to update the total weight loss and body fat loss based on the updated data entered bi-weekly. Start Weight ...
excel
  • mtarler's avatar
    mtarler
    Apr 18, 2022

    serene06  In the attached I expanded the file/table to include ID and week and formatted as a table to use structured references.  The formulas find the value for the row with the same ID AND says "start" under the Week and subtract from there.  I do this all under 1 table as it does make a number of things easier (i.e. any kind of group metrics like my clients lost a total of  or average of ...).

    i also added another tab to help you pull ONLY a single person's info.  I used a pivot table but you could also use the FILTER() functions.

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Apr 12, 2022

serene06 

Unfortunately i didn't understand where the data is located in your sheet. You can try the updated attached file with data in range D5:M5.

serene06's avatar
serene06
Copper Contributor
Apr 12, 2022

OliverScheurich 

Can you tell me how to upload the file since I do not see the paper clip?

  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Apr 13, 2022

    serene06 

    I can attach files this way:

    Reply -> Open full text editor -> Browse

     

    Otherwise it could be possible to open your profile and to select Messages and then to upload a file and to write a message.