I am trying to create a button to make calls and mail using URL "mailto:firstname.lastname@example.org" but I am not able to use that. Can you suggest me something? The email address and phone number are stored in different columns.
Hi there! I understand your concerns and will do my best to help you with your formula. Let's tackle the first problem first:
You want the 'Dato for udbetaling' to show the date of the first Wednesday after the 10th of the month when 'Betalingsmetode' is 'PBS' and the date in 'Trækdato (FarPay)' is before the 10th of the month.
To fix this, you can update the existing formula to check if the current date is before the 10th and adjust the target date accordingly. Here's the updated formula: