Question

if(prop("Retention") == "<50%", dateAdd(prop("Last Revision"), 1, "days"), if(prop("Retention") == "70%", dateAdd( prop("Last Revision"), 7, "days", if prop("Retention") == "90%", dateAdd(prop(Last Revision), 14, "days"), dateAdd(prop("Last Revision "), 0, "days"))))

Answer 1

this line is missing a ')'

if(prop("Retention") == "70%", dateAdd( prop("Last Revision"), 7, "days", if

should be this:

if(prop("Retention") == "70%", dateAdd(prop("Last Revision"), 7, "days"), if