Checkbox Formula Not Working
I am trying to write a formula that states If a value of a specific cell is equal to $0 then check a checkbox.
I have written this formula and it is not working: =IF([Remaining Value by Customer]@row = "$0", 1, 0)
The $0 in Remaining Value by Customer field has a formula in it to return the value so I am wondering if that is causing the issue?
Screenshot of the cells and formula below
Tags:
Answers

Hey @Ashleigh C
Have you tried removing the $ from your formula? The formula will count 0 values if the column is formatted in dollas.
But you've asked it to count "$0" specifically.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!