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 September 2017
Discussion List
Future of native Discussion/Comments/Chat or do we move to MS Teams
I'm starting to explore MS Teams as a workaround to compensate for the discussion functionality with SS. I don't really need the hassle of onboarding Teams although I'm feeling the pressure from colleagues to do something to help our flow further. Are SS ready to beta the advance discussion functionality that has been much…
Formula help
I'm looking to write a formula that looks at cell A1 and if it contains "Sent" within the text of the cell, it grabs the number in cell B1 and writes it in C1. Example: Cell A1 = "Sent w Statement" Cell B1 = $100.00 I need C1 to populate $100.00 because A1 has the word Sent within the text Any assistance is greatly…
Smasrtsheet freezes and crashes Chrome
Today I created new sheet and it started to freeze when I click anywhere on this particular sheet, which is almost empty. Other ones seems to be ok, but this one I can't use at all. Anyone faced similar issue? I have restarted my PC, etc, but still nothing. Yet, I had to present this sheet today to my boss, so you can…
Save as New
I love how the Save as New now has the ability to include Notifications & Sharing options to be saved; however, why are reminders not included? With dozens of sheets that have notifications and reminders that I roll forward each month, this new feature is still not useful/complete because reminders aren't captured.
How to change the sender email address when Sending Link to Form?
We use a web form as client survey but when sending it typically goes to the client's junk/spam folder because it's coming from "John Lee via Smartsheet <user@smartsheet.com>" instead of my email address which they have already interacted. This is negatively impacting our ability to communicate with clients as we have to…
countIf for several values in same column
Hi - Newbie here, but how do you count several text values in the same column? =COUNTIF(Status:Status, "Closed" OR "Deployed") doesn't work
Detect if cell value increased or decreased
Is there a way to detect if a cell value increased or decreased compared to its previous value? I've already devised a way to reflect a symbol if the auto-column date modified was today. Now, I want that symbol to vary depending if the value on a cell in that row increased or decreased. Or if there's a way to put in two…
Jira Connector uploading Duration in Seconds
Something has changed. I had a JIRA Connector working well, exchanging task duration in days from a JIRA Field, and a Duration Column in my Smartsheet and something changed The connector now populates my mapped JIRA field using seconds rather than days. It used to populate the JIRA field in days, just the way it was…
Logical Update Request
I am thinking about a scenario with an automatic update request: On the task start date, send an update request to the 'assigned to' column. On task completion , send an update request to the 'assigned to' column. Looking at the new update request functionality I am wondering if anyone has thought of a way to do this.…