Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Decimal Formula Issue

Topic Labels: Community Formulas
552 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