Is there a formula for referencing a different cell daily?

Claudia

I've automated emails to send out schedules to our field employees but their sites can change daily and I was wondering if there's a way to reference a different cell everyday so I don't have to manually change the site cell in the automated workflow.

Andrée Starå

Hi @Claudia

I hope you're well and safe!

Not sure I follow.

Could you use the placeholder feature and reference a specific column?

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Claudia

Hi @Andrée Starå, thanks for your response! Let me provide a little more background and you might have a better solution than what I'm working on.

We send our field employees their schedules daily so I've set up a workflow to send the messages to them after their schedule is updated but right now I'm manually inputting their site on the workflow spreadsheet so it can send them their site for the following day.

We have a separate schedule sheet for each week so ideally i'd like to find a way to reference a different cell daily for the workflow so I don't have to update the site cell every day.

Does that make more sense?

Andrée Starå

@Claudia

Happy to help!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

Claudia

Hi @Andrée Starå

The pictures are of the workflow, the sheet I have set up to send the emails out when the schedule is finalized and the schedule sheet.

I'm trying to find a way to update the schedule sheet and have it automatically fill the workflow sheet with the following days job site.