Auto fill cell based on drop down menu

One way is to do this:

Set up a Pop-Up Menu (they're not called drop-down menus in Numbers):

Then use this formula in D3, filled down:

=INDEX({"A";"B";"C"},MATCH(C3,{1;2;3},0))

The MATCH finds where the value in C3 occurs in the list in the second set of brackets. The INDEX then retrieves the corresponding value from the list in the first set of brackets.

Substitute ; for , in the formula if your region uses , as a decimal separator.

SG

Hi Hugh,

The lengths of time are not Duration format. They are text. Text is automatically aligned left. SUM ignores Text.

With proper Duration format, formula in Footer Cell D8 =SUM(D) gives the correct result.

How are you entering the durations? If from a Pop-Up Menu, they are likely to be text.

Regards,

Ian

Just guessing but perhaps you put the 2d 7h 35m directly in the list in the formula. Unfortunately Numbers won't recognize it as a duration. So as a workaround you could put the number of minutes in the Pop-Up Menu. Then use an extra column to convert that to Duration, something like this:

The formula in E3:

=DURATION(,,,D3)

converts the number of minutes to a Duration, which can then be added as Ian demonstrates.

SG

What specific formula are you using?

SG

You can change how the duration displays here:

SG