How do I formulate a formula that will correspond always to the last form submission (line)?

Andi Reisner
Andi Reisner ✭✭
edited 06/15/20 in Formulas and Functions

Hi There,

I have been trying to formulate a cell which will correspond to two columns.

In Column "Name" I would like to take "Bernhard Schneider" the last submission (in this case it is line 2051) and place his yellow exclamation mark, or red x, or green tick in line 1.

Note, Bernhard Schneider will continue to submit his webform regularly and therefore I need the display to correspond always to his last submission, hence, not necessarily to only line 2051, but also future lines which will be submitted, but always his last corresponding line.

And thereafter, in line 2 under column "AED Check (Monthly)" to display the last submission from the next name, in this case "Joav Banet". Also here on a continuous formulated formula as above.

Is there a possibility to do that?

I will be grateful for any kind of support.

Kind regards,


Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!