Hi,
I am having an issue with formula that adds all of the value for each column from previous days. A column is not created since data was not generated for a previous day. For example, I have a calculation that totals the time of all the fields such as Lunch time, Training time, Documentation time, Gym time, and Sleeping time. The issue is that some days we don't generate a time for a particular field which wont allow my calculation to run. How to ensure my total time calculation runs if one of these filed didn't generate time for the pervious day.
FORMULA Tool:
Lunch Time + Documentation Time + Gym Time + Sleeping Time = Total Time
Note* Sleeping Time will become grayed out
(Sleeping time didn't generate data for the previous day . How to ensure it runs even if sleeping time didn't generate or any of the the categories not creating field)
Date | Lunch Time | Documentation Time | Gym Time |
2022-04-21 | 0.009826 | 0.044144 | 1.994491 |
Sleeping Time didn't generate a column since there's was no Sleeping generated for 2022-04-21 which will not allow my formula with all the categories to run.
Any assistance will be appreciated.