Question
SmartList filter based on math formula
How it is possible to define a Smart List filter based on math formula?
Let me introduce an example.
I have a Salesforce accounts and each of them should receive email-report each 7 days.
I create a Campaign which will run on daily basis. Then in the Smart List tab I need to create a special filter which will calculate and choose only those accounts which should receive a report today. Unfortunately, we do not have something like "last report date". We have only when_account_created date. Which means, formula should contain something like "remainder of division ((currect_date-when_created)/7)=0".
How it is possible to defined such a filter?
I have stuck with the custom formula. It doesn't appear as incorrect but meantime it doesn't show in "Smart List -> Filters".
The only possible way the formula field accepted my formula was:
if "When.Created" is "({{system.Date}}-7)or({{system.Date}}-14)or({{system.Date}}-28)or({{system.Date}}-35)or{{system.Date}}-42)or{{system.Date}}-49)or({{system.Date}}-56)" value true.
I would like to use {{system.Date}} or {{system.DateTime}} on the left hand side of the formula. Thus, it would be interpreted more easier:
if ({{system.Date}} - {{company.When.Created}}) in (7,14, ..., 56).
Anyway I can't find formula field which can make it possible. Maybe you have some idea(s)?
Let me introduce an example.
I have a Salesforce accounts and each of them should receive email-report each 7 days.
I create a Campaign which will run on daily basis. Then in the Smart List tab I need to create a special filter which will calculate and choose only those accounts which should receive a report today. Unfortunately, we do not have something like "last report date". We have only when_account_created date. Which means, formula should contain something like "remainder of division ((currect_date-when_created)/7)=0".
How it is possible to defined such a filter?
I have stuck with the custom formula. It doesn't appear as incorrect but meantime it doesn't show in "Smart List -> Filters".
The only possible way the formula field accepted my formula was:
if "When.Created" is "({{system.Date}}-7)or({{system.Date}}-14)or({{system.Date}}-28)or({{system.Date}}-35)or{{system.Date}}-42)or{{system.Date}}-49)or({{system.Date}}-56)" value true.
I would like to use {{system.Date}} or {{system.DateTime}} on the left hand side of the formula. Thus, it would be interpreted more easier:
if ({{system.Date}} - {{company.When.Created}}) in (7,14, ..., 56).
Anyway I can't find formula field which can make it possible. Maybe you have some idea(s)?