You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
In this screenshot I have multiple tables that I am tracking the use of individual golf-clubs in each round. To keep from having to enter the date with each new entry in each table used would there any way to insert the date once in the table adjacent to the arrow and then have each of the individual tables use that date automatically on each new entry in the other tables as needed?
I've assumed that your dates (in each of the tables) start in cell A2.
In the Driver table, you'll enter each date as it occurs.
In cell A2 of the 4 Wood (and all other non-"Driver") tables, enter this formula:
IF(LEN(Driver::A2)<1,"",Driver::A2)
On each table (except Driver), fill the formula down to the last row of column A.
Until you enter a date (or any other content) into a cell in column A of Driver, the corresponding cell on each of the tables will contain a null string ( "" ) and appear blank. When an entry is made in a cell in column A of Driver, that entry will be immediately copied into the corresponding cell in column A of each of the other tables.
Regards,
Barry
I've assumed that your dates (in each of the tables) start in cell A2.
In the Driver table, you'll enter each date as it occurs.
In cell A2 of the 4 Wood (and all other non-"Driver") tables, enter this formula:
IF(LEN(Driver::A2)<1,"",Driver::A2)
On each table (except Driver), fill the formula down to the last row of column A.
Until you enter a date (or any other content) into a cell in column A of Driver, the corresponding cell on each of the tables will contain a null string ( "" ) and appear blank. When an entry is made in a cell in column A of Driver, that entry will be immediately copied into the corresponding cell in column A of each of the other tables.
Regards,
Barry
dtryon9981 wrote:
would there any way to insert the date once in the table adjacent to the arrow and then have each of the individual tables use that date automatically on each new entry in the other tables as needed?
If you took out the word "new" then that would be easy. In a cell where you want the date just type = then click in the cell next to the hour and hit <return>. The problem is that "old" cells will change to the new date when you change the date.
You could "remove" the formulas in the old cells before changing to a new date by selecting them, command-c to copy, and Edit > Paste Formula Results.
Or you may find it just as easy to just double-click any cell where you want to enter a date (so the the cursor is flashing in the cell) and in the menu Insert > Date & Time. You could attach a keyboard shortcut to that menu option at System Preferences > Keyboard > Shortcuts > App Shortcuts. Mine looks like this:
SG
SGIII has mentioned the issue with using a cell to enter each "new date".
You could get the resut you want by entering each new date into the next row in column A of the Driver table.
The corresponding cell in each of the other tables would contain the formula below, entered in A2 and filled down to the end of that column:
IF(Driver::A2="","",Driver::A2
The IF statement checks for the presence of a value in A2 of Driver. If the cell is empty, IF sets the cell containing the formula to a null string, which appears blank.
If there is any value other than a null string in A2 of Driver, the formula copies that value to its cell.
As the formula is filled down each column A, the A2 reference increments to match the row containing that copy of the formula.
Regards,
Barry
Barry,
Using this screenshot can you illustrate what you have suggested (How to use the formula and insert it in the 4 wood table) using the Driver & 4 Wood pls.
Global Date Insertion
