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.

Andrée Starå

Hi @Dina K.

I hope you're well and safe!

Please have a look at my post below, which includes a method I developed to update the sheet(s) daily.

More info: 

https://community.smartsheet.com/discussion/74527/daily-update-solution-without-the-need-to-open-the-sheet-use-zapier-or-similar

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Dina K.

Thank you James & Andrée, we did try this method and for some reason its still not waking the sheet to update the indexing until someone either opens the sheet or an update request comes in and updates it :(

Andrée Starå

@Dina K.

Happy to help!

Strange! It should work!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!