Removing Zero from my results
Can anyone see what is wrong with this equation. Trying to remove zero from my column when nothing has been done.
=IF({08 - Estimating # of Pricing} = 0, INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)), "")
Best Answer
-
It sounds like you are trying to return the value from 08 - Estimating # of Pricing in a different sheet where the Job # matches, but if this is 0 you want to return blank? Is that correct?
If so, I believe you need to have the IF evaluate the result of the INDEX MATCH rather than the column as it won't know which cell in the column to look at. Try this:
=IF(INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)) = 0, "", INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)))
Answers
-
It sounds like you are trying to return the value from 08 - Estimating # of Pricing in a different sheet where the Job # matches, but if this is 0 you want to return blank? Is that correct?
If so, I believe you need to have the IF evaluate the result of the INDEX MATCH rather than the column as it won't know which cell in the column to look at. Try this:
=IF(INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)) = 0, "", INDEX({08 - Estimating # of Pricing}, MATCH([Job #]@row, {08 - Estimating Sheet Job #}, 0)))
-
TYVM
-
NP, HTH
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!