Best Of

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.

AmandaB

1 ·

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).

a TRIGGER for a second update request if declined workflow 1 magnifed.png

jmyzk_cloudsmart_jp

1 ·

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!

Lucas Rayala

1 ·

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.

Lucas Rayala

1 ·

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.

BTomei

1 ·

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","")

Lucas Rayala

1 ·