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?
Seems to be tied to the Math column. Whenever I add one and mess with it a bit, other columns (even ones not associated to the math column)—specifically relation/rollup columns— display as empty which appears to affect the math column. The data is still there, though, because when I refresh the tab, all is restored.