Hi @justin_charles,
Provided your new Projects always have a custom form, I suggest you add a new calculated parameter to that (those) form(s) called Created Using Template, save the form, then set the formula to:
IF(ISBLANK({DE:Created Using Template}),IF(ISBLANK({templateID},”No”,”Yes”),{DE:Created Using Template})
Going foreward, upon creation such Template-created Projects will be “Yes”, and otherwise will be “No”.
Historic data might need some additional logic, too (eg “for Projects whose Entry Date is prior to the date you implement this approach, set it to Maybe”).
Fun one: good luck!
Regards,
Doug
Learn more at www.atappstore.com, email doug.denhoed@atappstore.com, or tag me here @Doug_Den_Hoed_AtAppStore.