Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Sights- how to pull data from different workspaces
Is it possible get sheets in from separate workspaces to roll up to one dashboard (sights) without having to create a report?
IF formula to generate deadline
Hello, I am looking to create an IF formula that would generate an upcoming deadline automatically based on two factors. The first is a customer dropdown selection row and the second being the submission date of the item. Such that if a certain customer is selected a due date will be generated 10 days from the submission…
Re-importing Comments Fields after external data cleansing
We are planning to export a large Smartsheet data set to an external database for merging and deduping with a number of other data sets. we then want to re-import the enriched dataset back into Smartsheet. The challenge is that the curent Smartsheet has a large number of Comments that we don't want to lose. We can easily…
Automate RYG balls when a check box is ticked in one colum only out of three columns
I am trying to create a formula that changes the RYG balls to Green if one box is checked out of three columns. Can anyone help?
Trying to Sum Rows of linked cells
I'm new to Smartsheet and struggling with a few things, one in particular is wearing me out. I have several rows of linked cells that pull number values from another Sheet. I'm trying to Sum total these linked cells but the basic Sum formula doesn't seem to recognize these numbers. If I remove the Link the Sum formula…
Importing multiple rows into a webform
I need to get stock declarations from a supplier for about 12 items into a sheet. I would like to send him a webform each week that he can complete and submit back and that will in turn populate 12 new rows in a smartsheet. I would then use the update to update a master stock list sheet (using Azuqua). But I need to have…
Multivalue field
Hi, Does Smartsheet have a feature that allows users to enter multiple values via checkbox? I am trying to create a database with a checkbox column that contains several responses that users can select one or multiple responses from. Thanks in advance!
Can color codes in Smartsheet export to a Google calendar?
I have three status listings for my projects in Smartsheet - not yet started, under development and completed. Each one is color-coded differently (red, yellow and green). I also have exported my tasks to a Google calendar but all the items appear in the calendar in the same color. Is there some way of exporting different…
Exchange Server 2010 or 2013 (On prem)
Any update on support for on premise implementations of Outlook platforms (Exchange 2010 or 2013) integrating with SmartSheet? We won't be utilizing Office365 at our firm. Thanks!
Help needed regarding Date formulas/Formatting
I have a question regarding DATE formula, I have two Columns 1st one "Project Return" and 2nd one "Revised Project Due", is there a way that i manually put a date in first column and the 2nd column automatically calculates a date 7 days later (working)?
