Forum Discussion

NicoleCabral's avatar
NicoleCabral
Qrew Member
10 months ago

Tracking Within a Certain Period

Need help with only tracking items in a certain period

contains(([Invoice (A)],current month), "6 - Project Complete (Current Month)")

Something like this



------------------------------
Nicole Cabral
------------------------------

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    10 months ago

    Can you say in English what you are trying to accomplish?  You posted a partial formula but I don't understand the question.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • NicoleCabral's avatar
      NicoleCabral
      Qrew Member
      10 months ago

      I have a summary table and I want to see the projects invoiced within the current month. I need a formula that will allow the projects invoiced within the current month to be labeled as, "6 - Project Complete (Current Month)." Hopefully this makes sense. Kind of hard to explain.



      ------------------------------
      Nicole Cabral
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        10 months ago

        try this (I'm assuming that ([Invoice (A)] is a date field type.

        IF(FirstDayOfMonth([Invoice (A)])=FirstDayofMonth(Today()), 

          "6 - Project Complete (Current Month).")



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------