Calendar Tracker

%3CLINGO-SUB%20id%3D%22lingo-sub-2772028%22%20slang%3D%22en-US%22%3ECalendar%20Tracker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2772028%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EJust%20created%20a%20calendar%20tracker%20and%20joined%20two%20sets%20of%20data%20together%20but%20when%20i%20go%20to%20my%20monthly%20calendar%20view%20data%20is%20there%20but%20missing%20the%20end%20of%20text%20i.e%20joined%20with%20a%20concatenate%20formula%20Nikau%20Edwards%20with%20Class%202%20Practical%20training%20but%20returns%20%22Nikau%20Edwards%20-%20Class%202%20P%22%20so%20the%20following%20text%20is%20missing%20%22ractical%20training%22%20is%20there%20something%20wrong%20with%20the%20format%20-%20can%20send%20file%20%3F%20thanks%20Sanjai%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2772028%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2772056%22%20slang%3D%22en-US%22%3ERe%3A%20Calendar%20Tracker%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2772056%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1162714%22%20target%3D%22_blank%22%3E%40Sanjai187%3C%2FA%3E%26nbsp%3B%20The%20macro%20you%20are%20using%20specifically%20is%20cutting%20it%20off%20at%2025%20characters.%26nbsp%3B%20It%20is%20designed%20to%20give%20you%20a%2025%20character%20preview%20of%20the%20item%20(i.e.%20fit%20on%20a%20single%20line)%20and%20then%20add%20additional%20items%20for%20that%20day%20on%20subsequent%20lines%20in%20the%20date%20box.%26nbsp%3B%20I%20deleted%20that%20restriction%20in%20the%20attached%20but%20didn't%20test%20if%20it%20might%20cause%20other%20issues.%3C%2FP%3E%3CP%3Esorry%20for%20the%20EDIT%3A%20In%20order%20to%20see%20the%20change%20just%20click%20next%20month%20and%20then%20prev.%20month%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Just created a calendar tracker and joined two sets of data together but when i go to my monthly calendar view data is there but missing the end of text i.e joined with a concatenate formula Nikau Edwards with Class 2 Practical training but returns "Nikau Edwards - Class 2 P" so the following text is missing "ractical training" is there something wrong with the format - can send file ? thanks Sanjai

 

 

2 Replies

@Sanj187  The macro you are using specifically is cutting it off at 25 characters.  It is designed to give you a 25 character preview of the item (i.e. fit on a single line) and then add additional items for that day on subsequent lines in the date box.  I deleted that restriction in the attached but didn't test if it might cause other issues.

sorry for the EDIT: In order to see the change just click next month and then prev. month 

Brilliant! Thanks!