-
OR function Not Working with Multiple Logical Expressions
Hello, I have the following formula: =IF(OR(Status4 <> "Complete", Status4 <> "Sent/Complete"), "not complete", "Complete") which always returns "not complete", i.e. true. However, modifying the expression so that only 1 logical expression is present, the expression works correctly, showing the true and false outcomes as…
-
Anyone experiencing issues with Dashboard Published Links not displaying in Edge or IE?
Trying to deploy our COVID-19 Dashboard and during our testing we discovered that the Published Links (set to anyone with this link) will not display in Microsoft Edge or Internet Explorer. Anyone else run into this?
-
ENHANCEMENT REQUEST FOR DATAMESH and PIVOT
Please develop the ability to share Pivot and Datamesh configs. It is difficult for me to support my users when I cannot access their Pivot and Datamesh configs. Also, it makes it more convenient in training users when they can see what I built as examples. I realize I can transfer the config, but that is not always the…
-
How do I find a smartsheet expert for hire to help build out our workspace?
Hello all, I am looking for a smartsheet expert, who can build a project template for us, including a dashboard for internal and external use. We are based in The Netherlands, but we can manage everything in English as well. So are you / or do you know an English speaking smartsheet expert, who we can hire for support and…
-
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.