
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Sep 13, 2023 04:26 AM - edited ‎Sep 13, 2023 04:29 AM
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.
