Hello, I need help solving this issue that is stumping me. To goal of the cross sheet reference formula is to highlight which employees are no longer with the company. There is logic in place that whe…
Hola, hola! Is it possible to perform a vlookup to search two two different sheets? Here is my scenario: I need to check for duplicate addresses using a formula in my base sheet. The Address Sheet tha…
Hello, I use helper columns in my compliance sheets that are used to trigger notifications when action is needed. Normally, as a best practice, those columns are hidden since they are not needed by th…
I have a workflow that is running hourly with the goal to batch the notifications rather than send a notification for each change. In this example below, the end user is receiving the same number of n…
Hello, I am working on solution with several hand offs. The owner of the business process is different from the group that kicks off the process using a form submission. I would like to provide an opt…
Hello, I need to trigger notifications based on workdays. If I create a helper column using the WORKDAY formula, what do I base the # of days on? Example: Notification to be triggered 3 days ahead of …
Hola, Need some help with an automation. I have notifications triggered based on status (Open, Manager Approval, Closed). There is a step that I need to trigger a notification when a status moves from…
Hello, I am receiving this notification, but I know for certain one user has access to other sheets, hence a profile. They are added to a contact list and shared to the dashboard which contains a dyna…
Hello, I would like to see up reminder notifications - this is one example - at different milestones. I have not really utilized "when date is reached" before. In the example above, if I set it to run…