how automatically fill cells when update row from form ?

mohammad saaideh

HI

I am using ...INDEX({Hailo}, MATCH(MAX(COLLECT({Cumulative counter}, {Tech name}, @cell = [WTG 2]90)), {Cumulative counter}, 0)) .... function , to get last updated cell from form .

but if i didnt fill every cells in row the smartsheet will take now row with empty cell for ex :

row 1: name /age/gender

after get update from form and just update the age :

new row 1 : new name /age(empty)/gender (empty)

and the sheet what i take information to will show::

row1: new name /invalid data (bcz its empty from source)

mohammad saaideh

Hi Genevieve P,

Thanks for answering i was kept trying until i find this formula :

=IFERROR(IF(ISBLANK(INDEX{Source Column} , MATCH(MAX(COLLECT({Cumulative counter}, {Tech name}, @cell = [WTG 1]89)), {Cumulative counter}, 0))), INDEX({Source Column}, MATCH(MAX(COLLECT({Cumulative counter}, {Tech name}, @cell = [WTG 1]89, {Source Column}, <>"")), {Cumulative counter}, 0)), INDEX({Source Column}, MATCH(MAX(COLLECT({Cumulative counter}, {Tech name}, @cell = [WTG 1]89)), {Cumulative counter}, 0))), "")

If sys find cell blank in the MAX , that mean no change on that cell in row , the change happend to another cell , so if its blank in new row get the last cell not blank .

and its work very good .

thanks you