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.

Estimated Durations
I ma moving from Microsoft Project to Smartsheet and trying to replicate workflows that have served me well for decades. In Microsoft Project, I can indicate that a duration is a estimate by including a question mark, for example 5d?.I use this heavily as placeholders when building a plan so that I know that I need to get…
Values across different tasks for Dashboard?
Hi, I have a big sheet (called "Test")that have a lot of tasks that have the same type and number of subtasks. All subtasks have an "assigned to" column (contact list) and all subtasks are among three typs: not started, in progress or complete. I created a separate sheet (called Test.metrics) that roll up all "assigned to"…
Workspace to folder
Hello We have created a Project Template Set which is structured in a Workspace. Is there a possibility to quickly change the Workspace template set to a Folder template set? Kind regards, Rdp
duplicates of smartsheet where we ourselves can color our duplicate without making changes in the ma
Hi Can I: Duplicate a smartsheet where we ourselves can color our duplicate smartsheet without making changes in the master smartsheetet? Best regards Jacob
CountIfs- How many of one name in a date range
I have - a column containing start dates, that spans 2019 a column containing an assortment of names that re-occur on a random basis. I want to count how many times each name occurs each month. Any help appreciated!
"COUNT" function with link to another sheet
I'm trying to set a "count" function to count the number of records in a specific column of another sheet, in order to allow a continuous screening of the recordings in that sheet. But the function can't be set as long as the targeted column is still empty. Is there any possibility to overcome that issue? Or even could it…
Requiring Approval when Dates Change
Hello community - I currently have an approval request enabled that notifies me via email once a day whenever a date in the Due Date column is changed. I also have a dashboard that shows me whenever an approval is needed and would like to eliminate the emails coming in to advise me. Is there a way to set up a column that…
countifs formula to sum not blank dates
Hello ~ I'm new to the community and working with the COUNTIFS formula. Help would be much appreciated if you can see the error of my ways. What I want to do seems simple - I have a "Date Completed" column, defined as a Date type, and want to count how many times it's been entered in the column. I saw a thread earlier that…
New plan items: how to avoid start (and finish) dates in the past
Hi all - I'm a relatively new user and a little stumped figuring out how to best handle this scenario: 1) A project sheet has dependencies are enabled. 2) The project team identifies a new task they want to track; that task is ready to start (there are no dependencies). 3) The task is added to the sheet with an estimated…
Administration controls
Greetings, I am looking for advise. I am new to Smart sheets and my Operations manager no longer works for my company and she is setup with all of the administrative controls. I need to gain administrative control of the account. can anyone assist me in this?

Popular Tags

Trending in Smartsheet Basics

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…
Percent showing up in thousands
Hello, why is my 32 showing 3,200% instead of 32%
Remove workspace shared users from 1 sheet
We are working on setting up our Career Reviews in Smartsheets. We have a group of all staff that has access to all sheets in our workspace. I want to remove them access from just the Career Review Sheets. When I do that it says it will remove them from access to the entire workspace, which is not what we want. The only…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags