Cell links not working when sheet is closed

Dina K.
Dina K. ✭✭✭
edited 04/05/24 in Smartsheet Basics

I have multiple solutions that generate time/date-based workflows. When the reminders are sent out in the morning when a sheet is closed, the cell reference in the workflow message does not populate.

These have been in place for over a year and were working up until a couple weeks ago, no changes to the main reference sheet.

The workflows are time/date based.

Cell link is using an IFERROR/INDEX formula and cell is referenced in the workflow {Site Name}

Here is the column formula:

=IFERROR(INDEX({Pharmacy Site Information - Site Name}, MATCH([*SiteID TEXT]@row, {Pharmacy Site Information - Site #}, 0)), " ")

To avoid #NOMATCH error formula is using “ “

When I open the sheets prior to the workflows running, the field {Site Name} populates as expected.

Here is the workflow message: