Column based alert?

I have a workflow where I need to add a different site every couple days, as we confirm site visit. I want to send alert to the team ( about 40 people) to update and provide their availability to go to these sites. I only know of Alerts being row based in Smartsheet. Is there a way better way to approach this work flow? Please advise.

Thank you

Site visit alert.PNG

Find more posts tagged with

Comments

Andrée Starå

Hi Sami,

Do you want to alert them to start the tasks or that the tasks are complete or something else?

Can you describe your process in more detail? That would make it easier to help.

Hope that helps!

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

SamiV

Hello Andree', Thank you for replying! This alert is more of an update, asking them to provide their availability. Once a site is confirmed, out of 40 subject matter expert, we send 4-5 to the site, based on their availability.

Hope this helps.

Andrée Starå

Happy to help!

How many sites on a monthly/yearly basis? Do you need an update on the same site multiple times or only when it's confirmed and only once?

There are basically two ways to structure it in one sheet. Similar to the one you have now or to transpose it so the people are in the columns and the site is on the rows.

Make sense?

Depending on your answers, there might be another method/structure.

SamiV

Hello Andree', I thought about transposing column and rows, but since this team has been working with this structure for so long, I did not want to change what they are comfortable with. If there is an option to trigger alert through column, I would like to give it a shot. We will likely add 2- 3 columns per month.

I really appreciate you helping with this.

Thank you

Andrée Starå

I have an idea!

I'll get back to you when I've tested it.

SamiV

Hello, checking back to see if you have had successful testing. Thank you !

Andrée Starå

Yes, but it would require to either add columns that they need to provide feedback on or update the request when needed to only include the relevant columns.

Would that work?

SamiV

Yes, That is the workflow. Anytime a new site is confirmed, it gets added as a column. The resources then will have to update their availability to work on that site.

SamiV

But, when I add a column, is there an automation to trigger update?

Andrée Starå

I'd recommend that we add placeholder columns that you then can update with the correct name. We'd then use the first row to trigger the automation.

Would that work?

SamiV

Andre'e, Here is the screen shot of my sheet. I attempted setting up automation. screen shot added. I am not sure how to make this work.Any idea?

Thank your for your time!

Capture 1_0.PNG

Capture 2.PNG

Capture 3.PNG

Andrée Starå

Try something like this.

In the column Site Visit 1, add the formula below in all cells underneath row 1 where you want to ask for availability.

=$[Site Visit 1]$1

When you change the value in the column on row 1, it will change the value for all cells underneath, and that can then trigger the Update Request.

Make sense?

Would that work?

Andrée Starå

Example:

GIF

Sign in to join the conversation!

Quick Links

Trending discussions

Automated email with number of pending records
Hello, I use Smartsheet in such way that people are asked to provide data on many records and then that data needs to be approved by one other person (always the same person). I would like to set up an automation that, each morning, checks to see if there are records waiting to be approved, and if there are, sends an…
How to Share Single Workspace Folder?
I have a workspace that I created with two subfolders. A user needs to have access to only one of them but when I have that folder selected, I can only share the entire workspace with them. Is there a secret way that I can share the parent folder and ensure that any new files created will be shared with the same people? I…
License Question
I already have a Smartsheet license with my company, but I was recently invited to collaborate on a sheet owned by another group within the same organization. When I accepted, I was told I need to upgrade in order to edit or contribute. Can you please explain why this is required? It seems unreasonable to need multiple…