-
Importing excel spreadsheet that has long column names produces duplicate column error
Just thought I'd toss this little tidbit into the community in case someone else stumbles into this. I was trying to import and Excel sheet into SmartSheets and received and error indicating that the excel sheet could not be imported because it contained duplicate columns. Turned out that the reason SS thought it was a…
-
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"…