Best Of

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

1 ·

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

1 ·

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.

Raven A. Eggleston

1 ·

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

1 ·

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

1 ·

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

1 ·

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

1 ·

Re: Calculating Avg Workdays w/ Conditions

Make sure each of the range references have the same number of cells in them.

L_123

1 ·

Re: Report - Recent Changes

Thank you. I can get by with utilizing the intro information contained to the row. However, if it is something that could be worked on, I would find it helpful if that primary column was its own column to aid in sorting and working with the Excel file of the log.