-
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…
-
Has anyone used Smartsheet to create a User Request Form or User Access Requests Form?
Typically, URFs or UARs have been paper-based. I am wondering if anyone has created and successfully implemented a system to not only track the overall requests but to alert the various people across the organization if they are assigned actions based on the system(s) they oversee. Thank you.
-
Is there a way to utilize one sheet for multiple projects, but still roll up into a dashboard?
I work in an IT department as part of a fairly large school district. We typically don't super fancy PM tools other than a project name, all the tasks associated with that project, who is doing those tasks, and when they need to be completed. So each division in our department has setup their own sheet which as multiple…