Help

Decimal Formula Issue

Topic Labels: Community Formulas
362 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Stephanie_Wilso
5 - Automation Enthusiast
5 - Automation Enthusiast

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. 

0 Replies 0