NOTIFYIFS
Description
Sends up to 1,000 notifications if values in the specified criteria change to meet multiple
conditions. You can send a notification to a user whether or not they have access to the
workbook. If the function exceeds the limit, notifications stop and the #ERROR indicator
displays in the cell containing the function. When you hover the cursor over the cell, a
message describes the error.
Syntax
NOTIFYIFS(
range1
,
criteria1
, [
user_names
], [
subject
], [
message
], [
send_on_each
], [
range2
,
criteria2
], ...)
- range1: A range to evaluate the criteria for.
- criteria1: The string expression to evaluate against the range. The format is the same as functions such as SUMIF() and COUNTIF().
- user_names: The array or list of users to send the notification to. If you don't include this argument, the function uses the user_name of the current user (the user composing the function).
- subject: The text string to use as the subject of the Workday notification. If you include a subject, Workday adds a colon character at the end of the string.
- message: The text to use as the body of the notification. These HTML tags are supported: <br>, <b>, <i>, and <u>.
- send_on_each: If TRUE, a notification is sent on each value in the range that matches the criterion (TRUE). If FALSE, the notification is sent only if all the values in the range meet the criterion. The default is TRUE.
- range2: A range to evaluate the criteria for.
- criteria2: The string expression to evaluate against the range.
Example
A1:B3 contains:
1 2
1 2
1 2
Formula | Result |
|---|---|
=NOTIFYIFS(A1:A3,1,,,,false,B1:B3,2) | TRUE |
Notes
- The function sends a notification only if a valuechangesto meet a condition. If, for example, a live data refresh occurs and a condition that was previously TRUE (notification was sent) remains TRUE when the schedule runs, no notification is sent. However, a notification is sent if you recalculate the workbook because this is the equivalent of re-submitting the formula from the cell.
- This function evaluates a criterion expression against all the values in the range you specified. Ifsend_on_eachis true, then the function sends a notification for each criterion match in the range. Ifsend_on_eachis false, the function sends a notification only if all values in the match meet the criterion. The form of the criterion is the same as in SUMIFS() and COUNTIFS().
- The difference between NOTIFYIFS() and NOTIFYIF() is that in NOTIFYIFS(), the condition for sending a notification is met only if every criterion is met against its corresponding range. You can specify any number of range/criterion pairs; you must specify them as matching pairs. In addition, the shape of each range must match the shape of the first range (they must all have the same number of rows and columns). Example: If we have three range/criterion pairs, then a condition is met if the criterion for each range is met for a specific cell in the range. Ifsend_on_eachis false, then the condition must be met for every cell in every range in order for the function to send a notification.
- The function generates a Workday notification. If emails are enabled in your environment, an email is also sent, but the email subject is auto-generated and doesn't match the subject argument of the notification.
- Workday identifies the sender of the notification as the user who placed the formula into the cell.
- The function returns the value TRUE if it sent a notification or FALSE if it didn't.
Related Functions
NOTIFYIF