Forum Discussion
Populating cells with a Date across 12 TABS
- look at both as decimal (or percentage) are they the same or off by 100? It looks like the rate schedule is a true decimal number (i.e. 0.00088 or 0.088%) while the other number is coming in as % units (i.e. 0.088 which if formatted as % would be 8.8%) so basically you need to convert from % UNIT to decimal value.
=(ROUND(K6,3)= ROUND(100*K$3,3))
or BETTER yet change the formula in K3 to be =100*... so
=100*XLOOKUP(LEFT($I5,3),LEFT('Rate Schedule'!$B5:$B16,3),'Rate Schedule'!C5:C16,"error")
Carl_61 mathetes First off, thank you for the kind words and I agree in spades about the kindness and generosity of the many contributors here and on other forums that both share their knowledge and lend aid to people of all skill levels. No we are not an official team but I have been on a number of posts with John and always appreciate his input as we so often agree on best practices and he often says what I would think.
What I wanted to add here was to comment on Carl's request for a red/green dot. Again, with the conditional formatting I already did with the whole line being green when all 3 are done, light blue for individual meter reads and white for undone reads, I think it is pretty clear.
(hmmm, might be nice if you extended that green onto the building number too. Simple change the 'Applied to' range of that conditional formatting to be $a:$J)
BUT you say you like the True/False column that John made which you should be able to copy over and you can then use conditional formatting to add a red/green dot. I think this could be a great exercise for you to learn more about conditional formatting. As shown in the picture below there are a number of options in the 'Icon Sets' for you to pick from and 'play' with to learn. Apply it to the true/false column you create and if you don't want to see the text there is an option to 'show icon only' or if you could always make the text 'white' to be not visible on the white background:
Just to be clear, I am speaking to the workbook attached and the Tally Sheet Tab Column "L" All Meters Read? column in regards to the True or False. I was just saying that instead of "True", True is represented by a Green Dot/Circle and instead of "False", False is represented by a Red Dot/Circle. I will try to make that happen but I just wanted to point out the Work Sheet & Tally Sheet I thought would be the most functional for me. Thank you to both of you and now I just have to figure out how to implement these 2 into the UMS Workbook and make them functional.