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.

Depending on the number of check boxes chosen add them.
I have 5 columns with Checkboxes and one with % Complete, I need the %column to show the values added up depending on the number of check boxes chosen, so if there are 3 checked boxes, it should show 60% complete. Can you help? Thanks See screen shot attached
completed tasks
How can I move completed taks to other location in the same sheet ? I have three different lists on one sheet: completed, active, not completed (as outdent and indent positions). How can I move completed tasks to required list ?
Drowndown list accessible via link to other smartsheet - Form
Do you know how we can create a form where one of the filed is drowndown list to be chosen from the list stored in other sheet ?
Auto Change Color or send a reminder / Notification
Hi, As per attached screenshot, The stock level is 3000, When the week 12 / 13 / 14 below the 3000, can the stock level cell auto change color or send a reminder via mail? Thanks in advance.
Multiple Checkboxes give different Text values
Hi, ok I have 3 columns with Check boxes, each one with a separate word, "Pre-Screen, Development, Test. I want have these word values show up on the same row in a different column when I choose the Checkbox. I can get it to work for just 1 word on the row, how do I add the others in the formula so what ever checkbox is…
One stop shop for Project Managers
We use SharePoint for our project information, forms, and such and we use Smartsheet for our project schedules. I would like to be able to link the log in page in SharePoint so when my PM's click on the Smartsheet button in SharePoint that they are provided with the login screen to Smartsheet and get into their one or many…
Comments
Is there a way to make the comments field - show in the main sheet with all the comments? Apparently it is too hard for my users to go to the comments box -any suggestions on how to achieve the same result?
Use system column in gantt view
Hi folks, I remember there was a way to use a system column (auto creation date, for example) in the gantt view...the trick was to create another date column and use the =created2 (or the number of the row).... but it will not work (smartsheet will transform the formula in text). I tried the same formula in a normal…
Approval Notification
I have a Smartsheet setup where a form is used to populate the columns. I receive an approval request and once I approve it goes to one more approver. After the "approve" button is selected, an email shows up with the following subject line: "Subject: Confirmation: Your update has been submitted" Is there a way to turn off…
Web Forms - The ability to Submit and Add New entry
We utilize Web Form option to track Support Cases. If a user has multiple cases, they currently have to submit their first case then go back into the URL for the Form to enter another case. Is it possible to have an option at the bottom of 'Submit and Add New', eliminating the need to go in and out of the form?

Popular Tags

Trending in Smartsheet Basics

Dashboard Metric Widget Not Updating with Current Backend Sheet Value
Hi all, This is from a sheet that uses a formula to count down / display the number of days til end of Quarter. What is happening: Displays 37 when the backend sheet actually says 34. The dashboard does not update until I click to open the backend sheet then the connection seems to go through to update the…
Autopopulate an email address with each new row
Hello, Community! I am trying to set up an automation that adds a specific email address to a field with the creation of each new row. It should be very straightforward but does not seem to work consistently. Trigger - when a row is added Condition - if a specific contact info field is blank {{Notify XYZ}} Action - assign…
Filtering out Status based on two criteria - Not working!
Hi, I'm at a loss and could use some guidance please! I'm running a report from my project plan to see Customer Tasks Statues by Phase if status is not "Complete" or "Not Required". The Complete status don't show but the "Not Required" do. I have tried all the options (Is not blank, Is not equal to, does not contain, is…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags