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.

IF THEN formulas for status balls
I am trying to use an IF THEN formula to show status balls. I have a "due date" column and a completion column. If the date in the completion column is more than 7 days later than the date in the due date column, I'd like the status ball to be red. If the date in the completion column is within 7 days of or before the date…
Editable PDF Worksheet
I created a worksheet with "checkboxes" I want to publish this to allow for certain individuals to be able to make multiple copies and to be able to check off the boxes as needed.
Average only if certain status
Hi, I am trying to create a formula that takes the average of a column called 'days in work', i only want to take the average if a different column 'status' has the status of the row shown as 'in progress'. I tried to do IF ( status column = "days in work, average (...)) but it did not work. I need help figuring out the…
Saving Sheet changes
Hi everyone, someone on my team brought this to my attention and i want to see if anyone else has experienced this. I have a sheet where the 90% of the data is entered via a form. the remaining 10% of data is filled in afterwards once some additional information is received. my team member says that he is 1000% certain he…
Copy/Paste Not Working Today
Today I copied data from and Excel spreadsheet and tried copying it to corresponding cells in a Smartsheet grid and the paste function didn't work - no data was pasted. I've copied and pasted data into sheets many times in the past and have never encountered this problem until today. Is anyone else having this issue? Can…
Specific Mailalerts (triggers) not working today
Hello everyone Today - like many days before - I added and edited data im my sheet and (tried to) trigger workflows. All of a sudden today mails are not delivered like they used to all days before. I changed nothing severe (only moved the sheet to a workspace, but already undone it). It only happens within one specific…
How do I get around approvers being on vacation in a workflow?
Hi there, We have just started using a simple workflow to approve capital investment projects in the business. The workflow submits each project justification through a hierarchy of approvers, dependant on the value of the project. The workflow has minimum of 7 approvers in the process for a given project to gain approval.…
Sum column total from another sheet if checkbox checked
Hi, I've seen this done on same sheet but I'm having trouble accomplishing my goal trying to pull from another sheet. What I'd like to do is on "New Sheet 1" have the "Done" Column total update from the "To Do" Column from "New Sheet 1b" when the checkboxes are checked. Thanks in advance!
Report for yesterday
Hello, I hope someone can help me. Maybe I'm blind, but I can't find a way to make a Report for only yesterday, I work on a big sheet (> 4,000 rows, 25 columns) with many different days in the column [Datum]. Now I want to make a report, that shows only the rows from yesterday. Not today, not further in the past. I want to…
Project Management and Stakeholder Logs
We're using smartsheet to track a land acquisition project for a utility. Each row will contain a contact, parcel features, a dates of progress. We need a way to manage daily communication and updates. We have considered using comments and a remarks column. Is there a better solution? Thanks!

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