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 930 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.
    • stacksofplatesS
      stacksofplates @1337
      last edited by

      @Pete-S said in MS Excel Formula; Hide #REF!:

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

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

      Does this work? https://support.microsoft.com/en-us/office/hide-error-values-and-error-indicators-in-cells-d171b96e-8fb4-4863-a1ba-b64557474439

      Actually - yes.

      It first didn’t make sense, since it mentions just A1, and implies will do while column. But when I highlight the whole column- it blanks it.

      Time to up date and back copy,...

      It’s just 50 tabs.

      That's your punishment for using excel for something it wasn't meant to do. :face_with_raised_eyebrow:

      MS Access would have been a better tool, if you are hell bent on using Microsoft Office products.

      This workbook is what I have to use to keep track of my daily/weekly hours when working remote.

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

        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.

        gjacobseG 2 Replies Last reply Reply Quote 0
        • gjacobseG
          gjacobse @1337
          last edited by

          @Pete-S said in MS Excel Formula; Hide #REF!:

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

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

          Does this work? https://support.microsoft.com/en-us/office/hide-error-values-and-error-indicators-in-cells-d171b96e-8fb4-4863-a1ba-b64557474439

          Actually - yes.

          It first didn’t make sense, since it mentions just A1, and implies will do while column. But when I highlight the whole column- it blanks it.

          Time to up date and back copy,...

          It’s just 50 tabs.

          That's your punishment for using excel for something it wasn't meant to do. :face_with_raised_eyebrow:

          MS Access would have been a better tool, if you are hell bent on using Microsoft Office products.

          Omg

          Uh no Access not even

          1 Reply Last reply Reply Quote 0
          • 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