IfError- should this work?

Someg ✭✭
edited 03/20/23 in Formulas and Functions

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!