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

  • 0
  • 1
  • Question
  • Updated 4 months ago
  • Answered
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]))
Photo of David Lynch

David Lynch

  • 70 Points

Posted 4 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,546 Points 50k badge 2x thumb
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.