Plan sheet error on Approval notify

Hi VDMT​ ,

Looking at your screenshots, the All row has no email in the Budget Prepare-Txt column, but "Allow entry on Totals/Subtotals" is ticked on Task Status. If Submitted gets set on the All row, NOTIFY_USER has nobody to send to, which could explain the generic error.

Two quick tests. First, change Submitted only on the Digital row and see if the error still appears. Second, try wrapping the formula so it skips blanks, something like IF(AND(THIS == 'Submitted', [Budget Prepare-Txt] <> ""), NOTIFY_USER([Budget Prepare-Txt]), ""), depending on what functions the sheet supports. Unticking totals entry for that column is also worth a try if you only want approvals at the cost centre level.

If it still fails on the Digital row alone, make sure that email belongs to a user in your tenant and try it on a paid capacity if you can, since notifications may be limited on trials. Also click Copy to clipboard on the error and include it if you raise a ticket. The details there should be more useful than the popup.