I'm struggling to figure out how to combine two formulas. 

Context: my team doesn't like to think in hours, just general size of a task (S, M, L,) so I've created a helper column where each value relates to a number (XS = 1, S = 2, M = 4, L = 8, XL = 16), and an IF statement to return the values.


I found a dashboard chart on a SmartSheet template that I'm trying to duplicate.  I've verified the data in the chart is the same between "My Chart" and the "Template Chart".  I've verified the chart config is the same.  What the chart shows is different and doesn't seem to reflect my data



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 +