Cell links not working when sheet is closed

Dina K.

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:

James Keuning

Create a column called TODAY. Then create a "record a date" automation and set it up so it runs before the problematic automation. When that first automation runs, it should trigger Smartsheet to refresh the row, and the forumlas in the row, and that should update those site name cell references without your intervention.