Warning
All
ByName
C:\Users\jmurray8\Desktop\Overdue Tracker test\Example\Consolidated Jobs.xlsx|||Sheet1
Overwrite
Consolidated Jobs.xlsx
Table=Sheet1
Comparing with current Job tracker
Request reference in both Consolidating tracker and in individual (Existing)
Populating fields using latest information (from the individual trackers)
C:\Users\gene\AppData\Local\Temp\Engine_6440_c2cd70ff9b1f4226b0e11c9cf2657d6a_\Engine_3324_ec8e9ad47a5f46409a555f5a6dacd65b_.yxdb
Single
Profile
Warning
All
ByName
C:\Users\gene\Downloads\Consolidated Jobs.xlsx|`Sheet1$`
False
Consolidated Jobs.xlsx
Table=`Sheet1$`
C:\Users\gene\AppData\Local\Temp\Engine_6440_c2cd70ff9b1f4226b0e11c9cf2657d6a_\Engine_3324_cf7e0a2beeca4f11826a04a7cdb211a8_.yxdb
Creating status
Simple
Deadline Date
IsNotNull
!IsNull([Deadline Date])
Checking to see if date field is populated
Calculating the amount of days between the agreed date and today
Warning
All
ByName
Status = IF [DaysUntilOverdue] > 0 THEN "Overdue"
Elseif [DaysUntilOverdue] <= ...
Request ref in DCRO tracker but not Individual trackers (Now complete)
Status=If [Job] = Null() Then ""
Else "Complete"
Endif
Changing the status to "Complete"
tempdate=DateTimeToday()
Importing Individual Trackers
Importing individual trackers
Simple
Job
IsNull
IsNull([Job])
FileName
Last
Name
C:\Users\gene\Downloads\Bob Jobs.xlsx|`Sheet1$`
False
Bob Jobs.xlsx
Table=`Sheet1$`
C:\Users\gene\Downloads\John Jobs.xlsx|`Sheet1$`
False
John Jobs.xlsx
Table=`Sheet1$`
Warning
All
ByName
Horizontal
ExampleJobWorkflow efc