Forum Discussion
Table Formula Help
I have a Table (obviously), one column (B) is labeled "Status" and is limited to a data validation list; the next column to be considered in this question is column (D) which is labeled "Date Used" i...
FORMULA in cell B2
=IF(D2<>"","USED","UNUSED"). Although CF will work it doesn't necessarily means the user will necessarily select the correct option. Automating the column B with a formula, in my opinion will be a better option.
Thank you.
=IF(D2<>"","USED","UNUSED"). Although CF will work it doesn't necessarily means the user will necessarily select the correct option. Automating the column B with a formula, in my opinion will be a better option.
Thank you.