Sign in to join the conversation:
I am trying to multiply two cells and I get and error when one is a zero.
The "Number of Boxes to Order" column has an IF formula in it. The price column has a link from another sheet. I'm not sure why I'm getting an error when the IF formula spits out a zero value.
I have the same issue.. Did you get a resolution on this?
Hey @Aric Dodd
Try wrapping your formula in an IFERROR statement:
=IFERROR(formula, 0)
Cheers,
Genevieve
Here was my original formula... =IFERROR(VLOOKUP([Project ID]@row, {PSG PM Hours Range 2}, 4, false), "0") after looking at you example, I removed the "" from around my 0. Now it is working! Fantastic, thank you for the quick reply! This is working now: =IFERROR(VLOOKUP([Project ID]@row, {PSG PM Hours Range 2}, 4, false), 0)
I've got the following formula in a Check Box column to check when something is due in the Next 3 weeks. =IFERROR(IF(AND(WEEKNUMBER([Projected Cleaning Date]@row ) = WEEKNUMBER(TODAY()) + 3, YEAR([Projected Cleaning Date]@row ) = YEAR(TODAY())), 1), "") I have them for 2 weeks, 3 weeks, 4 weeks, and 5 weeks. These stopped…
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…
I have two formulas which work well independently, but when I combine them they don't. formula 1: =IF(YEAR([Joined date]@row ) = 2025, JOIN(COLLECT({Membership Survey 2025 - Experience}, {Membership Prioritisation Survey 2025 - Org}, [Organisation name]@row ))) formula 2: =IF(YEAR([Joined date]@row ) < 2025,…
