When I set up a workflow there’s always an option between standard and formula but what is the difference?
Best answer by Evan from Copper
View original
What is the difference between Standard and Formula?
Userlevel 3
This topic has been closed for comments
Userlevel 3
+3
“Standard” means the value will be the exact same every time. “Formula” lets you add an equation or variable.
Here’s an example for a workflow automation that creates a Task with a Due Date.
- Standard: if you use Standard, the Due Date will be the same every single time. So if I enter 10/10/2021 as the Due Date, every single Task that gets created will be due on October 10 2021.
- Formula: if you use Formula, you can set the Due Date based on the day the Task is created. So if my workflow automation creates a Task on April 22 2021, the Due Date will also be April 22 2021. To do this, use the formula CURRENDATE(). To set the Due Date to 10 days later, use the formula DATEADD(CURRENTDATE(),10). I’ve attached a screenshot below.
A list of formulas is available here. You can also use custom fields in your formulas.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.