Hello! Need to replicate a formula being used within a Formula column, within General Caster instead. Grab the existing logic being used within the Formula column (works great!) and translate it to a General Caster formula to do the same.
What the formula does:
Calculates a new date subtracting WORKDAYS from a given date accounting for holidays
Why I need to convert it to General Caster:
To cast results to a Timeline or Date column so automations can be used (Formula column results are not actionable)
Formula vs General Caster Conversion that is not working:
Hello @JCorrell ! This is a formula I found on one of your YouTube videos and works exactly as intended! Just need help converting it to a General Caster version so I can cast the results to a Timeline/Date column so we can create automations on the results.
I do not know General Caster very well. As I understand it, it uses Excel type syntax. You might try using the Google to find an Excel version of the “Backward Workdays” formula.
Jim - The Monday Man
Update Magic #1 – New update enhancement toolbox
Column Magic – The magical columns toolbox
We Create Custom Integrations & Automations