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
      last edited by

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

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

        @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.

        1 travisdh1T 2 Replies Last reply Reply Quote 1
        • 1
          1337 @gjacobse
          last edited by 1337

          @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.

          stacksofplatesS gjacobseG 2 Replies Last reply Reply Quote 0
          • travisdh1T
            travisdh1 @gjacobse
            last edited by

            @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.

            Please tell me this spreadsheet did not originate from MS Dynamics?

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