SUM IF & LEFT @cell
I keep getting the result of 0 I am trying to sum a range if another column contains "Street Lighting" I have tried changing the text reference from the entire column, to particular range and adding the LEFT @cell with and without #(5) see below. =SUMIF(Team:Team, LEFT(="Street Lighting", [Days to respond]2:[Days to…
Calculate Date for Status Change
Does anyone know how to capture or calculate the current date that a status has changed on a task? I'm trying to capture the dates that each task is moved through the status phases of To Do, In Process, Done.
Generic "Forms" embedded in a sheet?
HI, I am pretty new to Smartsheet so, please forgive me if the solution to this question is obvious to most. :) Our company is developing some project management sheets to help us in our transition to paperless. We have put together a template that we feel pretty satisfied with to get going and as we start each project, we…
Comments on 2017-06-20 release
https://www.smartsheet.com/release-notes (2) In-Line Formula help Please allow means to turn off the feature (not turn it off after it shows up). If I realized it was always on when I was testing it, I would have said something then. I don't need to see it every time, so default to collapsed is preferred. I often need to…
Need Help! I need a few of formulas. (1) Formula to automatically populate a due date (2 weeks after start date). (2) Formula to calculate duration between two date columns. (3) Total parent rows (projects) and total based on parent color. I'm at the end of my wits! Thanks everyone!
Release Notes Link hard to find
Shaine, I was able to preview the formula Help and Activity Log prior to the release. Really liking the Activity Log for a sheet we recently rolled out that has over 500 users updating it. I'll have to spend more time on the formulas to give feedback. I did notice that the Release…
RYGB automation with date and status
Okay first off I did not write this syntax I copied and pasted from another post. It works to a point but I need it to be a little more detailed and I cannot figure it out. Here is the syntax: =IF(Status1 = "Complete", "Blue", IF([Start Date]1 = TODAY(), "Green", IF(AND([Start Date]1 < TODAY(), Status1 = "Warning"),…
Updates to the Smartsheet Community Experience
Hello Community, You may already have noticed that things look a little different here—we’ve upgraded the site to make it speedier and easier to use: * The upgrade includes a new text editor that you’ll use for discussions and comments. You’ll now be able to check spelling before you post. * Replies to posts are threaded,…
Help Us Improve Smartsheet - 2 minute survey
Hello all, My name is Jeilymar Brady and I am the User Experience Coordinator with Smartsheet UX Research. Please fill out this survey, should take about 2 minutes: http://www.surveygizmo.com/s3/3515357/SmartsheetSurvey This is a quick survey we would love for you to take so we can gather some insights that will help us…
New Community Experience: Search
Is there any pattern to the new Community's search? I search for "Outlook" Several pages of hits. They are not: 1. Alphabetical by author 2. Alphabetical by summary 3. Ordered by date of initial posting 4. Ordered by date of most recent comment 5. Number of responses 6. Number of likes on initial post. 7. Related to user…