-
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.β¦
-
Count Month from Date Value field
Hello. I have setup a JIRA extract to provide raw data on which to develop an operational dashboard. I need to be able to count 'closed this month' on the dashboard. I am getting a closed date for each row from JIRA and, since this is an automated extract feeding a live dashboard, creating another column to extract theβ¦