Sign in to join the conversation:
I am new to Smartsheet and having problems setting up multiple approvals. I need to have: Approved, Approved - Needs More Info, Not Approved. I am struggling to get the Approved - Needs More Info be an option
Unfortunately as far as I'm aware you can only have the two options of Approved or Denied when setting up a Request and Approval Workflow. If you are looking to have a third option you may want to consider creating a Request an Update Workflow instead.
- Create a column titled "[Your Department/Person approving] Approval" as a single select dropdown option and add the three choices.
- Create the Request an update Workflow and title it accordingly. Customize the message to something along the lines of "Approval for {{Column Name}}" (hint adding the {{}} and putting in a column name actually sends the information in that row in the alert). Click the menu on the top right of the Request and Update and select "Advanced Options". Select only the information you wish them to see.
That's it for the basics. If you want to you can add locking rows if approved, alerts when not approved, etc.
I built one out so you could see
Instead of using an Approval Automation, set the column as a dropdown type, enter your options, then have an Update request sent out instead.
Hi,
Welcome to the Community and the wonderful world of Smartsheet!
I agree with Paul, and the update request is probably the simplest solution.
I hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hey, I am using the below formula→ =INDEX({Source_Sheet_Entire_Table}, MATCH([Unique ID]@row , {Source_Sheet_ID_Column}, 0), 1) Although the answer should be "Project details" mentioned in Column 1, it says #No Match. What am I doing wrong?
How can I delete old sheets I no longer use from my account?
I'm trying to display a task progress chart showing "complete", "late", and "not complete" in my dashboard and for some reason the chart will display as a column chart but it won't display as a donut chart even though I'm referencing the same report. I'd prefer to display as a donut chart as I think it looks better and is…