Hello everyone! This is my first community post!
I am creating a new column in Designer where I want to return a specific day of the week. What I want is to create an expression which will return the Tuesday prior to the date in another column. I started with an IF/THEN conditional statement but am kind of stuck now. The column I am building off of is the [Annual Refresh Date] but only if my [Driver] is "Annual Refresh Date". This is what I have so far:
If [Driver]="Annual Refresh"
THEN (this is where I need a formula for the Tuesday prior to the [Annual Refresh Date])
ELSE "N/A" ENDIF
Solved! Go to Solution.
Hi @CBotelho13
Here is how you can do it. I am considering if its Tuesday then same day is taken.
Workflow:
Hope this helps : )
Interesting take @gabrielvilella 🙂👍
thank you!
Hi @CBotelho13
Try @gabrielvilella it's much more optimized and also you are allowed to mark more than posts as solutions
Happy to help : )
Cheers and have a nice day!
Thanks for the tip! I have changed it up and also accepted his as a solution.