Q. How do the 'Working Day' shortcuts work?
A. They use whichever the currently selected holiday calendar is. So for 'Next Working Day', if the next non-weekend day is a holiday according to the current calendar, it will try the following weekday until a non holiday is found.
Q. Can we apply shortcuts on text (string) columns?
A. No, Shortcuts only work for numeric or date columns.
Q. What is the difference between shortcuts for numeric and for date columns?
A. Numeric shortcuts perform a calculation based on existing values in the cell (e.g. if you have an 'M' for 1,000,000 shortcut typing 5M will render 5,000,000). Date shortcuts replace the existing date in the cell with the replacement value of the shortcut.