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.

Chart not selecting data
Hello, I am trying use a chart in a dashboard. When I try to add a chart, it prompts me to select a sheet and then a range of cells to pull data. However, once I click "OK" it will not allow me to select chart types or make any adjustments. It just doesn't show up at all as if I had not selected any information to pull…
Turn off display of weekends on Calendar view
I do not want weekends to display on the Calendar view of a task list, but I don't see any way to do this in the properties. How is this accomplished?
Setting character limits on SS Cells or form area
Does Smartsheet allow you to set a restriction on the amount of characters allowed within a cell or in the txt box within forms? Thank you
Task Spanning Multiple Sprints - How do I Capture Actual End Date?
1 task going across 2 - 2 weeks Sprints Jira is pulling the first Sprint Name, Start and End Date --- but, the Task will not finish until the end of the second sprint. Any suggestions on how to include subsequent Sprints? I have attached a screenshot of what came over from Jira to SmartSheet Sprint Name, Start and End Date…
Sequential Numbers "IF"
I have a project management template that I am trying to set up with a column to produce sequential purchase order numbers only if a column named "ORDER DATE" is populated in specific category rows I have named "ORDER MATERIALS". Can this be done? I am not too good at formulas, so the more specific, the better for me in…
COUNTIFS with reference to another sheet with multiple criteria
I'm looking for the correct syntax to count the number of lines from a reference sheet that meets criteria from two columns: Count number of lines where Type (Column) = "Action Item" and Status (Column) <> "Closed" This is the formula I used: =COUNTIFS({RI-eProc Action Item, Issue & Risk Tracker Range…
update request every X days
Hi is it possible to send an automatic update request every 2 weeks without changing anything in the sheet to a contact in a column? Many thanks Peter
Calendar with Multiple Years
How do I make a calendar that shows multiple years on the same grid view? When I change the yellow box, it just changes the start date column, but none of the other columns so it doesn't start a new year. I'd like to create an on going calendar that shows multiple years on the same sheet.
Conditional Formatting Cell Level
Hi, I need help or guidance in Conditional Formatting at CELL Level not all rows or all columns. For example: if the % is Below 30 its RED, 30 - 80 its Yellow and 80 + is Green. Please see attached the photo for more clarification. Thanks and please help.
Adding Contacts - Logging in for the first time
I'm trying to understand how and when a new contact will receive an invitation to log in and set his or her password. Does this occur when a new contact is added? When a contact is added to a group? To a specific record on a Smartsheet? Any pointers would be helpful.

Popular Tags

Trending in Smartsheet Basics

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags