-
Combining IF(AND and IF(OR statements
Hi all, I am trying to build a combined IF statement for a date validation field. Both of these statements work on their own. The first statement returns "University Holiday" if the "Preferred Date" is a holiday... =IF(OR([Preferred Date*]1 = "09/02/19", [Preferred Date*]1 = "11/28/19", [Preferred Date*]1 = "11/29/19",…
-
Option to Toggle off Admins Receiving Access Request Notifications
With the new update rolled out last month, all sheet/workspace Admins now receive access request notifications instead of just the Owner. This is causing major headaches for the large corporation I work for. We have thousands of users and many do need Admin permissions to perform their tasks in workspaces. However, they do…
-
Enhancement to update Data Shuttle to recognize/preserve leading zeros in front of numbers
Use case: Managing hundreds of cloud accounts that have a fixed length ID and a randomly assigned number. Some account IDs have 1-3 leading zeros, some have none, as long as the overall length is 12 digits. Issue: When using Data Shuttle to import updated lists of accounts, existing accounts with leading zeros, are deleted…
-
Smartsheet for Business Continuity Planning?
Hello, I'm a certified BC professional trying to connect with anyone who uses Smartsheet for their BC planning and execution. I will be attending Smartsheet Engage in a couple of weeks and would appreciate meeting up with anyone who is using the software in this manner to share ideas. I know there are templates available…
-
Give Administrators full vision and access to all sheets
I recently contacted support about this and was amazed to find that what I thought would be a simple function doesn't exist. We have had staff leave recently and not so recently and have had requests from senior management to look for data that they may have stored in sheets that they may of owned or shared or transferred…
-
ConnectWise Integration
Has any one here done an integration with ConnectWise? We have a small company whose resources all work production support and project tickets. If I had a way to feed tickets from CW in so that I could display all open tasks for one person that would be great. Thanks, Jacque
-
BC/DR Planning
Hi - Does Smartsheet have any template sets to create dynamic business continuity/disaster recovery plans (call trees, system diagrams, etc.)? Thanks in advance!
-
Searching through the children rows
I'm trying to write a function that searches through the children rows of parent rows and if one of the rows meet a condition ( "In-Use" ) in the use column, it'll display a name in the User column on the parent row to show who is the current user of a particular asset. I've been trying to use CHILDREN, DESCENDANTS,…
-
Is the Email Notification highlight color yellow definable?
In a standard email notification for sheet updates the changes are shown in yellow in the email body, is there a way to define that color to something other than yellow?
-
Export selected rows only to excel
Hello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also pick up the hidden rows. Alternatively, is it possible to do a mailmerge via word…
