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
David Innes ✭
edited 12/09/19 in Archived 2016 Posts

Greetings,

 

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

David

 

isblank.png

· Share on FacebookShare on Twitter

Comments

This discussion has been closed.

Categories