Shawn Miller
New Member
Hello,
I am looking for advice. Attached is a file that has many different deadlines for states in the US regarding tax due dates. I also have a second tab with a slightly different visual but still not good.
I am trying to think of a way to visually depict our deadlines and use this as sort of a tracker. I am think we could add some variables and a user could open it and enter today's date (or populate with TODAY()) and another field where you dictate number of days out (for example, 10). Then the file would return what is due in the next 10 days. We could even have a helper column where you check off what is done so the returns only show not completed.
My struggle is thinking of a good idea to do this and reproducing it each year (see the deadlines may be listed as 3/15 so each year I would have to produce a year or add year to each of the deadlines.) Also struggling with ideas to set this up.
If anyone has creative ideas or has similar examples they could share I would appreciate it!
Thanks,
Shawn
I am looking for advice. Attached is a file that has many different deadlines for states in the US regarding tax due dates. I also have a second tab with a slightly different visual but still not good.
I am trying to think of a way to visually depict our deadlines and use this as sort of a tracker. I am think we could add some variables and a user could open it and enter today's date (or populate with TODAY()) and another field where you dictate number of days out (for example, 10). Then the file would return what is due in the next 10 days. We could even have a helper column where you check off what is done so the returns only show not completed.
My struggle is thinking of a good idea to do this and reproducing it each year (see the deadlines may be listed as 3/15 so each year I would have to produce a year or add year to each of the deadlines.) Also struggling with ideas to set this up.
If anyone has creative ideas or has similar examples they could share I would appreciate it!
Thanks,
Shawn