-
Create a "This & Next Week Projects Report" in Smartsheet using RM advanced reporting
Hello, For a while now my teams have been missing a way to see their workload in the coming weeks. Taking screenshots of rm.smartsheet.com or giving them a licence to it are options, but it is either too manual or too costly for my taste. A more realistic alternative was to export reports from RM, reimport the files in…
-
URL Query String and CHAR() Function Helper Sheet
Greetings all, Because I grew tired of spending an inordinate amount of time piecing together URL query strings, I've compiled all of the UTF-8 character codes (that I came across) into an easy to use reference sheet. I've also added in a column for the corresponding CHAR() function codes and conditionally formatted the…
-
SUCCESSORS Testing
I have seen in the past quite a few people asking how we can leverage predecessors for alerts so that when (for example) the preceding task is complete, a notification goes out automatically to the owner of the next task letting them know it is ready to start. The best approach to this was unfortunately parsing out the…
-
Work Breakdown Structure (WBS) - Column Formula Configuration
Hello Everyone, Recently myself and two fellow Smartsheet Sales Engineers, @Lea Gikas and @Dave Stanley got together to create a WBS solution powered by Column Formulas. We wanted to provide the resulting configuration to the community in case some may find it helpful in executing project management solutions, this…
-
Quote of the Day on Dashboard
Hi, I am setting up our company landing Dashboard and am curious if there is a way to embed a quote of the day generator that posts a new quote to the dashboard everyday? Wondering if anyone has done this or done something similar.
-
Converting a Text Timestamp into a Numeric Timestamp Value
Problem: When timestamps are imported into smartsheet, the timestamp must be imported as a text field to retain its time aspect. Although the timestamp can be separated into a Date field and a Time field, this separation of Date and Time makes arranging the sheet into timestamp chronological order difficult. Solution:…
-
Copying Rows and their attachments work around
Currently Smartsheet doesn't have the ability to copy rows including their attachments. I've found a workaround that is much quicker than uploading all the attachments individually on other rows. This is especially useful if you have MANY rows that you need to copy including their attachments. Save your sheet as a new…
-
Bridge - Copy all attachment names to another sheet & get data from an array with a Child Workflow
This solution copies all attachment names from a source row and adds one row for each attachment name onto a target sheet. Each target row contains one attachment name and the source row primary key. The solution uses a Child Workflow to get individual data values from an array in the Parent Workflow. The solution is very…
-
Scheduling automatic reminders for Proof reviewers
Here is a way to create reminders for Proof reviewers. This solution will: Send a reminder 5 days after the initial invite, if no one has responded to a Proof review request. Send a reminder 5 days after the last reminder, if no one has responded to a Proof review. Reset when a new Proof version is created. Some useful…
-
How I calculate HH:mm
Here's how I figured out HH:mm. I welcome all simplification suggestions. The combined formula in A38 is this monstrosity (but it works): =IFERROR(IF(INT(SUMIFS({Duration}, {CURWK}, 1, {Event Type}, A$37) / 60) < 10, "0" + INT(SUMIFS({Duration}, {CURWK}, 1, {Event Type}, A$37) / 60), INT(SUMIFS({Duration}, {CURWK}, 1,…