Set a dropdown value when adding a row using Outlook add-in

hanseric

I'm seeking the ability to set a dropdown value (e.g. "New" in "Status" column) when adding a row to a sheet via either manual entry or (more likely) using the Outlook add-in.

Is there a way to do that?

Andrée Starå

Hi,

Yes, there is. You could have a formula in the Status column, and as long as at least two previous/following rows have the same formulas, it will work.

You might have to restructure the design so the rows would be added to the top instead or add a divider with two rows with the formula because I assume that you'd want to change the Status, and that would delete the formula.

Something like this.

Try something like this.

=IF(ISBLANK(Primary@row); ""; "New")

The same version but with the below changes for your and others convenience.

=IF(ISBLANK(Primary@row), "", "New")

Depending on your country, you’ll need to exchange the comma to a period and the semi-colon to a comma.

Would that work?

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD