-
Linking Columns of 2 Sheets to Feed into a 3rd
Hi There, I believe this should be fairly simple, however the steps are lost on me. In particular I am looking to take a single column from two seperate sheets and have them feed into a third. In this instance I am taking a Request Form (office supplies, multiple options from drop-down to cell) and an Inventory Form (cost…
-
Dropdowns with multiple levels filters
Please, Do introduce dropdowns whose options are filtered by previous options! This is a massive feature that prevents most of my projects being fully moved to Smartsheet! It would be a great addition that would change the game for lots of us!
-
Parsing Multi Picklist through API
Hi everyone, I just started working with the SmartSheet API. So far, everything has been straightforward, except one thing; I am trying to submit new rows to a sheet but can't seem to get the value of the Multi Picklist right. If submitted as a string in various formats, the value only displays as one long tag including…
-
Syntax: Add Row via API for Multi Select Contact Column, MULTI_CONTACT
Dropping this here in the hopes Google picks it up for future developers. At times when you cannot use the SDKs for adding rows via the API with multi-select contact columns (i.e. Bridge), the following body payload syntax is correct for posting new rows to a sheet. [ { "cells": [ { "columnId": 4532552246972292, "value":…
-
Change Background Color of Dropdown Bubbles
Is there a way to change the background color of the dropdown bubbles? On the main report, everything is in its own gray dropdown bubble, which is best for black text. However, when I run a report, the dropdown bubble is removed, leaving the text over a background color that varies with our color coding. In this case,…
-
Formula continuously updates cell even though values are not changing
Certain combinations of results are continually updating even though the value/result didn't change. Every time I open the sheet, it requires me to save but I didn't change anything. Combinations with issue: "Utility, Telecom, Waste" and "Utility, Telecom" Combination without issue: "Utility, Waste" Services column is…
-
I am trying to create a formula - multi selection dropdown menu and between two dates.
I am trying to create a formula to count how many "A" in in the dropdown menu column which you can select multiply answers. I also need this formula to look at the 1st quarter only of 2025. Any information will be appreciated. =COUNTIFS([THREAD]:[THREAD], HAS("A", AND([Date Submitted]:[Date Submitted], >=DATE(2025, 1, 1),…
-
Alphabetized Filter Dropdowns
It would be helpful if the "is one of" dropdowns in filters were alphabetized instead of listed in the order of most used. For dropdowns that have many different options, it is hard for team members to find the option they need in a filter when it isn't alphabetized. Example of Today Red (52) Green (43) Yellow (28) Blue…
-
Smartsheet Salesforce Integration: "Value is not supported for this column Type."
I have created Workflow for bi-directional sync in the Smartsheet Salesforce Connector between Salesforce and Smartsheet. In Salesforce, I have a Lookup(User) field named "Assigned To" and in Smartsheet, I have a corresponding "Assignee" column with the Multi-Select Contact List data type. When I update the "Assignee"…
-
IDEA for Copy Row Automation: Also Copy Assigned Dropdown Value Colors
If Colors in a dropdown column are setup (In Table View), the Copy Row automation should retain those same colors when copied to the new sheet. Just like how cell colors copy over, I'd like those assigned colors to copy as well.