Google Sheets formula help for a task calendar (day,datevalue if,iferror, vlookup and indirect etc)
Budget: $10 – $30 AUD
I'm looking for help by an experienced formula user with a Google Sheets 2023 calendar template that I have created. The calendar displays any given month of the 2023 by selection from a drop down list (cell B1). I have 2023 calendar dates working correctly.
The goal is to add the words 'testing1' & 'testing2 in cells K4:K5 to this calendar so that it is viewable against the corresponding date when selecting the relevant month from the list. To make this work I need further assistance with my if/iferror/vlookup/indirect formulas which are inside the white cells of the calendar.. They are about 90% correct, I am still learning so I still have some gaps of knowledge
I also require the formula to replace any 'false' values shown which are days not relating to the month being viewed, this will be via an IFERROR. If there is a way to shade out these false boxes to a light grey for example that would be ideal.
If you have expertise with complex formulas such as IF, INDIRECT, IFERROR, and VLOOKUP, please get in touch. Further details on the project can be provided upon request. Thanks!
The goal is to add the words 'testing1' & 'testing2 in cells K4:K5 to this calendar so that it is viewable against the corresponding date when selecting the relevant month from the list. To make this work I need further assistance with my if/iferror/vlookup/indirect formulas which are inside the white cells of the calendar.. They are about 90% correct, I am still learning so I still have some gaps of knowledge
I also require the formula to replace any 'false' values shown which are days not relating to the month being viewed, this will be via an IFERROR. If there is a way to shade out these false boxes to a light grey for example that would be ideal.
If you have expertise with complex formulas such as IF, INDIRECT, IFERROR, and VLOOKUP, please get in touch. Further details on the project can be provided upon request. Thanks!