Hi,

I am trying to make a refreshable spreadsheet so i don't have to download responses and copy them into a rolling report each week.

I am in the 'lime_survey_XXXXXX' table, but I can't see how completed and non-completed answers are differentiated.

First I thought it was the 'lastpage' column, but it doesn't work for 1 pager surveys.

I want only completed answers.

Thanks

If I remember correctly, it's the "submitdate" column.