This will display the Last Edited rollup date/times that is CLOSEST TO NOW from the other (2) Last Edited rollup dates/times.

This formula is for 3 rolled up dates! If you want more, you will need to figure out all possibilities to be added to the formula. (The more columns there are, the greater number of possibilities, so much bigger formula) If you need least, you will need the possibilities for just two. If you need just one, Look at this table here for an individual formula, under the table example.

Relative Time with Dates Rollups

(not empty(prop("⤴ Last Edited 🟣")) and not empty(prop("⤴ Last Edited 📆")) and not empty(prop("⤴ Last Edited 🟡"))) ? ((prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 🟡")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : ""))))) : ((prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 🟡")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : ""))))) : ((prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 🟡")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : ""))))) : ((prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 🟡")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : ""))))) : ((prop("⤴ Last Edited 🟣") < prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 📆") == prop("⤴ Last Edited 🟡")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : ""))))) : ((prop("⤴ Last Edited 🟣") < prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 📆") > prop("⤴ Last Edited 🟡")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : ""))))) : ((prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 🟡")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : ""))))) : ((prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") < prop("⤴ Last Edited 🟡")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) + " days ago") : ""))))) : ((prop("⤴ Last Edited 🟡") > prop("⤴ Last Edited 🟣") and prop("⤴ Last Edited 🟡") > prop("⤴ Last Edited 📆")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) + " days ago") : ""))))) : ""))))))))) : ((not empty(prop("⤴ Last Edited 🟣")) and empty(prop("⤴ Last Edited 📆")) and empty(prop("⤴ Last Edited 🟡"))) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : ""))))) : ((empty(prop("⤴ Last Edited 🟣")) and not empty(prop("⤴ Last Edited 📆")) and empty(prop("⤴ Last Edited 🟡"))) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : ""))))) : ((empty(prop("⤴ Last Edited 🟣")) and empty(prop("⤴ Last Edited 📆")) and not empty(prop("⤴ Last Edited 🟡"))) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) + " days ago") : ""))))) : ((not empty(prop("⤴ Last Edited 🟣")) and empty(prop("⤴ Last Edited 📆")) and not empty(prop("⤴ Last Edited 🟡"))) ? ((prop("⤴ Last Edited 🟣") >= prop("⤴ Last Edited 🟡")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : ""))))) : ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) + " days ago") : "")))))) : ((not empty(prop("⤴ Last Edited 🟣")) and not empty(prop("⤴ Last Edited 📆")) and empty(prop("⤴ Last Edited 🟡"))) ? ((prop("⤴ Last Edited 🟣") >= prop("⤴ Last Edited 📆")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + "  hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : ""))))) : ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : "")))))) : ((empty(prop("⤴ Last Edited 🟣")) and not empty(prop("⤴ Last Edited 📆")) and not empty(prop("⤴ Last Edited 🟡"))) ? ((prop("⤴ Last Edited 📆") >= prop("⤴ Last Edited 🟡")) ? ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : ""))))) : ("Last Actioned: " + ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "seconds")) < 60) ? "few seconds ago" : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) < 60) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) < 24) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) >= 1) ? (format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) + " days ago") : "")))))) : ""))))))