Hi, No doubt a noob question...

%3CLINGO-SUB%20id%3D%22lingo-sub-2834347%22%20slang%3D%22en-US%22%3EHi%2C%20No%20doubt%20a%20noob%20question...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2834347%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20is%20no%20doubt%20a%20easy%20one%20for%20wordwizzers%20out%20there%2C%20I'm%20stumped%20lol!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETwo%20things%20I%20am%20very%20confused%20on%20and%20cant%20seem%20to%20put%20right%2C%20I%20am%20trying%20to%20sort%20a%20document%20with%20the%20dates%20and%20information%20in%20a%20table%20to%20flip%20the%20right%20way%20up%2C%20I%20have%20looked%20at%20the%20sort%20option%20but%20it%20seems%20I%20have%20no%20clues%20what%20it%20is%20it%20is%20doing%2C%20I'm%20trying%20to%20continue%20where%20I%20left%20off%20creating%20a%20document%20with%20some%20information%20that%20someone%20has%20sent%20but%20they%20have%20sent%20starting%20it%20the%20wrong%20way%20up%20the%20way%20I%20have%20started%20it%2C%20for%20instance%20I%20need%20the%20document%20to%20carry%20on%20from%20the%2024th%20of%20August%20to%20the%209th%20of%20October%2C%20he%20has%20started%20his%20document%20from%20the%209th%20of%20October%20to%20the%2024th%20of%20August%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20the%20issue%20is%20we%20have%20columns%20with%20other%20information%20in%20with%20those%20dates%20and%20that%20also%20needs%20to%20move%20with%20the%20date%20changes.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecond%20Question%20here%20is%20sums%2C%20we%20seem%20to%20have%20issues%20with%20trying%20to%20add%20up%20some%20of%20the%20values%20in%20the%20table%2C%20it%20seems%20it%20wont%20add%20the%20selection%20i%20need%20in%20the%20column%20and%20only%20adds%20up%20a%20few%20of%20the%20values%20when%20i%20need%20the%20entire%20column%20document%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKindest%20Regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERoyal%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2834473%22%20slang%3D%22en-US%22%3ERe%3A%20Hi%2C%20No%20doubt%20a%20noob%20question...%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2834473%22%20slang%3D%22en-US%22%3E%3CP%3ELet%20me%20first%20say%20that%20I%20am%20not%20submitting%20this%20as%20a%20for%20sure%20solution%20that%20you%20need%2C%20and%20you%20may%20want%20to%20google%20what%20I%20am%20saying.%20However%2C%20I%20feel%20sort%20of%20confident%20this%20may%20be%20what%20you%20need.%3CBR%20%2F%3E%3CBR%20%2F%3EFirst%2C%20your%20dates.%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20depends%20on%20how%20these%20are%20written%20I%20believe.%20If%20they%E2%80%99ve%20been%20typed%20as%2C%20%E2%80%9C24th%20of%20August%E2%80%9D%20rather%20than%2C%20%E2%80%9C8%2F24%2F2021%2C%E2%80%9D%20I%20suspect%20this%20will%20throw%20off%20the%20sorting%20function.%20You%20might%20want%20to%20look%20into%20using%20actual%20date%20fields%2C%20and%20how%20to%20set%20their%20formatting.%3CBR%20%2F%3E%3CBR%20%2F%3ESecond%2C%20your%20sum%20issues.%3CBR%20%2F%3E%3CBR%20%2F%3EAgain%2C%20fields%20may%20solve%20this%20problem.%20If%20the%20numbers%20are%20just%20typed%20there%20it%20may%20be%20causing%20some%20issues%20even%20though%2C%20I%20admit%2C%20it%20really%20shouldn%E2%80%99t.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20believe%20what%20you%20need%20to%20do%20is%20fix%20fields%20up%20for%20all%20of%20these%20things%20so%20that%20Word%20then%20sorts%20by%20the%20field%20data%20and%20does%20math%20using%20field%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi 

 

This is no doubt a easy one for wordwizzers out there, I'm stumped lol!

 

Two things I am very confused on and cant seem to put right, I am trying to sort a document with the dates and information in a table to flip the right way up, I have looked at the sort option but it seems I have no clues what it is it is doing, I'm trying to continue where I left off creating a document with some information that someone has sent but they have sent starting it the wrong way up the way I have started it, for instance I need the document to carry on from the 24th of August to the 9th of October, he has started his document from the 9th of October to the 24th of August, 

 

Now the issue is we have columns with other information in with those dates and that also needs to move with the date changes.

 

Second Question here is sums, we seem to have issues with trying to add up some of the values in the table, it seems it wont add the selection i need in the column and only adds up a few of the values when i need the entire column document

 

Kindest Regards

 

Royal

1 Reply

Let me first say that I am not submitting this as a for sure solution that you need, and you may want to google what I am saying. However, I feel sort of confident this may be what you need.

First, your dates.

It depends on how these are written I believe. If they’ve been typed as, “24th of August” rather than, “8/24/2021,” I suspect this will throw off the sorting function. You might want to look into using actual date fields, and how to set their formatting.

Second, your sum issues.

Again, fields may solve this problem. If the numbers are just typed there it may be causing some issues even though, I admit, it really shouldn’t. Maybe make sure you use the =SUM(ABOVE) field. I assume the numbers are above and in a column. If they go into the thousands, and you have a comma as a separator, I wonder if this could also be part of the issue, which may be another good reason to use fields. 

I believe what you need to do is fix fields up for all of these things so that Word then sorts by the field data and does math using field information.