I have a Microsoft form populating into an Office365 Excel Worksheet
I want the Data in the worksheet to be displayed on another sheet in the workbook based on a date on the form responses.
all form data is populated into a sheet titled Form1
On Sheet2 I want to only display the information from sheet Form1 if the date in cell Form1 H2:H is after TODAY() if it is before TODAY I don't care about the data any longer.
we have recently switched from GOOGLE Office 365 the formula I was using in Google was =filter('Form Responses 1'!A2:I, 'Form Responses 1'!F2:F >=TODAY(), 'Form Responses 1'!F2:F<>"")
When I try to adjust it to Officer 365 I get a Name error.
This is the Code I am trying to use in Office 365 =FILTER(Form1!G2:K, Form1!G2:G >=TODAY(), Form1!G2:G<>"")
Here is a sample of the document I am working with In this example there are 11 entries however due to stop dates on worksheet Form1 Sheet 2 should only display 7 entries
HTML Code:
Bookmarks