I have dashboards with multiple sections each with has a different “go live” weeks that associate back to a start date. I am looking for a way to have a start date and then automate that when x date is changed y column adjusts to x - 18 weeks (example)n
Hi Gina,
You can do that with the Advanced Formula Booster. It is a 3rd-party app that allows you to create formulas that cast their results to any type of column.
In this case, you would write the following formula:
Then you would simply add the following automation:
