Welcome!

Decimal

Good day All:

How do I get my formula to display in decimal format? My formula currently display 1 but should display 0.5.

[C5]14 = 7600

[C6] 14= 3800

Formula: =IF([C5]14 > 0, ([C6]14 / [C6]14))

Thanks

Formulas

Hi Kam,

According to your formula, you are dividing the same field into itself.

Any number divided by itself is 1. Perhaps one of the two references in the second part of your formula should be [C5]14?

You are absolutely right! It is amazing how we miss the obvious. I made the change and have 0.5 displaying.

Thanks and sorry for the inconvenience

Not an inconvenience at all! 2 sets of eyes are better than one! Glad I could help you out!

INDEX - Collect question
Hi there, I have a project where in the project plan, based on the start date selected for a task, I'd like Smartsheet to reference another sheet (which is the table of Sprint, Start Date, Proposed Completion Date, Sprint Label) and populate the Sprint Column with the correct Sprint Label). So the formular should check…
#INVALID DATA TYPE
I created a template for a smartsheet because the previous owner no longer works for the company. I rearranged some of the columns and now the formulas are giving me this error. Can I clear the column formula and start over?
Match Function to Return Required Digits
Hi Smartsheet Community! I am running into a problem and need some help with a Row ID formula using the match function. I have a project plan that is generating a unique Row ID, using a combination of an Auto ID Column Type (Row ID), the Client & Project Code, and a match formula to return the actual position of the row in…