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.

Lock Columns
Is it possible to block different columns for different people? There is Person A and B and there are columns 1-2-3-4-5-6, Person A can edit info on columns 1-2-3 but has columns 4-5-6 lock Person B can edit columns 4-5-6 but has column 1-2-3 lock If not, what can be a solution for it?
Utilizing a Checkbox in a sumifs equation
Unable to resolve a SUMIFs utilizing a checkbox as a trigger in another sheet. attempted to paste screenshot of formula here with no luck. Unparseable is the only result i can get please help Craig
Group Permissions in a Workspace vs. a Report
Hey all, I have a group in SS that needs to be able to edit a report but shouldn't have edit abilities for the entire Workspace. I have set them as viewers to the Workspace and Editors for the reports. However, they seem to not be able to edit the fields in the reports. Is there any way to accomplish this or do they need…
Smartsheet Mobile Team Needs Your Help!
Hi Smartsheet Community, My name is John Zoshak and I'm a product manager at Smartsheet for our mobile apps. We're looking to do some work on our app-navigation / home screen experience and I'm looking for a few customers to chat with about the current experience. It would be no longer than 30m and your feedback would go…
Importing Rules with Gantt from MS Project
Hi there! I imported my gantt from MS Project straight into Smartsheet but the end dates seem to be off by quite a bit, it isn't copying exactly in as I need it to. I then realised that have some rules in my MS Project that may not have carried over to my sheet. So currently in my MS Project gantt I have rules applied for…
Update requests to more than a person
Hi all, I have a spreadsheet that has set up an "Update request". Now, that same update request was set up to notify both myself and my colleague (since i was on annual leave recently, so nothing was getting left behind). What happens is, since there are 2 people in the automation, the update request only gets cleared…
Creating a bug burndown dashboard in Smartsheet
Hello, We are currently using the SmartSheet + JIRA connector which allows us to export JIRA stories to SSheet and have bi-directional editing capabilities of both sources of data. This works great and allows team members (like our QA team) who do not have JIRA accounts to update their SSheet and the changes are…
many activity logs in one place?
Hi. Does anyone know a way to see the "activity log" from many sheets in just one location? This would be like a report or a dashboard.
User attachments
Hi, My team members are unable to attach files under the Individual Plan. According to the Smartsheet features attached, I should have this feature on my plan. Thanks, Kyle
pdf and excel files into multiple sheets via Gantt?
Hi there, trying to make a production line more efficient and I need to attach a file to each order (each order is a separate row). We run off of multiple sheets, and have reports broken down to each department. For example: Main Sheet: Gantt Production - includes all orders (which are linked to multiple reports) Report:…

Popular Tags

Trending in Smartsheet Basics

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?
Multiple Users in Grid
Hello. I am trying to create a tracker where there will be multiple users in a Grid sheet and everyone will be adding in a new line at random and same times. Is there a way I can create it where people's work won't save on top each other? Or is there a live view on Smartsheet where other people can see that someone else is…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags