Formulas
Formula (time today @)
if(contains(prop("Scheduled For"), "Saturday") and day(now()) == 6 and prop("Done") == false, "🕑 " + replaceAll(replaceAll(replaceAll(replaceAll(prop("Scheduled For"), ".*Saturday ", ""), ", .*", ""), ".*, ", ""), "- ", ""), if(contains(prop("Scheduled For"), "Sunday") and day(now()) == 0 and prop("Done") == false, "🕑 " + replaceAll(replaceAll(replaceAll(replaceAll(prop("Scheduled For"), ".*Sunday ", ""), ", .*", ""), ".*, ", ""), "- ", ""), if(contains(prop("Scheduled For"), "Monday") and day(now()) == 1 and prop("Done") == false, "🕑 " + replaceAll(replaceAll(replaceAll(replaceAll(prop("Scheduled For"), ".*Monday ", ""), ", .*", ""), ".*, ", ""), "- ", ""), if(contains(prop("Scheduled For"), "Tuesday") and day(now()) == 2 and prop("Done") == false, "🕑 " + replaceAll(replaceAll(replaceAll(replaceAll(prop("Scheduled For"), ".*Tuesday ", ""), ", .*", ""), ".*, ", ""), "- ", ""), if(contains(prop("Scheduled For"), "Wednesday") and day(now()) == 3 and prop("Done") == false, "🕑 " + replaceAll(replaceAll(replaceAll(replaceAll(prop("Scheduled For"), ".*Wednesday ", ""), ", .*", ""), ".*, ", ""), "- ", ""), if(contains(prop("Scheduled For"), "Thursday") and day(now()) == 4 and prop("Done") == false, "🕑 " + replaceAll(replaceAll(replaceAll(replaceAll(prop("Scheduled For"), ".*Thursday ", ""), ", .*", ""), ".*, ", ""), "- ", ""), if(contains(prop("Scheduled For"), "Friday") and day(now()) == 5 and prop("Done") == false, "🕑 " + replaceAll(replaceAll(replaceAll(replaceAll(prop("Scheduled For"), ".*Friday ", ""), ", .*", ""), ".*, ", ""), "- ", ""), "")))))))
Formula (days)
if(contains(prop("Scheduled For"), "Monday"), "🗓 Monday\n", "") + if(contains(prop("Scheduled For"), "Tuesday"), "🗓 Tuesday\n", "") + if(contains(prop("Scheduled For"), "Wednesday"), "🗓 Wednesday\n", "") + if(contains(prop("Scheduled For"), "Thursday"), "🗓 Thursday\n", "") + if(contains(prop("Scheduled For"), "Friday"), "🗓 Friday\n", "") + if(contains(prop("Scheduled For"), "Saturday"), "🗓 Saturday\n", "") + if(contains(prop("Scheduled For"), "Sunday"), "🗓 Sunday\n", "")
Â