Best Of
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

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.

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||}}

Re: Calculating Avg Workdays w/ Conditions
Make sure each of the range references have the same number of cells in them.

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.
Re: How can I make an Second update request TRIGGER a workflow?
Yes, @Pascale
When APV Status is RQST2 DCL, the workflow will skip the First Approval Request and automatically jump to the second one.
In the workflow, the logic structure is;
Where APV Status is not one of REQSTQ DCS,
Request an approval (APVR1),
otherwise,
Request an approval (APVR2).
Re: Automate Workflow to Refresh 2 Sheets based on adding to another sheet
@Sherry Fox I've been finding that Chat GPT has some seriously solid insight on problems like this. I'm clever, but it would have taken me a day of testing to come up with a solution for this issue. Glad it worked out!

Re: I'd like to create a column formula that references a specific cell with acceptable syntax
@jcabaniss , swap out this:
=[Target End Date]1
with this:
=Index([Target End Date]:[Target End Date], 1)
the second value in an index function is the row—usually we make this a MATCH lookup function but it can also be a number.

Re: Can you have a URL open in a different tab when linked in a Form?
Hello, I had the same issue but identified that if you right-click on the hyperlink, you can select to open in a new tab.
I added this wording (in header format) to the top of the form.
I hope this helps.

Re: INDEX/MATCH/COLLECT How to get most recent entry by person and by most recent date
Sorry, I’m having trouble writing my last comment and I realized you were asking for the most recent, and I gave you the formula for the earliest. Do what I said in the first post but but update this formula as follows (just change the greater than symbol to less than):
=IF(COUNTIFS(Item:Item, Item@row, RowID:RowID, <=RowID@row)=1,"x","")
