Something like =NOW(IF A1496 = "Ordered")

[brentKM_VU]

Can I write a formula to conditionally set a column to display the date a different column (which is a drop-down menu) is set to a certain string?

[#2 · Accepted solution]

@brentKM_VU 

Try

=IF(A1496="Ordered",NOW(),"")

Remark: the result of the formula will be updated each time the sheet is recalculated.

If you want to record the time that A1496 is changed to Ordered, you'd need VBA code.

[#3]

Perfect. Thank you!