-
Getting list of archived projects from Resource Management
Here is how you can currently get a list of archived projects from Resource Management. This solution does not explore Bridge or integrations using API. Resource Management does not allow you to export the archive status or archive date of a project This should be fixed. This could be possible this is possible through…
-
TIP: How to reference a \ backslash or " double quotes in formulas + [ ] in Col Names
While researching a problem I had and the absolutely simple solution that was causing it, I decided I would write this post to help people in the future. This is not an official post, just me trying to give back to the community in hopes it helps someone, so if you have more info to add (or correct me) please post it…
-
Smartsheet Bridge: Iterate over an array using JavaScript - Column names from a sheet
Here is the full solution for how to iterate over an array using JavaScript. Smartsheet provides a partial and incorrect solution at https://help.smartsheet.com/articles/2482603-javascript-module-reference. Below is the actual solution. Using Bridge and JavaScript, this example extracts the list of column names from a…
-
Quick way to copy formulas across sheets I found
Problem: I had the need to copy a list of 26 formulas to 56 sheets maintaining the formulas for each sheet. to increase the data collection across the sheets. All sheets have the same column names. Smartsheet defaults to saving the end result, and doesn't offer the ability to just copy the formulas from one column in one…
-
Working with Symbol Formulas
Hello Smartsheet Community! As our Community grows, I am starting to see some trends about features and workarounds users want to learn more about. For these topics, I am starting a new series of announcements. In this series, I will write about trending topics and topics that you request! After I post about a subject, I…
-
Daily Update Solution without the need to open the sheet, use Zapier, or similar
Hi everyone, Happy New Year! I hope you're well and safe! I've developed a way to use the newly released Record a date feature to update sheets with today's date automatically without the need to open it or similar. 1. Add a so-called helper column. (Date). We can call it Today Helper and add a date before the current day.…
-
TIP: Calculations on an AutoNumber Column
I've noticed when trying to run formulas on my AutoNumber column, that it doesn't always work. Here's a table of some of the results. For each row I changed the autonumber "Numerical Places" from 0 to 00 to 000 to 0000. You'll see that the results conclude that Formulas on an Auto Number column MUST USE SINGLE DIGIT…
-
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…