ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    MS Excel Formula; Hide #REF!

    Scheduled Pinned Locked Moved IT Discussion
    excelformularefhide formulaiferror
    18 Posts 7 Posters 923 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • gjacobseG
      gjacobse @stacksofplates
      last edited by

      @stacksofplates said in MS Excel Formula; Hide #REF!:

      I know you have to use this Gene. But if you are able to use something else at some point Notion is an awesome tool. I use it for almost all of my notes and a ton of different other things. You could easily do a time tracking app in it if it helps.

      I’ll look- and hold comments till then.

      stacksofplatesS jmooreJ 2 Replies Last reply Reply Quote 0
      • gjacobseG
        gjacobse @stacksofplates
        last edited by

        @stacksofplates said in MS Excel Formula; Hide #REF!:

        Notion

        yea - I may come back and use it some time in the future,.. but for this use... I'm not. and then there is this:

        8d92f620-c563-4bd9-914d-877541135098-image.png

        I really don't need yet another thing, I may not use beyond this contract. - that said.. I likely could, but I'm not exposing anymore of my personal contact information with them I don't have to..

        scottalanmillerS stacksofplatesS 2 Replies Last reply Reply Quote 0
        • scottalanmillerS
          scottalanmiller @gjacobse
          last edited by

          @gjacobse said in MS Excel Formula; Hide #REF!:

          @stacksofplates said in MS Excel Formula; Hide #REF!:

          Notion

          yea - I may come back and use it some time in the future,.. but for this use... I'm not. and then there is this:

          8d92f620-c563-4bd9-914d-877541135098-image.png

          I really don't need yet another thing, I may not use beyond this contract. - that said.. I likely could, but I'm not exposing anymore of my personal contact information with them I don't have to..

          Clockify is great. I use that all of the time.

          1 Reply Last reply Reply Quote 0
          • stacksofplatesS
            stacksofplates @gjacobse
            last edited by

            @gjacobse said in MS Excel Formula; Hide #REF!:

            @stacksofplates said in MS Excel Formula; Hide #REF!:

            I know you have to use this Gene. But if you are able to use something else at some point Notion is an awesome tool. I use it for almost all of my notes and a ton of different other things. You could easily do a time tracking app in it if it helps.

            I’ll look- and hold comments till then.

            Here's a quick one I put together. You could do manual time or calculated from the date. And the cool thing is everything can be related. So the second screenshot shows what happens if you click on "Did Thing" which is it's own page (like an object).

            f9c168ef-73ec-40ff-9797-b0ad3cacb073-image.png

            ef5e28c7-12f0-4f20-a6f6-f762976aa7a7-image.png

            1 Reply Last reply Reply Quote 0
            • jmooreJ
              jmoore @gjacobse
              last edited by

              @gjacobse said in MS Excel Formula; Hide #REF!:

              @stacksofplates said in MS Excel Formula; Hide #REF!:

              I know you have to use this Gene. But if you are able to use something else at some point Notion is an awesome tool. I use it for almost all of my notes and a ton of different other things. You could easily do a time tracking app in it if it helps.

              I’ll look- and hold comments till then.

              Yeah Notion is good for a lot of things.

              1 Reply Last reply Reply Quote 0
              • stacksofplatesS
                stacksofplates @gjacobse
                last edited by stacksofplates

                @gjacobse said in MS Excel Formula; Hide #REF!:

                @stacksofplates said in MS Excel Formula; Hide #REF!:

                Notion

                yea - I may come back and use it some time in the future,.. but for this use... I'm not. and then there is this:

                8d92f620-c563-4bd9-914d-877541135098-image.png

                I really don't need yet another thing, I may not use beyond this contract. - that said.. I likely could, but I'm not exposing anymore of my personal contact information with them I don't have to..

                Another option is a Kanban board. You can track time through moving your cards across and then get reports on time cards have spent in each column. Kanboard works well and is open source and has nice reports. If you don't want to run it yourself things like Trello work decently as well but I can't speak to the reports you can get from it.

                J gjacobseG 2 Replies Last reply Reply Quote 0
                • J
                  JasGot @stacksofplates
                  last edited by

                  @stacksofplates said in MS Excel Formula; Hide #REF!:

                  Another option is a Kanban board

                  Is Decks in Nextcloud a type of KanBan?

                  scottalanmillerS 1 Reply Last reply Reply Quote 0
                  • scottalanmillerS
                    scottalanmiller @JasGot
                    last edited by

                    @JasGot said in MS Excel Formula; Hide #REF!:

                    @stacksofplates said in MS Excel Formula; Hide #REF!:

                    Another option is a Kanban board

                    Is Decks in Nextcloud a type of KanBan?

                    Yes

                    1 Reply Last reply Reply Quote 0
                    • gjacobseG
                      gjacobse @stacksofplates
                      last edited by

                      @stacksofplates said in MS Excel Formula; Hide #REF!:

                      @gjacobse said in MS Excel Formula; Hide #REF!:

                      @stacksofplates said in MS Excel Formula; Hide #REF!:

                      Notion

                      yea - I may come back and use it some time in the future,.. but for this use... I'm not. and then there is this:

                      8d92f620-c563-4bd9-914d-877541135098-image.png

                      I really don't need yet another thing, I may not use beyond this contract. - that said.. I likely could, but I'm not exposing anymore of my personal contact information with them I don't have to..

                      Another option is a Kanban board. You can track time through moving your cards across and then get reports on time cards have spent in each column. Kanboard works well and is open source and has nice reports. If you don't want to run it yourself things like Trello work decently as well but I can't speak to the reports you can get from it.

                      I used Trello for someone’s tracking-
                      Hated it. Maybe I need to use it more,... maybe

                      1 Reply Last reply Reply Quote 0
                      • scottalanmillerS
                        scottalanmiller
                        last edited by

                        We use Trello and like it a lot, but we use it for a coding process, not job tracking.

                        1 Reply Last reply Reply Quote 0
                        • 1 / 1
                        • First post
                          Last post