is there any way for me to do this so that when i have searched a name, i can click yes they are there e.g. they have attended and checked in to an event? and this data of attendance is stored?
Is there a way to have no data displayed from the table in the search results until someone starts typing in the search bar? Also, some of the fields in my table may remain blank…can the search results leave them blank instead of showing a 0?
You can use this function =IF(G2"", FILTER(Table3, ISNUMBER(SEARCH(G2, Table3[Full Name]))), "") to have no data displayed until start typing in the search bar.
To ensure that the search results leave blank fields as blank instead of showing a 0, you can use the IFERROR function, which ensures that if any error occurs, it returns an empty string
Good work! Although there are few videos which already shown this years back
is there any way for me to do this so that when i have searched a name, i can click yes they are there e.g. they have attended and checked in to an event? and this data of attendance is stored?
These were really great tips!!
Very useful.
very helpful. thank you
Is there a way to have no data displayed from the table in the search results until someone starts typing in the search bar?
Also, some of the fields in my table may remain blank…can the search results leave them blank instead of showing a 0?
You can use this function =IF(G2"", FILTER(Table3, ISNUMBER(SEARCH(G2, Table3[Full Name]))), "") to have no data displayed until start typing in the search bar.
To ensure that the search results leave blank fields as blank instead of showing a 0, you can use the IFERROR function, which ensures that if any error occurs, it returns an empty string
@@DailyComputingI’ll give these a shot, tysm!