The Real 0.00

Pam Ferguson

Okay, I need the Smartsheet Community again.....I am having difficultly in figuring this out and thought that maybe you might be able to help me get over the “hurdle” with this one.

 I have several columns

Variance  $2.98

CTD_WD_0056 CALC (HELPER)]  -$2.98

 The problem is the extra decimal places, as I am bringing the data in from another system, I only care about 2 decimal places. These two columns are calculated columns and appear as such. I am having difficulty as the system is not seeing 0.00 as 0.00 (it could actually be 0.0013) on some of the numbers if you put back the decimal places.

Bottom Line: IF Variance is Positive, and Variance - CTD_WD_0056 CALC (HELPER) = 0.00, then check then box

  I have tried all different ways, and those extra digits in the following decimal place are catching me up on just two of them. I originally tried this formula:

Any suggestions or tips on how to get around that would be greatly appreciated!

L_123

=if(and(variance@row >=0, rounddown([CTD_WD0056 CALC (HELPER)]@row,2)=0),1,0

give that a try

Pam Ferguson

This is PERFECT!!! This community is AWESOME!. Thank you so much for your help @L@123 ! It's very much appreciated.

L_123

=if(and(variance@row >=0, rounddown([CTD_WD0056 CALC (HELPER)]@row,2)=0),1,0

give that a try

Pam Ferguson

This is PERFECT!!! This community is AWESOME!. Thank you so much for your help @L@123 ! It's very much appreciated.