Welcome!

Weekly update requests

Hi all ,

I am coordinating a project portfolio with many projects assigned to colleagues .

I have set a formula in a column wich takes the value of a " yellow ball " when a project is ongoing . And I want an update request to be sent automatically every THURSDAY so that , the colleague to whom the project is assigned can fill the status column .

Can you help me ?

Find more posts tagged with

Comments

L_123

When you hover your mouse on a row, the row turns dark, and there is a black rectangle on the far left of the row.

Right click that rectangle and you will see a series of options come up. One of them is send update request. Click that, and you will have a popup.

One of the options is Delivery. Select the edit button next to that and you can choose what options you want.

Andrée Starå

Hi Alain,

Do you only want the Update Request to send after it becomes yellow?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

ALAIN-STEPHANE

Thanks .

But I have about 150 tasks (projects ) to deal with , then I want to manage this automatically by means of alert and actions options .

Do you know what I mean ?

ALAIN-STEPHANE

Hi ANDREE ,

I tried to connect with you unsuccessuffly sooner .

Yes I want update request been launched every thursday after the ball turns " yellow " , so that the task ( project ) manager can fill information , until it turns " green" when the task is completed .

Do you know what I mean ?

Andrée Starå

That's what I thought, and I do!

Talk soon!

Best,

Andrée

L_123

Is the sheet opened on a regular basis? Can you expect that the sheet will be opened at least once on thursday? If so you can build a helper column to send the notifications.

=if(and(weekday(today()) = 5, [Project Completion] <> "Complete"),1,0)

Then send a notification based off the helper column to the contact column using the sheet level update request. The sheet wont update the column if it isn't opened as smartsheet likes to conserve their resources. There are ways around this, but none are really very clean.

Sign in to join the conversation!

Quick Links

Trending discussions

Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
Countifs formula to count based on two columns
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
Is there an issue with using reports on a dashboard to create a graph?
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…