IfError- should this work?
I Am trying to get an IfError formula to work and not having any luck. CAn anyone help?
=IFERROR([Product Type]@row = "Hardware", [Actual Shipment Date]@row >TODAY(-12), [Backlog @ Bud]@row), " ")
I want that if a row is hardware and the actual ship date is not within the last 12days it populates the cell with the value from backlog@bud. If this is an error I want 0.
Answers
-
Try an IF/AND.
=IF(AND([Product Type]@row = "Hardware", [Actual Shipment Date]@row >TODAY(-12)), [Backlog @ Bud]@row)
-
Hi Paul
thanks for the suggestion - this produced no errors but also returned no values in the cell
-
Can you provide a screenshot of an example where it should be pulling but is not?
-
I just re-read your original post. Try switching it from "greater than" TODAY(-12) to "less than" TODAY(-12).
-
If i remove the IfError and make it just am If Formula:
=IF([Product Type]@row = "Hardware", [Actual Shipment Date]@row < TODAY(-12), [Backlog @ Bud]@row)
it works but cells that don't match return a :
#INVALID COLUMN VALUE
So its just my IFError element that isnt working
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!