I am building a personal health app.
One sheet has a date, and corresponding to each date, the user enters personal log of items such as number of hours slept, quality of sleep etc. Lets call this sheet “Personal Log”
I have created another sheet, which I am building as a “dashboard”. I have related the date column in the “Dashboard” sheet to the “Date” column in the “Personal Log” sheet. I have looked up 2 details from the Personal Log into the Dashboard (Lets call them column A & column B). Each time I try to do any math on these 2 columns, the “Date” column in the Dashboard sheet goes blank. This has happened multiple times. Any inputs on why this is happening?