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. Archived 2017 Posts
Archives for December 2017
Discussion List
Link to cells in a different sheet
Hi SC, I need to link cells across two different sheets and I am looking for a way to avoid having to create the link one by one. The cells to be linked are located in adjacent columns so ideally, I would just need to create the first link for the first column and then drag the formula through all the columns. I tried it,…
OFFSET FUNCTION
Hi SC, Does Smartsheet have an equivalent of the EXCEL OFFSET FUNCTION ? Thanks
SheetNames appear differently in SSIS compared to SmartSheet
Hello, I am trying pull the information from Smartsheet Dynamically using SSIS. I see that the Sheet Names in SmarSheet is different to what I see from SSIS ODBC Source. For Example : Names in SmartSheet Displayed Name in SSIS * 801 Centre Road 801 Centre Road__8524479023343492s_(Home) * Canterbury Road Canterbury…
Request - Find and Replace option in project sheets
While using my project sheet, I will perform a Save as New to copy my format; however I will need to do bulk changes. It would be such a time saver if I could perform a Find/Replace (all).
New Template(s) for The Public
I want to get this template to smartsheet for the community. Its for a family event with multiple data such as room availability, price, tax deduction, package and room assignment with form. Don't know how to donate this, but I would love to as its great for family get togethers. Won't do another one for 4 years cuzz it…
Requirement Traceability
Hi there - We are struggling with some inadequacies with our internal requirements management system and are looking for a workaround or way to leverage Smartsheet for this purpose. Main goals being requirement traceability and bulk uploads. Has anyone leveraged Smartsheet for requirement management and repository…
Trying to have autonumber show in a webform.
Hi all, I am creating a survey in SS, with a form for collecting answers. I'd like to use a auto number column as a way to create a unique ID for each row. However, I'd like that unique autonumber to show up in the form. This is so users when filling out the form, can see the unique ID associated with their submission. Any…
Needing an "If, Than" formula for multiple variables
I am pulling together stats for a project using the JIRA connector and I need to be able to SUM all "Open" issues + "Reviewed" issues into one cell. I have the beginning of the statement and it works just fine, but whatever I tried to add the last part, "Reviewed" I get an unparseable error. Here is what I have:…
Highlight Changes in Free Trial?
I'm trying Smartsheet out Cross-Departmentally. I'd like to be able to see the changes, but don't see the 'Highlight Changes' option in the Free Trial. Am I missing something? Thanks! -Cindy
Formatting with alerts
I need to do the combination of formatting with and alert, but seem to have hit a wall. If column "delivery type"= selection "o" and column "1st delivery" has a date that is past due then turn "1st delivery" to red and send an alert to the contact in columns "PM" and a particular individual. Any help would be appreciated.