I made an app to track volunteer sign-in and ...

expressions
(Mitchell Daly) #1

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?

(Aleksi Alkio) #2

You could try something like AND([Date]=TODAY(),[Status]=“Signed in”)

(Mitchell Daly) #3

@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.

(Aleksi Alkio) #4

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.

(Mitchell Daly) #5

@Aleksi_Alkio [Date]=TODAY

[Time Out]=TIMENOW

AND([Date]=TODAY(), [Status]=“Signed in”)

AND([Date]=TODAY()

among a few others.

(Aleksi Alkio) #6

Do you have these columns in a same table? And you have both Date and Time Out columns as well?

(Mitchell Daly) #7

Yeah here is what i have as columns

(Mitchell Daly) #8

Here also is an image of the sheet.

(Aleksi Alkio) #9

How about… AND([Date]=TODAY(),TIMENOW()>[Time In],ISBLANK([Time Out]))

(Mitchell Daly) #10

It still pulls all of the data.

(Aleksi Alkio) #11

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.