This will display the last edited rollup date/times that is GREATER THAN or EQUAL TO from the other last edited rollup dates/times and the closest to NOW.
Relative Time with Dates Rollups
∑ for Last Edited 🟣
prop("⤴ Last Edited 🟣") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? ("🟣 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : "")))) : ""
∑ for Last Edited 📆
prop("⤴ Last Edited 📆") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? ("📆 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : "")))) : ""
∑ for Last Edited 🟡
prop("⤴ Last Edited 🟡") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "seconds")) < 60) ? ("🟡 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) < 60) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) < 24) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) >= 1) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) + " days ago") : "")))) : ""
∑ for the Closest Last Edited 🟣📆🟡
(prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 🟡")) ? (prop("Last Edited 🟣 (delete if using ALL in ONE 👀)") + "\\n" + prop("Last Edited 📆 (delete if using ALL in ONE 👀)") + "\\n" + prop("Last Edited 🟡 (delete if using ALL in ONE 👀)")) : ((prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 🟡")) ? (prop("Last Edited 🟣 (delete if using ALL in ONE 👀)") + "\\n" + prop("Last Edited 📆 (delete if using ALL in ONE 👀)")) : ((prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 🟡")) ? prop("Last Edited 🟣 (delete if using ALL in ONE 👀)") : ((prop("⤴ Last Edited 🟣") < prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 📆") == prop("⤴ Last Edited 🟡")) ? (prop("Last Edited 📆 (delete if using ALL in ONE 👀)") + "\\n" + prop("Last Edited 🟡 (delete if using ALL in ONE 👀)")) : ((prop("⤴ Last Edited 🟣") < prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 📆") > prop("⤴ Last Edited 🟡")) ? prop("Last Edited 📆 (delete if using ALL in ONE 👀)") : ((prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 🟡") and prop("⤴ Last Edited 🟡") > prop("⤴ Last Edited 📆")) ? (prop("Last Edited 🟣 (delete if using ALL in ONE 👀)") + "\\n" + prop("Last Edited 🟡 (delete if using ALL in ONE 👀)")) : ((prop("⤴ Last Edited 🟣") < prop("⤴ Last Edited 🟡") and prop("⤴ Last Edited 🟡") > prop("⤴ Last Edited 📆")) ? prop("Last Edited 🟡 (delete if using ALL in ONE 👀)") : ""))))))
∑ for ALL in ONE 👀
(prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 🟡")) ? ((prop("⤴ Last Edited 🟣") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? ("🟣 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : "")))) : "") + "\\n" + (prop("⤴ Last Edited 📆") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? ("📆 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : "")))) : "") + "\\n" + (prop("⤴ Last Edited 🟡") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "seconds")) < 60) ? ("🟡 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) < 60) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) < 24) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) >= 1) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) + " days ago") : "")))) : "")) : ((prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 🟡")) ? ((prop("⤴ Last Edited 🟣") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? ("🟣 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : "")))) : "") + "\\n" + (prop("⤴ Last Edited 📆") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? ("📆 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : "")))) : "")) : ((prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 🟣") > prop("⤴ Last Edited 🟡")) ? (prop("⤴ Last Edited 🟣") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? ("🟣 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : "")))) : "") : ((prop("⤴ Last Edited 🟣") < prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 📆") == prop("⤴ Last Edited 🟡")) ? ((prop("⤴ Last Edited 📆") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? ("📆 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : "")))) : "") + "\\n" + (prop("⤴ Last Edited 🟡") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "seconds")) < 60) ? ("🟡 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) < 60) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) < 24) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) >= 1) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) + " days ago") : "")))) : "")) : ((prop("⤴ Last Edited 🟣") < prop("⤴ Last Edited 📆") and prop("⤴ Last Edited 📆") > prop("⤴ Last Edited 🟡")) ? (prop("⤴ Last Edited 📆") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "seconds")) < 60) ? ("📆 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) < 60) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) < 24) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) >= 1) ? ("📆 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 📆")), "days")) + " days ago") : "")))) : "") : ((prop("⤴ Last Edited 🟣") == prop("⤴ Last Edited 🟡") and prop("⤴ Last Edited 🟡") > prop("⤴ Last Edited 📆")) ? ((prop("⤴ Last Edited 🟣") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "seconds")) < 60) ? ("🟣 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) < 60) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) < 24) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) >= 1) ? ("🟣 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟣")), "days")) + " days ago") : "")))) : "") + "\\n" + (prop("⤴ Last Edited 🟡") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "seconds")) < 60) ? ("🟡 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) < 60) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) < 24) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) >= 1) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) + " days ago") : "")))) : "")) : ((prop("⤴ Last Edited 🟣") < prop("⤴ Last Edited 🟡") and prop("⤴ Last Edited 🟡") > prop("⤴ Last Edited 📆")) ? (prop("⤴ Last Edited 🟡") ? ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "seconds")) < 60) ? ("🟡 Last Actioned: " + " few seconds ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) < 60) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "minutes")) + " minutes ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) < 24) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "hours")) + " hours ago") : ((ceil(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) >= 1) ? ("🟡 Last Actioned: " + format(dateBetween(now(), end(prop("⤴ Last Edited 🟡")), "days")) + " days ago") : "")))) : "") : ""))))))