Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

ISBLANK question

David Innes
edited 12/09/19 in Archived 2016 Posts



For the life of me I can't get this to work: This is the formula I have for the far right cells, I took out my test for ISBLANK, I can't get it to work:


=IF(6500000 - [Total Earned]10 < 0, (6500000 - [Total Earned]10) * -1, (6500000 - [Total Earned]10) * -1)





Can I get a hand with this? 


Thank you





This discussion has been closed.