NOTIFYIF
Description
Sends up to 1,000 notifications if a value in the specified criterion changes to meet a
condition. 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
NOTIFYIF(
range
,
criteria
, [
user_names
], [
subject
], [
message
], [
send_on_each
])
- range: The range to evaluate the criteria for.
- criteria: 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 (inbox) 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, the function sends a notification on each value in the range that matches the criterion (TRUE). If FALSE, the function sends a notification only if all the values in the range meet the criterion. The default is TRUE.
Example
Formula | Result |
|---|---|
=NOTIFYIF(A1:A3,"=won","dave.smith","Contest results","you won!" ) |
Send this notification to dave.smith:
"Contest results: You won!" won
.
|
=NOTIFYIF(E8,"<"&E7,"tserrano","Forecast Drop",CONCAT(A8, " of
$",E8," has fallen below target of $", E7)) | Send a notification to tserrano if the value in E8 is less than E7. This
example uses data in the sample workbook on Community. Example
notification: "Forecast Drop: EMEA Forecast of $3214321 has fallen below target of
$3530400" |
=NOTIFYIF(A1,">"&0.5,"tserrano","Sales Goal",TEXT(A1,"0%")&" of
your employees met their sales goal.") | Send a notification to tserrano if the value in A1 is greater than 0.5.
The TEXT function causes the A1 value to be formatted as an integer
percentage. Example notification: "Sales Goal: 61% of your employees met their sales goal.") |
Example Notifications Using an Array of Values
Here's an example of how to use NOTIFYIF with an array of values.
The formula in cell A8 puts the different users listed in A3, A4 and A5 into an array:
When including the reference cell in the NOTIFYIF formula, use ARRAYAREA(A8):
Remember to submit the formula using the array keyboard shortcut: Ctrl+Alt+Enter (Windows)
or Command+Option+Enter (Mac).
The inbox notification for the formula looks similar to this, if Oliver Reynolds submitted
the formula:
The email notification looks similar to this:
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.
- Theuser_namesformat in your tenant might vary from the examples.
- 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 for SUMIF() and COUNTIF().
- 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.
- This function returns the value TRUE if it sent a notification or FALSE if it didn't.
Related Functions
NOTIFYIFS