Welcome!

% Variance between 2 numbers

I am trying to figure out the % variance between 2 numbers ($40,190,187 and $40,279,091) I just need the formula can anyone help?

Healthcare

Formulas

Assuming you want the

subtract X from Y to get an absolute value "V"

get the MAX of "X" and "Y" [to get the greater of the two]

"V"/(MAX of "X" & "Y") [format this column as percentage ---- don't forget to increase your decimal place accuracy]

=ABS([Column2]21 - [Column3]21) / MAX([Column2]21:[Column3]21)

Ezra,

I did the calculation, but I get the value 1 instead of 100%, how can I increase the decimal place to show 100 in the formula?

Thanks for the help?

Just change the column or cell to a percentage format (next to currency format in the top toolbar)

.25 = 25%

.5 = 50%

1 = 100%

Worked Thanks

This is great; however, what if you needed to show the percentage of increase OR decrease?

we have the same question at Melody...

To see if it is an increase or decrease remove the abs( ) part of the equation. It is what makes everything positive.

=[Column2]21 - [Column3]21) / MAX([Column2]21:[Column3]21

This will allow the positive and negative values to show.

Duration based on time - formula question
I was able to create a Smartsheet column with time included with the date (Thank you @Paul Newcome & @Akblevins ). I want to add another column that just shows the time - I used the AI Smartsheet feature to create a formula but receive an error message. Any ideas on how to correct? TIA!
Can't transfer ownership of a workspace
I've created a copy of my workspace and per the instructions I found at Transfer Owner permissions of a workspace | Smartsheet Learning Center, there should be a "make owner" option but there is not. I see only admin. This person has a license. I selected share at the workspace level, not file level. How do I transfer…
Automatic Notification in Form Entry
Is there a way to automatically notify an operator as they are updating a form and hit submit that their entries do not match and it's a failed audit other than email notification? ex. Audit is for ensuring batch numbers match from 2 items. If the operator enters a batch that doesn't match, we would like them to be aware…