May 04 2021 03:41 PM - edited May 04 2021 03:49 PM
I want to create a rather simple view in a SharePoint Online list, but I'm having trouble with the expressions and logic. The list is a project report in which the info of all received project requests is entered daily.
I want to have a view that only shows projects entered during the last day, i.e. the latest report. I could do [Today] - 1 in a filtered view, but that breaks on weekends and Mondays, and if the user is accessing the list on the same night of a shift (they'd always see yesterday's report), I think the best way is to show elements from the most recent day, but I'm not sure how to go about doing that.
If SharePoint allows a more complicated logic in a filtered view, I haven't been able to find information on the right syntaxis, because nothing I've seen online (like using logic with WEEKDAY and similar functions) and applied to a filtered view seems to work.
Any help is much appreciated. I'm sure this can be accomplished and that I'm missing something basic (fairly new to the SP world).
Thanks in advance.