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 fills in one of several options based on a cell reference, or the user can manually select one of the options from a dropdown…
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 column to equal Task column Row 1.
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
