Is there a formula for referencing a different cell daily?

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.

Answers

  • Andrée Starå
    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!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Claudia
    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å
    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, [email protected])

    SMARTSHEET EXPERT CONSULTANT & PARTNER

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

    W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • Claudia
    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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!