Avoiding #INVALID DATA TYPE when cells are blank
I am setting up a staffing leave Smartsheet for my team and unfortunately I am getting the #INVALID DATA TYPE error message.
There are 2 formulae set up within the sheet:
Leave Remaining (the dark grey row) is calculated as follows: =[Leave Allowance] - Taken + [Leave Bought] + Carried + [Long Service]
Taken (the dark grey row) is calculated as follows: =SUMIFS(Taken2:Taken6, [Leave Type]2:[Leave Type]6, "Annual Leave") - There are other types of leave but for this instance I only want it to calculate annual leave.
I realise the error message is coming up as there is no data in the start date/end date on row 3 however, how can I get round this. In Excel, it would allow me to have no data in and it would fill the Taken column with a value of "0".
Is it a different formula I need to apply? Any help would be much appreciated!