I am trying to create a report that at 4pm sends me a text message for a task marked “Urgent” that is not complete.
On the bottom where it asks you to list the telephone number I do not want static information. I want to populate the telephone number of the user that task belongs to. However I have this message to contend with.
"This formula is not evaluated in the context of a row, so column values are not available."
Is there a way to pull the telephone data from my USERS table that has a column with the telephone numbers in it?
User | Count |
---|---|
42 | |
30 | |
25 | |
23 | |
13 |