Discussions

Expand all | Collapse all

I'm trying to create a sort-able column that, A) puts empty dates cells at the bottom and B) put sites with a certain date at the top

  • 1.  I'm trying to create a sort-able column that, A) puts empty dates cells at the bottom and B) put sites with a certain date at the top

    Posted 07-11-2018 18:13
    I'm trying to sort my report by ascending on the milestone (CI025), with blanks at the bottom.  I also want it sorted so that when the milestone (CI020) has a date it's at the top of the report.  I currently have a formula to that puts the blank dates at the bottom and sorts by CI025, but I can't figure how to move the entries with a CI020 to the top.  Below is the formula I have so far.

    If(ToText([VINC CI025 (MS095) ACT])="","zzzzzzzz",ToText([VINC CI025 (MS095) ACT]))


  • 2.  RE: I'm trying to create a sort-able column that, A) puts empty dates cells at the bottom and B) put sites with a certain date at the top

    Posted 07-11-2018 21:55
    I'm not quite understanding what field type that is, but in general you can just list your coniditons and results like this

    IF(
    ToText([VINC CI025 (MS095) ACT])="","zzzzzzzz",  // zzz will sort last
    ToText([VINC CI020 (MS095) ACT])<>"  ", // blank will sort first,
    ToText([VINC CI025 (MS095) ACT]) // else use this field to sort.