-
If the checkbox is checked copy the row
I am having issues solving a problem. I have a sheet containing multiple columns (3 text/number, 1 date, 1 contact list, and 1 checkbox). Made out of around 150 rows. I want the rows copied to another sheet if the checkbox is checked. I tried: Using a copy row automation which works but rows are always copied at the end of…
-
Importing excel with a column containing Hyperlinks into Smartsheet
I have an excel that contains values that are hyperlinks constructed with Hyperlink construct. for eg: =HYPERLINK("https://docs.oracle.com/en/cloud/saas/readiness/common/26b/common26b/26B-common-wn-f43843.htm","Multifactor Authentication (MFA)") When I import that into smartsheet, all the values read #UNPARSEABLE. I see…
-
Board View Report Without Giving Users Access to Sheet
We have a Smartsheet form where users can request a certificate of insurance. Their email address is recorded in a contact field. I've created a report that filters the contact field to the current user. We'd like for them to be able to see the report in board view, but only for their requests, and do not want to give them…
-
Lost access to Smartsheet Data
I have not used Smartsheet for several months and my subscription expired. I now wish to resume using it but all my folders nave disappeared. Is there any way of retrieving them?
-
Automation workflow not including attachments in notification emails correctly
Hi ! I am trying to figure out why some email notifications include attachments and others don't. I have a few teammates who add attachments to the rows when certain columns are triggered by a checkbox. I have my automations set below. And you can see once column was checked email includes attachment, but same email it…
-
Need to Understand Basics
Is anyone a SmartSheets pro that could get on a call with me for no longer than an hour and go over some basics (to you I'm sure) on how this system works? My Launch10 package was used mostly to set up my first sheet and I never had the time to actually learn how to use the system. I have automations set up but there are…
-
How to create a dual dynamic list of unique column values - including a short list of associated values per unique value?
I'm looking to create a 'dual list' of unique column value pairs. I can create a single list of unique column values with a helper Row # column and the following formula: INDEX(DISTINCT(COLLECT({Epic ART Impacts: ART}, {Epic ART Impacts: Epic ID}, [Epic ID]#)), [Row #]@row)) When pointed at a list with MANY duplicates,…
-
RAG Roll-up formula
Could anyone help me with a formula I'm trying to perfect. I am trying to create a formula that automatically captures RAG status for Children Rows and how this is communicated to the Parent rows. The plan is essentially structured like this (images are attached): * Project Plan Summary (Senior parent)* Main Tasks…
-
renewed subscription and all files are read only: how to fix this?
renewed subscription and all files are read only: how to fix this?
-
What is the best way to bring in data from another sheet without a direct matching column on both sheets?
My goal is the bring in contact information (Name and email address, 2 separate columns) from a reference sheet {Sheet A} to my target sheet {Sheet B}. I've used {Sheet B} as a reference on many other sheets for the same purpose, however, the data on this particular target sheet is inconsistent with the reference sheet.…