or Explore Discussions

# Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.

## Discussion List

• Help on IF Formula - Multiple Statements
In Formulas and Functions
Hi! I need some help on a IF Formula statement. On my sheet, I have a column that is using this equation - =IF([Total ALL Athletes and Unified Partners]@row = 0, "0", IF([Total ALL Athletes and Unified Partners]@row <= 5, &qu…
Accepted
20 3
Accepted Answer 20 views 3 comments Most recent by Mark Cronk Formulas and Functions
• Nested criteria
In Formulas and Functions
I have this formula but it comes back with a "nested criteria" error message: COUNTIFS([Business Unit]:[Business Unit], "MGS", Location:Location, "R6 (Orange County)", Stage:Stage, OR(@cell = "3 - Approve…
Accepted
15 3
Accepted Answer 15 views 3 comments Most recent by Mark Cronk Formulas and Functions
• Why isn't MAX returning the most recent DATE?
In Formulas and Functions
Hi All, I'm trying to use MAX to show the most recent date in column that's "Auto-number/System - Modified (Date)", but frustratingly it's not always correct. Anyone have any idea as to why? And more importantly, how to fix?
Accepted
17 3
Accepted Answer 17 views 3 comments Most recent by Mark Cronk Formulas and Functions
• Last Populated Cell in Column
In Formulas and Functions
Hello everyone, Hopefully an easy one! I have a set of eight fixed rows on SS. I have built out colums representing the fiscal weeks . . (ie) 2021-01, 2021-02, 2021,03 ect. Each week I add a number, or text, in the revelent column. I'm t…
15 1
Answered - Pending Review 15 views 1 comment Most recent by Mark Cronk Formulas and Functions
• Formula for quarter based on finish date
In Formulas and Functions
I want to create a formula that will auto-populate the Quarter column with Q1, Q2, Q3, or Q4 based on the date entered in the "Finish Date" column. For instance, if the "Finish Date" is 4/15/2021, I want the Quarter to …
20 10
Answered - Pending Review 20 views 10 comments Most recent by JeremiahHorstick Formulas and Functions
In Formulas and Functions
Hi Smartsheet Wizards, I need to create a formula for all assets completed in the fiscal year, by region - I have created the formula below and it works perfectly, but now I need to narrow it to count just a subset of asset types (from a …
Accepted
24 4
Accepted Answer 24 views 4 comments Most recent by Mark Cronk Formulas and Functions
• Can I conditional format specific cells only?
In Using Smartsheet
I only want the rows under my "STATUS" parent row to change colors. If status is less than 0, turn red. If 0 or greater, turn green. I figured out a workaround, but it's still turning other numbers in the column green. If I tr…
Accepted
30 2
Accepted Answer 30 views 2 comments Most recent by Lloyd Kim Using Smartsheet
• how to change the color of harvey balls
In Formulas and Functions
SOS Im missing something. I want to change the color of harvey balls based on a value. I wrote an if statement in a column that designated to be symbols but when I run the if statement it works but dosent change the color, it returns the…
13 3
Answered - Pending Review 13 views 3 comments Most recent by Andrée Starå Formulas and Functions
• Is there a way for me to craft a report to show the freq of usage of smartsheets across users?
In Using Smartsheet
Hi, I am looking to create a report to show the activity of smartsheets by licensed users and collaborators? I am particularly looking to gain insights on how frequently licensed users and collaborators are using smartsheets. Or even a da…
Accepted
19 4
Accepted Answer 19 views 4 comments Most recent by Andrée Starå Using Smartsheet
• How to group the rows by a field in the sheet summary
In Using Smartsheet
In a row report, how to group the rows by a field in the sheet summary?
Accepted
13 5
Accepted Answer 13 views 5 comments Most recent by Andrée Starå Using Smartsheet