Forum Discussion
QuickBaseCoachD
7 years agoQrew Captain
No problem.
Make a summary count field of the # of Permits.
Make a summary count field of the # of Approved Permits.
Then make a formula text field
IF(
[# of Permits]=0, "No Permits",
[# of Permits] = [# Approved Permits], "All Approved",
totext([# Approved Permits]) & " of " totext([# of Permits]) & " Approved"))
Make a summary count field of the # of Permits.
Make a summary count field of the # of Approved Permits.
Then make a formula text field
IF(
[# of Permits]=0, "No Permits",
[# of Permits] = [# Approved Permits], "All Approved",
totext([# Approved Permits]) & " of " totext([# of Permits]) & " Approved"))