I am building a task list where the same daily tasks are completed each day, so I have a list with around 20 tasks or so, with links and the time they should be completed etc. However, there are a couple of tasks, such as client briefings, that only occur on specific days of the week - is it possible to get it so that these tasks only show on the day of the briefing in my interface, not everyday?
Page 1 / 1
Hmm, try:
1. Create a field that indicates which day of the week this task is supposed to be completed on
2. Create a formula field that will check whether today's the same day, and if it is, output the text "Display"
3. Use this formula field in the Interface filter
IF(
DATETIME_FORMAT(
TODAY(),
'dddd'
) = {Day to complete},
'Display'
)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.