Trying to put a value into a cell that is returned blank from formula.
I've created a column formula that returns a value from another column if it has a value in it; if that other column does NOT have a value, it returns a blank cell.
=IF(ISBLANK([Print Quantity (if known)]@row), "", [Print Quantity (if known)]@row)
The formula works just fine, but I want to be able to type in a value to the cell that came back blank. Is there a way to do that? I don't want to have to type into the cell being referenced (to populate the cell that returned blank) because it goes against the need for having two separate columns, which are needed.
Best Answer
-
You cannot have a formula and manual entry within the same cell at the same time. My suggestion would be a "Manual Entry" column that you can type into when needed then in your above IF statement you can pull the manual if it isn't blank and the calculated if the manual is blank.
=IF([Manual Entry]@row <> "", [Manual Entry]@row, [Print Quantity (if known)]@row)
Answers
-
You cannot have a formula and manual entry within the same cell at the same time. My suggestion would be a "Manual Entry" column that you can type into when needed then in your above IF statement you can pull the manual if it isn't blank and the calculated if the manual is blank.
=IF([Manual Entry]@row <> "", [Manual Entry]@row, [Print Quantity (if known)]@row)
-
Thanks, @Paul Newcome ! That's what I thought. I do already have a manual entry column setup, so I see where you're going with this solution where it could then pull the most accurate data based on what's in each column. Thanks for this workaround.
Help Article Resources
Categories
Check out the Formula Handbook template!
