Can formulas be nested?
Yes. DSP fully supports nesting, allowing one formula to be used inside another.
Example:
IF( AND( CONTAINS_IGNORE_CASE(Status, "open"), DAYS_BETWEEN(TODAY(), TO_DATE(ClosedDate)) <= 7 ), "Closing Soon", "Standard" )
Yes. DSP fully supports nesting, allowing one formula to be used inside another.
Example:
IF( AND( CONTAINS_IGNORE_CASE(Status, "open"), DAYS_BETWEEN(TODAY(), TO_DATE(ClosedDate)) <= 7 ), "Closing Soon", "Standard" )