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

%3CLINGO-SUB%20id%3D%22lingo-sub-2600098%22%20slang%3D%22en-US%22%3ESomething%20like%20%3DNOW(IF%20A1496%20%3D%20%26amp%3Bquot%3BOrdered%26amp%3Bquot%3B)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2600098%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20I%20write%20a%20formula%20to%20conditionally%20set%20a%20column%20to%20display%20the%20date%20a%20different%20column%20(which%20is%20a%20drop-down%20menu)%20is%20set%20to%20a%20certain%20string%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2600098%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2600276%22%20slang%3D%22en-US%22%3ERe%3A%20Something%20like%20%3DNOW(IF%20A1496%20%3D%20%26amp%3Bquot%3BOrdered%26amp%3Bquot%3B)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2600276%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1118740%22%20target%3D%22_blank%22%3E%40brentKM_VU%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ETry%3C%2FP%3E%0A%3CP%3E%3DIF(A1496%3D%22Ordered%22%2CNOW()%2C%22%22)%3C%2FP%3E%0A%3CP%3ERemark%3A%20the%20result%20of%20the%20formula%20will%20be%20updated%20each%20time%20the%20sheet%20is%20recalculated.%3C%2FP%3E%0A%3CP%3EIf%20you%20want%20to%20record%20the%20time%20that%20A1496%20is%20changed%20to%20Ordered%2C%20you'd%20need%20VBA%20code.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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 Replies

@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.

Perfect. Thank you!