Best Of
Contain items that I don't want to count
"pruned boxwood and boxwood hedges."
This is an an entry for a cell from a form. There are two search items here: "boxwood" and "boxwood hedges".
I have another cell attempting to note that boxwood (shrubs) were pruned separate from "boxwood hedges".
=IF(AND(CONTAINS("boxwood", [FN: Pruning]@row), (NOT(CONTAINS("boxwood Hedge", [FN: Pruning]@row))), Month@row > 5, Month@row < 11), 1, "")
of course this only brings nothing if the entry has "boxwood hedge".
If I only do the following (disregard the dates parameters)
IF(CONTAINS("boxwood", [FN: Pruning]@row), 1, ""), I get boxwood even if I only pruned boxwood hedges.
Up shot: how do I account for boxwood only when boxwood hedges are also noted?
Craig Lemberger
Re: Automated hyperlink URL within anchor text
Hi @srasbornik2 ,
Using Power Automate, you can create an automated workflow that checks the checkbox column in Smartsheet, retrieves email content including the login URL and formatted display text, and sends an HTML-formatted email to the client with a properly formatted hyperlink.
You can automate the same using Google Apps Script, too.
Image of Power Automate Flow
Received Email Image
Re: Is there a way to show which reports are built off a sheet?
Hi there, I am not aware (almost certain) of any options that will do this. I wanted to know something similar (identify reports which are used in dashboards) but unfortunately there is no feature that will reveal like-information to your request.
Louis.
Louis1
Re: March Question of the Month - Join the conversation and receive a badge
The skill I would like to improve is my selling skills, selling a great idea to executives, better at selling what my accomplishments are, etc…..
AnthonyxXx
Re: Power Automate and Smartsheet
Hi, @Lieueez,
We currently do this via a couple of methods.
In the first example (#1), a Smartsheet automated workflow moves the row into a sheet that the Power Automate (PA) flow is monitoring. The new row triggers the PA flow. This flow sends a rich text email (with attachment) to the client and creates an event in the Outlook calendar. An automated workflow moves the row back into the original sheet at the end of the day.
The second example (#2) is used when we need to send a Smartsheet attachment and an update request to the client. In this approach, a Smartsheet automated workflow sends a notification to an internal email account. The alert includes the row’s attachments. The Power Automate flow parses the email body for the necessary information and generates the rich text email.
Hope this helps!
TVang
Power Automate and Smartsheet
I want to use Power Automate to send a professionally formatted email with Smartsheet data embedded in it. For example, Power Automate would receive the person's name, email, and pre-filled form's link text (instead of a long URL) and compose/send an email. I know Zapier can do this, but our team doesn't want to pay for it.
Does anyone have experience building automations with Power Automate and the coding for composing json arrays and parsing jsons for emails? Any resources someone could point me to? If I figure out how to do it I will share on this thread.
Lieueez
Re: Power Automate and Smartsheet
Hi @Lieueez
Though not professionally formatted, I experimented with Power Automate to get data from Smartsheet and send an email using Power Automate's code view feature in the Send an email (v2) action, to answer the following.
As I'm new to Power Automate, I used a combination of Filter Array and Composer to get a column ID.
To get a cell value to use in an email, I first used Filter Array to get the columns.
Then, I used the composer to get the columnID;
first(body('urlColumn'))?['id']
Then, in this example, in the "Apply to each Row(s)" & "For each cell(s)", I checked if a checkbox is checked.
If so, get the cell values using the column ID to get the value.
Again, I used the Filter Array & Composer to get the value.
first(body('SendEmailRowUrlCells'))?['value']
Finally, use the code view feature </> to use those values or Outputs in the Body of an email.
Restrict dropdown options as an option for forms
There should be a way to restrict dropdown options on forms that are external facing that also have internal uses without setting up additional reference or separate internal/external columns.
Use cases for our team in particular would be project type and add-ons. We have different customers using different forms on the same sheet, and need a way to restrict access to different dropdown options per form.
Thanks!
Lydia Bowman
Re: New User Model and Publish Users
Hi all,
Jumping in to verify what Support said above:
In the User Subscription Model, Membership is determined by core asset permissions. Permissions dictate what actions a user can and can’t take on an asset, so any action that requires permission triggers provisional Membership.
Users looking at a published item that is set to allow access to "anyone with a link" do not require direct sheet sharing access, therefore it will not trigger provisional Membership.
Cheers,
Genevieve
Genevieve P.
Re: How to automatically pull unique values to sheet 1 when sheet 2 is updated?
hi @walterday,
from how I understand your problem you want to trigger the workflow to copy row from one sheet to another based on the changes that were made in linked cell.
Unfortunatelly it will not work - smarthsee blocked the option to trigger workflows that change sheets like record date, copy row, move row - as some users can make the invinite loops etc.
if you DataMesh it can solve your problem.
kowal