List Function - Adding new lines w/ formulas
 

I have created a database list (<Data <List <Create List) with 10
different columns. A couple of the columns have formulas in them that refer
to cells in the same row - for example summing up the row total.

When I add a new line, how do I get these formulas to copy into the new row?

List Function - Adding new lines w/ formulas
 

Arun wrote:
I have created a database list (<Data <List <Create List) with 10
different columns. A couple of the columns have formulas in them that refer
to cells in the same row - for example summing up the row total.

When I add a new line, how do I get these formulas to copy into the new row?

Is Tools|Options|Edit|"Extend data range formats and formulas" checked?

Ken Johnson

List Function - Adding new lines w/ formulas
 

Yes, it is.

"Ken Johnson" wrote:


Arun wrote:
I have created a database list (<Data <List <Create List) with 10
different columns. A couple of the columns have formulas in them that refer
to cells in the same row - for example summing up the row total.

When I add a new line, how do I get these formulas to copy into the new row?

Is Tools|Options|Edit|"Extend data range formats and formulas" checked?

Ken Johnson

List Function - Adding new lines w/ formulas
 

Arun wrote:
Yes, it is.

"Ken Johnson" wrote:


Do the formats/formulas exist in at least 3 of the 5 preceding rows?
Help states this requirement, however, when I try it it seems to
require that 4 of the 5 preceding rows have the formats/formulas.

Ken Johnson

List Function - Adding new lines w/ formulas
 

I do now!! Beautiful. Thank you Ken.

"Ken Johnson" wrote:


Arun wrote:
Yes, it is.

"Ken Johnson" wrote:


Do the formats/formulas exist in at least 3 of the 5 preceding rows?
Help states this requirement, however, when I try it it seems to
require that 4 of the 5 preceding rows have the formats/formulas.

Ken Johnson