MrDB4Excel
Active Member
- Joined
- Jan 29, 2004
- Messages
- 348
- Office Version
- 2013
- Platform
- Windows
I have a simple date and checkmark setup that is having problems.
Prior to trying the ‘if’ and ‘or’ in the same formula I only was using if.
Then I noticed I needed to apply a separate date depending on if something was done the day before or if it was being done on the current date.
As you can see in cells E14 thru to G15 are new formulas of this type: =IF(OR($F14=$F$2,$F14=$G$2),$F$1,$G$1)
whereas below row 15, they are of this type: =IF($F16=$F$2,$F$1,"")
What am I doing wrong here? If a cell in column F is ck then the formulas would return the date in F12. If a cell in column F is dn then the formulas would return the date in F11.
Conversely, if a cell in column F is ck then in column E would be a single checkmark, and if dn then a double checkmark.
I hope this makes sense.
Any help is much appreciated.
Prior to trying the ‘if’ and ‘or’ in the same formula I only was using if.
Then I noticed I needed to apply a separate date depending on if something was done the day before or if it was being done on the current date.
As you can see in cells E14 thru to G15 are new formulas of this type: =IF(OR($F14=$F$2,$F14=$G$2),$F$1,$G$1)
whereas below row 15, they are of this type: =IF($F16=$F$2,$F$1,"")
What am I doing wrong here? If a cell in column F is ck then the formulas would return the date in F12. If a cell in column F is dn then the formulas would return the date in F11.
Conversely, if a cell in column F is ck then in column E would be a single checkmark, and if dn then a double checkmark.
I hope this makes sense.
Any help is much appreciated.
RestoreActions.xlsx | |||||||||
---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | |||
1 | Macrium Backup Restore | ü | üü | ||||||
2 | # | Action | Additional Info | ck | dn | ||||
3 | 1 | Roboform Before Restore | Insert any new data that was added after last Macrium Backup | ||||||
4 | 2 | Outlook Before Restore | Run Sync Back Free For Outlook | ||||||
5 | 3 | Outlook After Restore | Copy From E:\FromC-Outlook to >>> C:\Users\Dwight\AppData\Local\Microsoft\Outlook | ||||||
6 | 4 | Roboform After Restore | Add Back Into RoboForm Any New Data | ||||||
7 | 5 | Brave Browser History | Run BrowsingHistoryView.exe to get current date history, paste into appropriate sheet of the current month workbook. Delete Browser History, not including TODAY | 27/10/2022 | 14:33:15 | ||||
8 | 6 | Roboform Data Backup Information | RoboForm PrintList Settings: 1 Column, 70% for Logins & Safenotes, 60% for Identities; Margins: .25 Left&Right, .35 Top&Bottom | ||||||
9 | Computer\HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\15.0\Excel\Options | ||||||||
10 | How to Increase the Number of Jump List Items in Windows 10 | ||||||||
11 | PureText.exe | H:\Downloads\Downloads2\PureText\puretext_6.2_64-bit | 27/10/2022 | ||||||
12 | Pre Macrium Backup | 28/10/2022 | 14:33:15 | ||||||
13 | Action | Additional Info | |||||||
14 | 1 | Disk Cleanup | Windows 10 Update Wastes 20GB: How to Get It Back | ü | dn | 28/10/2022 | |||
15 | 2 | Run sfc /scannow | sfc-scannow-Images | ü | ck | 27/10/2022 | |||
16 | 3 | Belarc Advisor | Run Belarc to get Current System Status - Save to H:\Downloads\BelArc-Adviser\Belarc Advisor Reports | ||||||
17 | 4 | calibre 64bit - E-book manager | Check for calibre 64bit - E-book management new version | ||||||
18 | 5 | WiseCare | Run WiseCare: Prior to running WiseCare close all Excel Workbooks, Web Browser, Outlook etcetera so that the only program running is WiseCare | ||||||
19 | 6 | BrowsingHistoryView.exe | Run BrowsingHistoryView.exe to get current date history, paste into appropriate sheet of the current month workbook. Delete Browser History, not including TODAY | ||||||
20 | 7 | Sync Back Free | Run Sync Back Free: Excel Files, If Needed and Outlook | ||||||
21 | Copy current ost & pst files from C:\Users\Dwight\AppData\Local\Microsoft\Outlook via Sync Back Free | ||||||||
22 | 8 | Agent Ransack | Run Agent Ransack to get all wbk files moved to M:\WordBackupDocs | ||||||
23 | 9 | RoboForm | Get any RoboForm data that needs entered here in Sheet RestoreActions2 | ||||||
24 | Run the PrintList Option in RoboForm as PDF - Save to a Current Date Folder in H:\Downloads\Roboform\PrintLists | ||||||||
25 | GoTo RoboForm Options > Account & Data > Export to Create a CSV file for Login Data; Save to Current Date Folder in H:\Downloads\Roboform\Exports | ||||||||
26 | 10 | GoodSync | Run GoodSync Jobs But Do Not Run GoodSync for Macrium Backup from M Drive to N, O, & P Drives Until After Macrium Backup | ||||||
27 | 11 | Desktop | Using Snip & Sketch get current images of desktop | ||||||
28 | 12 | Brave Extensions | Get Image of Brave Extensions | ||||||
29 | 13 | Windows OS Updates | Check Window's Updates Per 3rd to 4th Week and How That Date Coordinates With the Next Macrium Backup; The Next Window's Updates are Scheduled for: November 24, 2022 | ü | ck | 24/11/2022 | |||
30 | 14 | Macrium Reflect | Run Macrium Reflect Backup: Change Advanced Options Per: Check Box for Auto Verify Image & Uncheck Box for BackupSet File Name Prefix; Format Rescue Disk & Run a New Build on the Rescue Disk | 24/11/2022 | |||||
31 | 15 | GoodSync | Run GoodSync for Macrium Backup from M Drive to N, O, & P Drives | 24/11/2022 | |||||
32 | Post Macrium Backup | ||||||||
33 | 1 | Microsoft Office | REPAIR Microsoft Office - This Requires All Micosoft Office Programs To Be Closed | ü | ck | 28/10/2022 | |||
34 | |||||||||
35 | |||||||||
36 | November 24, 2022 | ||||||||
MacriumSimpleSteps |
Cell Formulas | ||
---|---|---|
Range | Formula | |
F7 | F7 | =TODAY() |
G7,G12 | G7 | =NOW() |
D8 | D8 | =MacriumBackupActions!B10 |
D16 | D16 | =MacriumBackupActions!B12 |
D20 | D20 | =MacriumBackupActions!$B$4 |
D21,D25 | D21 | =MacriumBackupActions!B7 |
D22:D23 | D22 | =MacriumBackupActions!B5 |
D24 | D24 | =MacriumBackupActions!B9 |
D26 | D26 | ="Run GoodSync Jobs But Do Not "&D31&" Until After Macrium Backup" |
D27 | D27 | =MacriumBackupActions!B8 |
D29 | D29 | ="Check Window's Updates Per 3rd to 4th Week and How That Date Coordinates With the Next Macrium Backup; The Next Window's Updates are Scheduled for: "&$F$36 |
E14:E15 | E14 | =IF(OR($F14=$F$2,$F14=$G$2),$F$1,$G$1) |
E26:E33,E22:E23,E16:E20 | E16 | =IF($F16=$F$2,$F$1,"") |
D33 | D33 | =MacriumBackupActions!B25 |
G14 | G14 | =IF(AND($F14=$F$2,$F14=$G$2),$F$11,$F$12) |
G15 | G15 | =IF(OR($F15=$F$2,$F15=$G$2),$F$11,$F$12) |
G30:G33,G26:G28,G22:G23,G16:G20 | G16 | =IF($F16=$F$2,$F$12,"") |
G29 | G29 | =IF($F29=$F$2,$H$30,"") |
F36 | F36 | =TEXT($H$31,"mmmm dd, yyyy") |
Last edited: