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
 Smartsheet Customer Resources
 62.4K Get Help
 364 Global Discussions
 200 Industry Talk
 430 Announcements
 4.4K Ideas & Feature Requests
 137 Brandfolder
 129 Just for fun
 128 Community Job Board
 446 Show & Tell
 28 Member Spotlight
 1 SmartStories
 284 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!