I have a base for timesheets.
I have a column which is set to decimal for hours total called qty eg. 9.50 or 10.00.
Then I have a formula that will accept the total hours or put something different depending on leave status abbreviation but it won’t write down the answer as a decimal or let me format it.
So my formula is -
if({status}=“on”,qty,if(and({status}=“lwop”),“0.00”,if(and({status}=“rdo”),”8.00”)))
And for any of those combinations it comes out like eg 9 or 9.5 for “qty”, 0 for lwop and 8 for rdo
Can you help me format into same format as my other column and formula examples.
