-
Customizable Banner Messaging to Subscribers
It would be great if we could customize the banner displayed within sheets as done by Smartsheet to market new features so that SysAdmins could message to their users without the need to do by emails. Examples: Renewal survey is about to launch, Did you know you can go to our company resource dashboard by doing xxxx,…
-
Employee Objective and Performance Reviews
I am looking for a real-world example of someone using the employee Objective and Performance Review Template for an IT manager? Do you find it useful and easy to use for managing your managers? Anything you can share would be greatly appreciated.
-
Smartsheet + ServiceNow SPM Integration: Simplify Project Management
ServiceNow SPM is a powerful tool, but for casual users, its steep learning curve can be a challenge. That’s where Work4Flow’s Smartsheet + ServiceNow SPM Integration comes in. This integration eliminates inefficiencies, automates workflows, and transforms project management into a seamless, productive process. Key…
-
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",…
-
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…
-
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…