Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Performing standard algorithms on % Complete column
Hi, I can't beneath the % Complete column do any standard algorithmic computation e.g. =SUM(bla), =AVG(bla) In any other column such options are auto-suggested when I start typing. In the % complete column it is not and the commands don't work. Kindly advise. Thanks
Rich Text Widget is suddenly missing Cancel and Done buttons and Scroll bar
Please see widget with title "In Progress Tasks." Here's the address: https://app.smartsheet.com/dashboards/fhmp8FhCp98HQfrj3RcH3mXpF9MCRvMv4Jv6p6M1 Andrée, please see the screen shots, one has the buttons but not the other
Gantt View
Hello! Is there a way to remove the grid lines from gantt view? Thanks!
Pushing dates to calendar
Hi Can anyone help with a formula that only pushes a certain dates to the calendar? I want to publish only certain dates. I tried the filter but you can only set the default view on filter when sharing not publishing. Thanks Emma
What is the best way to create a Pert Chart with Smartsheets?
I don't see an option for it in the "View" button for my project. I did find this article in the help pages: https://www.smartsheet.com/pert-101-charts-analysis-and-templates-more-accurate-project-time-estimates#pert-analysis-how-likely-will-the-project-be-on-time Which says "if you do it by hand" implying there's another…
Auto populate cell based on date update request sent
Is there a way to auto populate a cell based on the date that an update request is sent? I would like the cell (a date field) to auto fill with the date that the update request is sent. The update request is sent automatically based on other triggers. Thanks!
Structured content in a cell
I has a sheet that uses RYG for status. If status is Red, I want my users to fill in a "FIX IT" column. Who is responsible When it will be fixed What will be done to fix it .... I would like to force this format. Can I tie a cell to a webform? Does anyone have a suggestion on how to collect this data?
date formulas
i'm looking for a way to add due dates. for example, i need the concept review 1 to be about 12 business days after after kick off the concept review to be about 4 business days after concept review 1 concepts to product marketing to be 2 business days after the concept review so on and so forth. but i'm getting all kinds…
Problem adding countifs
I'm trying to count projects that have either a four or five priority and this formula works: =SUM(COUNTIF({PLT Project Roadmap Range 17}, "Four"), COUNTIF({PLT Project Roadmap Range 17}, "Five")) I want to count projects with either a four or five priority that start either today or in the past and this formula doesn't…
multiple projects w/ multiple dates
i am trying to figure out the best way to put several projects with multiple due dates in the grid view. for example one project would have all the below due dates, and then we have several projects that we would like to see in the calendar view : project: Week 44 mailer Creative Concept Kick Off Concept Review 1 Concept…

Popular Tags

Trending in Smartsheet Basics

Move Row Automated Workflow moving ALL rows regardless of criteria
I set up a workflow to move rows that are marked Closed to a Closed sheet. However, the trigger does not seem to work and when I force run the workflow, it moves all of the rows regardless of what is in the cell. What am I doing wrong?
Search a string and return multiple results
Hi experts, I have a formula that searches a string for a keywords, in a string that may include more than one result. It only returns the first instance found. Is it possible to have it continue searching and return all found keywords? Here is what I have currently…. I am looking at JOIN(COLLECT, but not clear how to…
Custom Report View
I have a report that is pulling information from a sheet. Is there any way to set this report up so that anyone that views it only sees the rows with their name on it?

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags