[email protected]’s Profile
Community member since January 2019
National Louis University
How can I use MATCH to find if an instance occurs within a group of values joined with JOIN?
For example, if I join the values in three columns (Red Yellow Blue), no commas just a space, and I want to MATCH the value in a cell (say, "Red"), how can I see if the joined values (Red Yellow Blue)
I've seen people post about this, but I haven't found a way to use it or if there has even been an enhancement added to Smartsheet.
I'd like to be able to use a formula to insert the Row Link to a cell, which I can then access via INDEX/MATCH on another sheet.
I have a list of projects that
I would like to send an alert to each of my team members weekly at 2:00 pm on Thursdays. I created the form, and copied the URL. I created the Automated Workflow to send an alert to my team members, and include the URL in the Customized Message.
When I tested this, the customized message, with three
Is there any way to search a sheet for a URL, if it is included in a hyperlink? The URL does not appear on the sheet, the text for the hyperlink does instead. I tried searching, given a URL, and its not finding anything on my sheets.
Any workaround for this? Perhaps there is a way to create a hidden
I am interested in sending each of my team members a weekly Temperature Check survey. I created a new sheet to collect their responses, and a form with the questions.
I believe i have an automated workflow set up so that an alert is sent to each team member every week at 2:00 pm on Fridays.