conditional lookup date field
I have a projects table with an items table as the child. The items table has an approval date field. I would like to set up a lookup field in the project log with the following conditions: 1. ...
Forum Discussion
You will need to make a summary field on the relationship to count the # of records where the date is blank, and another summary field on the relationship to count the # of records with dates.
you will also nee a summary maximum of the date field.
Then on the parent record
IF(
[# items] =0, "No Items",
[# items] = [#Items without dates], "Not Started",
[#Items without dates]=0, [Max date],
[# items] > [#Items without dates], "In Progress", "error - check formula!")
you will also nee a summary maximum of the date field.
Then on the parent record
IF(
[# items] =0, "No Items",
[# items] = [#Items without dates], "Not Started",
[#Items without dates]=0, [Max date],
[# items] > [#Items without dates], "In Progress", "error - check formula!")
