Mixed Fraction Formula

ctice

I am trying to get a cell to read 12 3/4 as 12.75 so Smartsheet will complete the math for the sheet in another cell.

Paul Newcome

Give this a go:

=IF(FIND("/", [Column Name]@row) <> 0, VALUE(LEFT([Column Name]@row, FIND(" ", [Column Name]@row) - 1)) + (VALUE(MID([Column Name]@row, FIND(" ", [Column Name]@row) + 1, FIND("/", [Column Name]@row) - (FIND(" ", [Column Name]@row) + 1))) / VALUE(RIGHT([Column Name]@row, LEN([Column Name]@row) - FIND("/", [Column Name]@row)))), [Column Name]@row)

Paul Newcome

You would need something along the lines of…

=VALUE(LEFT([Column Name]@row, FIND(" ", [Column Name]@row) - 1)) + (VALUE(MID([Column Name]@row, FIND(" ", [Column Name]@row) + 1, FIND("/", [Column Name]@row) - (FIND(" ", [Column Name]@row) + 1))) / VALUE(RIGHT([Column Name]@row, LEN([Column Name]@row) - FIND("/", [Column Name]@row))))

ctice

Thank you, I have been trying to get some of your other Formula's I found to work all morning as well. This did work for converting fractions - is there a way to add something in there to look for whole numbers as well? Sometimes we have whole number readings as well.

Paul Newcome

Give this a go:

=IF(FIND("/", [Column Name]@row) <> 0, VALUE(LEFT([Column Name]@row, FIND(" ", [Column Name]@row) - 1)) + (VALUE(MID([Column Name]@row, FIND(" ", [Column Name]@row) + 1, FIND("/", [Column Name]@row) - (FIND(" ", [Column Name]@row) + 1))) / VALUE(RIGHT([Column Name]@row, LEN([Column Name]@row) - FIND("/", [Column Name]@row)))), [Column Name]@row)

ctice

Sorry for the delay. YES this totally worked, you are greatly appreciated!!

Paul Newcome

Happy to help. 👍️