Date OR Select Values

[network_engineer]

Hi all,

I have a column C called Timeline, where I want either of the two:

Either a date OR
A list of values.

What am I trying to do? E.g. define tasks that need to be done, and the timeline. If the timeline has not been agreed, then there are values such as

- pending
- ASAP!
- conflict

So, in effect, the possible values could be only among:

- date
- pending
- ASAP!
- conflict

Is it possible to do this?

Thanks for any help.

Kind regards,
Ben

 

[Desu Nota from Columbus]

How will these values be input in Column C (Timeline)? Based off conditions of other cells or by a user input?

 

[network_engineer]

Hello!

The date (related to another thread) can be either fed manually in a certain format OR even with a drop-down list, if possible. Other values will be selected from a list.

Does that answer the question?

Kind regards.
Ben