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" )