-
Bold a row if name matches name from other sheet
Hello, I have two sheets. Sheet 1 has a list of organizations and I need to check a box if they have received funding from us. Sheet 2 has a list of organizations we have funded in the past. There are over 100 organizations. What would the formula be to say if the organization name on Sheet 1 appears on Sheet 2 check the…
-
SEEKING HELP on Phishing attack who used Smarsheet team as sender
Several staff members from our organisation fell for this phishing email, looks like it's from Smarsheet team (see attached Image) so users click on folder link from an email and their account was compromised. Has anyone else have experienced similar phishing attack as we don't have visibility if this is on a larger scale…
-
Backup tool for one user only?
I am using the backup tool provided through the below link with SmartSheet. The issue we are running into is that we do not need it to backup every single user (this is time consuming and bloats to over 3 gigs of data currently). We are looking to keep this more targeted if at all possible. Has anyone had any luck altering…
-
Face Fit Test Register designed & delivered to NHS - NOW FOC to NHS Users - COVID_19 solutions
Smarter Business Processes (SBP) has been working with NHS Tayside who urgently needed a solution to track and monitor the progress of their Resporatory Protection Programme to test and face fit all Frontline staff with Masks that protect them from common airborne diseases, urgent due to the COVID-19 situation. A template…
-
Limit to Shares for Admin and Editors w/o Subscription
Hi Smartsheet Community, I do not have a paid subscription but was set up as an Admin for a sheet. I had only shared it with 2 people before it sent me a message that I had exceeded the number of email recipients that I could share with. Is this accurate? Do "editors" with sharing privileges have more shares that admin?…
-
Trigger To Move Row
Created workflow automation to move a row based on a single condition. After successful testing, edited the workflow to add a second "or when" condition. After saving, the workflow stopped working. The only workaround was to delete the workflow and recreate it; which worked.
-
Index/Match? Not sure best function for my needs
Hello, I have a very extensive sales tracker that I use to log charges and calculate the sales rep's commissions based on those charges. The commission percentages change depending on a variety of scenarios, so I created four columns with separate formulas for each scenario. I need the commission column to auto-populate…
-
Counting people with the same email domain in a multiselect assigned to cell
Hi there I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual. I want to count how many of the contacts in the cell belong to the same company. I.e. have the same email domain. In…
-
Automatic report creation with custom template
Hi! I am working on creating a report in which data is obtained using a Smartsheet form. For each new answer on the form, a new report or Dashboard must be created, which must have the format below. I wonder if there is any tool, API or integration with any other platform that would make this possible? Any help is much…
-
ODBC data pulls US date to mail merge
I am pulling information into a Microsoft Publisher label template from Smartsheet using ODBC smartsheet live data connector - this all works fine but any columns that are formatted in smartsheet as date columns are switched from UK format (DD/MM/YY) to US format (YYYY-MM-DD) and the only way I can find to resolve this is…
