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.
@Aleksi_Alkio [Date]=TODAY
[Time Out]=TIMENOW
AND([Date]=TODAY(), [Status]=โSigned inโ)
AND([Date]=TODAY()
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.
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |