-
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…
-
Formula HELP!
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…
-
Are points no longer tallying?
I seem to have remained stuck at the same point value after the community redesign? Is this accurate or am I missing something?
-
How to start building project roll-up with 110 dropdown names to pick also
Where to start, project roll-up, don't want a done of linked cells if can avoid it. Need it simple for user interface. Today using Excel just type it in, pick the color for the cell. The color means something based on a key. There is high-level corrdination of the overall program, then high-level for a project, then…
-
How do you make a Program roll-up
How do you make a roll-up of multiple indivdual projects. Wtihin each of the project dependencies is turned on.