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.

Will changing a sheet name break the cell links?
I want to change a sheet name, but it is the source sheet to another sheet with cell links. Does anyone know if the links will break, if the source sheet name is changed? Thank you, Bill
Creating formula on past dates
We have created a sheet which has a start date and a due date. I would like to have the status column change to overdue once the due date is past the current date. If someone would be able to help me that would be greatly appreciated. Thank you Dave
Can a System Administrator view all sheets in our account?
We are considering moving an existing survey over to Smartsheet. In this survey, leaders of our company share specific comments about their direct reports. Would our System Administrator in IT be able to see the data in this sheet by default? If that is the case we would not be able to make this change.
Conditional Formula
What is the formula to use if I was to populate a value in one column if the Start date is today's date or later? Is this possible? So if the start date is todays date (for example) I would like the status column to change from a value of Planned to Current. Any ideas?
Parent/Child Rows
Hello I have built a production schedule for our assemblies in our shop. We have a parent line with the Job# and the assembly being built. We then have indented child rows under the parent row for all the individual components needed to build the parent line. We track if these items have been received by changing a column…
Error when trying to add a user within the company
Hi, I am trying to add a user through User Management, but I get this error: "The user you are trying to invite is in a Smartsheet Enterprise Plan. To invite and Enterprise user, please contact sales at...." Any help is appreciated. Thank you, Deepthi
Cannot embed Data Studio Report on dashboard
I trying to add a Google Data Studio report to a Smartsheet dashboard using the Web Content widget. The explanatory text says that it can be done, but the link is not recognised as being valid. How can I achieve the desired result?
Sumifs returning #INVALID DATA TYPE when referenced range contains a formula
I am creating a per week rollup that shows a sum of the children rows from another sheet. It looks to me like SUMIFS does not work if the range referenced contains a formula. Is this a bug, limitation, or do i have an error in my formula? =SUMIFS({ManpowerPerTaskApp}, {ManpowerWorkingStart}, WEEKNUMBER($Date@row) =…
Archiving - Not Using Control Center
Some of our projects go on for a very long time. Each group has their own list of projects. We add status notes in the Comments. The status notes can get very long and cumbersome; however, they are very beneficial for the project history. My boss has asked to remove the status notes except for the current month and saved…
Smartsheets back-up (as a Smartsheet and not Excel)
Hello community, I would like to know how, over time, to back-up different versions of a smartsheet. I can see there is an automatic back-up, which backs up the smartsheet as an Excel. In order to keep track of different versions (as the formulas), I would like to know if its possible to back up a smartsheet as a…

Popular Tags

Trending in Smartsheet Basics

Is there a way to have a form update existing information?
We are conducting an audit of our I-9s. In order to do so, we have pulled an active list of all of our employees (EEs). These EE names are already on the sheet. In order to effectively complete the audit, there are specific things we need to check for based on the expiration date of the I-9 document that we have on file.…
Pulling info from Reference Sheet based on Date
Hello, I am trying to pull the information I need based on a date on the referenced sheet. Without this criteria the formula works great. this one criteria is not working. I created a helper column on each sheet. on the reference sheet is a formula to calculate the month number for that row, and then on main sheet is a…
Need help with Data/Chart Widget
I am working on a dashboard with various data points and had zero issues until I started the most recent widget. I am pulling from a simple report that has a list of staff members and their assigned work spaces. I keep getting an error that says the data cannot be charted… What is the limitation here? I made 4 other…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags