Possible to return original entered value in formulas?
Hi there! I'd like to use a simple IF expression to test a condition in another column. If that statement returns FALSE, I'd like to KEEP the originally entered data in the cell. Is something like this possible?
The Unfilled column is a check box to indicate that a staffing shift is currently unfilled. If the box is NOT checked, I'd like to keep the user's entry.
=If(Unfilled@row, "UNFILLED", ORIGINAL VALUE ENTERED)
Help Article Resources
Check out the Formula Handbook template!