-
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:…
-
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,…
-
Turn Numbers Into Letters
Here's a handy formula to turn the numbers 1-26 into letters. Assume that the number you want to convert is in a column called "Number". In another column, create the following formula: =RIGHT(LEFT("ABCDEFGHIJKLMNOPQRSTUVWXYZ", Number@row), 1) If you need to increment these beyond Z, it gets a little more complicated, but…
-
Poor Man's Datamesh
Prior to getting Datamesh, I devised a solution to transfer data from one page to another, without having matching columns. This process uses an intermediary sheet. It's kind of a pain to set up, but it works well and requires little to no maintenance. I still find some very small use cases where this comes in handy.…
-
DataMesh within the same sheet to copy cells from one column to another
Up until today I've restricted my understanding of datamesh to copying values from sheet to sheet. However, I just discovered today that you can use it WITHIN a sheet! What does this solve? If you ever need to copy a value from column A to column B, but do not want to use a formula, then this process is perfect. It also…
-
Smartsheet Control Center Auto Provision... Cross Sheet References Not Loading?
For the Smartsheet community online: I've made a valuable discovery regarding Index(Match()) Cross Sheet References and all others when using Control Center in Smartsheet. If you're experiencing issues where these references don't work when creating "Children" from a "Parent" folder, here's a solution to save you time and…