The Real 0.00
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!
Best Answers

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

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

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

This is PERFECT!!! This community is AWESOME!. Thank you so much for your help @L@123 ! It's very much appreciated.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.6K Get Help
 63 Global Discussions
 68 Industry Talk
 385 Announcements
 3.5K Ideas & Feature Requests
 55 Brandfolder
 125 Just for fun
 50 Community Job Board
 465 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!