1

For a project i have made a custom list which calculates deadlines (document needs to be submitted before this date) depending on a start date (8 deadlines, 8 columns). Each row is another case with (possibly) another start date and other deadlines.

In another view it's possible to fill in when/if the document was submitted for each deadline (also 8 columns with date fields)

I would also need a view which shows all the rows where a deadline is overdue and there was no file submitted (no filled in date in the second view).

I have tried using a filter but it didn't work out, any suggestions?

Thanks in advance.

0

In order to to filter out values based on date, you should use [Today] as a filter value in creating your view.

enter image description here

For example, if you want to show items whose dates have not passed the deadline, use the above. 'Less than' will filter out all dates beyond today's date. Just reverse the logic if you would like to show item whose dates have passed the deadline.

Hope this helps

|improve this answer|||||
  • yes this works for 1 deadline but not for all the deadlines (also there's a max of 10 filters and i need 16 (2 per column) ) – Seth Verfaillie Mar 2 '16 at 9:09
  • Well then you're best off splitting into multiple views. Given SharePoint's limit to the number of filters – George Grainger Mar 2 '16 at 9:10
  • that's what I thought but it doesn't really look nice that way does it.. also will this work on more than column? I tried it and it didn't work.. – Seth Verfaillie Mar 2 '16 at 9:16
  • What exactly did you try? This should work. Pattern should follow; "Column Name" > is less than/is greater than > [Today] – George Grainger Mar 2 '16 at 9:18
  • prntscr.com/aa6cbd It should go on until evo 8 deadline, somehow when using the OR it doesnt split it as 2 different filters if u understand what i mean – Seth Verfaillie Mar 2 '16 at 9:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.