I would love to be able to take action within a formula based upon which specific error the formula spits out. Right now, the IFERROR function catches errors but doesn't tell us what kind of error it …
I have columns that are set to take certain types of data, and they contain formulas that fill the cells with values permissible within that data type. For instance, there's a field where a formula fi…
This formula is producing syntax error when I try to make the column a "column formula". Is there a workaround? As we add new Rows (copied from different sheet), I want all values in Client Name colum…
The error message is that the syntax is not right. =IFERROR(NETWORKDAY([Date of Visit]1, Created1) - 1, "Need Data") I've always gotten such great support here. I appreciate any help. Best, Craig