-
Use workflows to streamline your approval process
Suppose you work in a marketing department, and your team creates various types of content, such as blog posts, social media posts, and email newsletters. You want to establish a streamlined approval process to ensure that all content goes through the necessary stages before publication. Here's how you can set up a content…
-
Fixing Form Submissions Not Appearing in your Sheet
Issue: Have you ever filled out a form and noticed that the submissions aren't showing up in the sheet where they should? This is a common problem, but there's a simple solution! Cause: This usually happens because rows with previous data in your sheet were cleared using the "backspace" key instead of using the "delete"…
-
Smartsheet Dashboard Accessibility Color Themes
When designing Smartsheet dashboards, accessibility should be a top priority. This is when Smartsheet Dashboard Color Themes come to action! No more picking random colors or spending painstaking amounts of time making sure the colors you want to use actually work together. Now you can access 9 different color themes…
-
Lock or Store Date/Value Solution without using Zapier
Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it…
-
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:…