-
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…
-
Get multiple pages of data in Bridge
Hi all I just wanted to pass along a pro-tip that I got from the Technical Engineering group at ENGAGE 23. If you need to deal with paged data in Bridge, it's not immediately obvious how to do that. At least not to me :-) So I asked. For example, if you do a List Sheets in Bridge, you may get some of the data back on page…