Hello,

I’m trying to figure out an easier way to  populate specific data totals from a spread sheet to a calendar. i have made a spread sheet similar to what we use (excluding patient data of course). i have to keep track of the type of beds we are needing for each day, i made a calendar to help me at a glance to see the totals but now i am  unsure of what formula i could use to total the bed types for each day.  I’m sure it is an easy thing but my googling has failed me. 
 

here is the calendar.

​Hello,I’m trying to figure out an easier way to  populate specific data totals from a spread sheet to a calendar. i have made a spread sheet similar to what we use (excluding patient data of course). i have to keep track of the type of beds we are needing for each day, i made a calendar to help me at a glance to see the totals but now i am  unsure of what formula i could use to total the bed types for each day.  I’m sure it is an easy thing but my googling has failed me.  here is the calendar.    Read More

​