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.

Countif for 2 different value under same column?
I am using this but showing "Invalid Operation: =COUNTIF([Current Overall Status]:[Current Overall Status], "QA") + =COUNTIF([Current Overall Status]:[Current Overall Status], "UAT") I am trying to count the total tasks that are in either QA or UAT. HELP! Thanks, Rafsun
Trying to build a sheet that will total data from 35 sheets
I have 35 customer sheets built. I want to build a sheet that will total everything from these sheets to the Total sheet. After I get so far I get the error message : Unable to create a cross sheet reference because this sheet already contains the maximum number of different cross sheet references. I was only at 15 cross…
Numerous issues in last few days
Have others been experiencing any unusual activity in the past few days? I have been having a number of issues that appear to be related to permissions and reports e.g. A report we use daily suddenly showed a permission error for one of the users in the team although their permissions have not changed and they are owner of…
Notificatons no longer working
I have been successfully using the same smartsheet as a tracking system for almost a year. Recently I have realized that no one is receiving their notifications for one particular notification rule. It is not specific to one user not receiving notices, so there must be something wrong with the rule. But I have looked it…
Want to calculate the total number of Completed Tasks changes since last week.
Hi, I have total of 1200 tasks and 3 Assignees and I need to count : ( I want to create a Mini Dashboard on the top of my Task Sheet) 1. Total Number of 'Completed' by All 3 Assignees, 2. Total Number of 'Completed' by each of my Assignees. 3. How many tasks have been selected 'completed' from my "Task Status" column since…
Drop Down in Form
Hi , Can someone help me.. Will I select a option in Forms ( Tax applicable- Yes or No) If I click on Yes I should populate bring Country option to select and when I select No..its should not populate country option..
Formula Permision Error
Yesterday I pulled up a sheet that is pulling information from other sheets owned by someone else with no issues at all. Today I pull up that sheet and all of the cells referencing the other sheets have Permission Errors in them. I still have edit rights to those sheets... I have edit access to all the sheets. The only…
Dropdown lists not working within Reports
Is there a fix to make dropdown lists work with the reports. My main smartsheet has dropdowns that work fine...but those same cells show up as empty cells on reports. Any help would be appreciated
Project Status Reports
Hi All, In our PMO function we are looking to create project status reports in Smartsheet that would be a 1 page for a PM to update RAG, finance outlook, comments etc. We would have 1 sheet per project, that we could then roll up into a report and query in Tableau for board reports. Has anyone got a good example of this…
Applying Formulas to Entire Columns
Hello there, I'm new to the community. Our company has adopted SS for projects and we're now looking to expand the use to HR, specifically starting with leave requests. I've started a leave request sheet based on the template below, with a few adjustments geared toward my company.…

Popular Tags

Trending in Smartsheet Basics

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…
Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags