I made an app to track volunteer sign-in and sign-out. I am trying to add an option of viewing volunteers who are currently “signed in”. Essentially I want to view a slice of just today’s information. Preferably only the volunteers that are still volunteering. I am looking for the expression that I would need to make that happen?
You could try something like AND([Date]=TODAY(),[Status]=“Signed in”)
@Aleksi_Alkio I was trying variations of that and i couldn’t shake the data from previous days. I’ve since been working on making a separate google sheet with the formulas I need to glean what i need from the data in my original sheet.
You don’t need to create another sheet. You can do that with the slice. Would you please show what have you tried so we could have an idea what are you looking for.
AND([Date]=TODAY(), [Status]=“Signed in”)
among a few others.
Do you have these columns in a same table? And you have both Date and Time Out columns as well?
Yeah here is what i have as columns
Here also is an image of the sheet.
How about… AND([Date]=TODAY(),TIMENOW()>[Time In],ISBLANK([Time Out]))
It still pulls all of the data.
Actually. it’s not doing that. If you would create a table view for that slice, you would see that all “N” records won’t show up.