Dec 22 2021 09:23 PM
Hello, so I have been following the tutorial of making a gantt sheet by The Office Lab (link:https://www.youtube.com/watch?v=OizqFlMtZLQ) and I ran into an error at around 2:55:42 when he begins to do an automatic percentage sum of the item percent's and work days. For some reason when I do the exact same code as him it is giving me an error #VALUE!. I typed in the code above in the title with my own values and rows and it will keep giving me an error when in the video his total comes out to 81%. Ive been stuck on this for a bit and its causing me to be at a standstill. If someone maybe knows why and could help that would be great! (also I know his is on the W column and my is X. Its because I wanted extra space for other areas so that should not have any change towards solution)
Dec 22 2021 10:16 PM
Dec 22 2021 10:25 PM
@LilWraith The formula shown in the formula bar in the screenshot should work. Check that cell R19 is empty. In case you have accidentally entered a space, the formula will throw a #VALUE! error.
With a space in the selected cell:
and without:
Dec 23 2021 07:48 AM
Dec 23 2021 07:55 AM
Dec 23 2021 08:07 AM
Dec 23 2021 08:14 AM - edited Dec 23 2021 08:15 AM
Wow I didn't know those were tools to use that actually helps a lot! Yes, R:19 is blank and all the rows in both columns show false for ISTEXT(). I also used the ISBLANK() on R:19 and got TRUE. Sadly it is still showing an error.
Dec 23 2021 08:19 AM
Here are some extra screenshots on the error and hopefully they may help a bit better?
Dec 23 2021 08:31 AM
Dec 23 2021 08:36 AM
Dec 23 2021 08:45 AM
SolutionDec 23 2021 09:00 AM
Dec 23 2021 08:45 AM
Solution