Best Of
Re: Change Permissions for Specific Items in Workspace
@Andrée Starå Thank you for your reply.
Turns out we accomplished what we needed. We changed the Permission of the Workspace to Viewer and then added permissions of Editor to the items we wanted inside said folder. It was an easy proccess but took time as we had to add the sharing permissions to each item separately.
moraki
Copy column on one sheet to another column on another sheet (and update when new rows added)
Is there a way in Smartsheet to have Column A in sheet 1 automatically copied/linked over to Column A in sheet 2? We need consistent building names across 12 different sheets, but we want Sheet 1 to be the only place new building names are added. Is this possible?
swaldon2
Re: How can I configure the 'If Declined' section of the Approval process?
It allows you to create another trigger. Triggers are the start of the workflow, if there is a "pause" in the workflow, it won't iterate itself automatically.
It makes it easier if they are updating a single cell, as you can just use that as a trigger to start the next workflow. Maybe you might need to use a helper column and join() the potential modifiable cells into one then use that to trigger the next step
L_123
Re: How can I configure the 'If Declined' section of the Approval process?
Join() is concatenate() in excel. It puts the values from a range together into a single field. That way if they change any of the values, it updates the one cell, and you can look at that one cell in your automation to trigger your workflow.
L_123
Re: Need Help, Nested If Date formula
All you need is an IF formula that you would tweak for each month.
=IF(IFERROR(MONTH([EST SHIP DATE]@row), 0) = 1, [ROW TOTAL]@row)
The above would go in the January column. Changing the 1 to a 2 will update it for February. 3 would be for March, so on and so forth.
Paul Newcome
Modern PPM Webinar with Live Q&A!
📢 Calling all project management professionals! Are you ready to simplify your project and portfolio management to deliver results faster? Register for the newly released SmartStart Modern Project & Portfolio Management (Modern PPM) webinar with live Q&A!
Learn More & Register Here!
This webinar provides you with a demonstration of Modern PPM, best practices, and resources on how to:
- Easily utilize Smartsheet project management template sets
- Efficiently set up a scalable Modern PPM solution to manage your project portfolios
- Assess your organization’s PPM maturity using the Smartsheet PPM Maturity Assessment tool
This webinar is offered monthly. Register for an upcoming session!
🔎 Looking for more? Check out these additional webinars to support your Smartsheet journey.
Re: Can we create new custom user roles in Smartsheet?
owner, admin, editor, viewer or commenter are all sharing permissions specific to a Smartsheet item.
Paul Newcome
Re: Using more than symbol
Hi @ShaunW
Your range is good, but criterion is not quite right.
Try this:
=COUNTIFS({9.Countries or Regions Impacted}, @cell = "> One Country")
And by the way, because you only have one criteria you can use a countif instead of a countifs.
Hope that helps!
BRgds,
-Ray
Ray Lindstrom
Re: Adding Users to a Group
Melanie here's the format I used in a Bridge workflow to push a body. No \ escape on the " marks. You may not need the [] array brackets or the extra object {}, that was a requirement for this particular workflow (Google Address Validation)
{"address": {"addressLines": ["{{runtime.data.cells.5049890497318788.value||}}"]}}
I would maybe try the following formatting for yours and see if it works? Also did you already run this through Postman and ensure that the API is just working in general?
{"email":"{{states.startstate.smartsheet.get_row.row.cells.Email.value||}}"}
I always put || in my references so that it doesn't error and stop the entire workflow if email happens to be blank on a row.
One other idea - on a POST you have to put a header in for Content-Type with a value of application/json. Otherwise most APIs won't recognize your body at all.
The "Unexpected character \\" error is, I think, coming because it sees the \" that you have and thinks it needs to escape the escape, so Bridge adds another \ to the mix, then the API doesn't understand what it's supposed to do with \\" in the body.
Brian_Richardson
Re: Adding Users to a Group
You can also try leveraging the Form Parameters instead of the body, sometimes I find that is easier to use and works. So you'd have a Form Parameter called email with a Value of {{states.startstate.smartsheet.get_row.row.cells.Email.value||}}
Brian_Richardson