## Forum Stats

• 38,174 Members
• 20,426 Discussions

# Recent Discussions

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

• Closed Alejandra 1 view 0 comments Started by Alejandra Using Smartsheet
First post 04/10/20,Last post 04/10/20
This discussion has been moved.
Using Smartsheet10
Alejandra
• SUMIFS with 2 FactorsAccepted Answer
Accepted Answer Susan Swisher 13 views 8 comments Most recent by Paul Newcome Formulas and Functions
First post 04/10/20,Last post 04/10/20
I am trying to create a formula to SUM a COLUMN/RANGE (Column Title: Budget Requested), IF a BOX is checked in another Column (Column Title: Approved). Keeps returning #UNPARSEABLE 😑
Formulas and Functions138
Susan Swisher
First post 04/10/20,Last post 04/10/20
Hi, I just wanted to know if the recent enhancements of smartsheet has increased the character count per cell? I want to use nested if for around 70 products, satisfying each product name and I think that nested if is going to exceed the l…
Using Smartsheet155
• Closed Alejandra 1 view 0 comments Started by Alejandra Formulas and Functions
First post 04/10/20,Last post 04/10/20
This discussion has been moved.
Formulas and Functions10
Alejandra
• IF/MatchQuestion
Answered - Pending Review kari1282 25 views 1 comment Most recent by Paul Newcome Formulas and Functions
First post 04/10/20,Last post 04/10/20
Good afternoon, I'm having a problem with the below formula. I'm trying to do a formula that will check Invoice numbers on two sheets. If they match it will say yes, and if there is no match it will say no. However I'm getting Invalid Dat…
Formulas and Functions251
kari1282
• Closed Alejandra 1 view 0 comments Started by Alejandra Using Smartsheet
First post 04/10/20,Last post 04/10/20
This discussion has been moved.
Using Smartsheet10
Alejandra
• Closed Alejandra 1 view 0 comments Started by Alejandra Formulas and Functions
First post 04/10/20,Last post 04/10/20
This discussion has been moved.
Formulas and Functions10
Alejandra
• Closed Alejandra 1 view 0 comments Started by Alejandra Using Smartsheet
First post 04/10/20,Last post 04/10/20
This discussion has been moved.
Using Smartsheet10
Alejandra
• Elisabeth 74 views 10 comments Most recent by Paul Newcome Formulas and Functions
First post 11/20/19,Last post 04/10/20
Hello community, I need your help on this report. The solution is probably very easy, I just cannot get my head around it. I have a project plan with one column "Flag" (lines can be flagged with the little red flag) and a colum…
Formulas and Functions7410
Elisabeth
• Answered - Pending Review Mark McLean 11 views 4 comments Most recent by Paul Newcome Formulas and Functions
First post 04/10/20,Last post 04/10/20
I am developing an equipment tracking smartsheet.  One of the columns indicates the estimated lead time for delivery.  I would like to "bucket" the lead times into ranges:  0-60, 61-90, 91-120...etc. Thoughts on how to best achie…
Formulas and Functions114
Mark McLean
• Answered - Pending Review Julia C Peterson 26 views 1 comment Most recent by Paul Newcome Premium Apps and Integrations
First post 04/10/20,Last post 04/10/20
I used to use Formstack but my company is switching over to Microsoft Forms. I'm having an issue where I get a Microsoft Flow error message when I try to map the Forms Timestamp to a smartsheet column that is "Date" format. This …
Julia C Peterson
• Jeana 22 views 0 comments Started by Jeana Using Smartsheet
First post 04/10/20,Last post 04/10/20
I'm looking for a workaround for this. I understand that with recourses turned on I can't put formulas in the Start and End Date. I have other columns that I'm using with formulas to calculate dates that I need. Is there any way to use Res…
Using Smartsheet220
Jeana
• Closed Alejandra 1 view 0 comments Started by Alejandra Formulas and Functions
First post 04/10/20,Last post 04/10/20
This discussion has been moved.
Formulas and Functions10
Alejandra
• Closed Alejandra 1 view 0 comments Started by Alejandra Using Smartsheet
First post 04/10/20,Last post 04/10/20
This discussion has been moved.
Using Smartsheet10
Alejandra
• Closed Alejandra 1 view 0 comments Started by Alejandra Formulas and Functions
First post 04/10/20,Last post 04/10/20
This discussion has been moved.
Formulas and Functions10
Alejandra
• Closed Alejandra 1 view 0 comments Started by Alejandra Using Smartsheet
First post 04/10/20,Last post 04/10/20
This discussion has been moved.
Using Smartsheet10
Alejandra
Accepted Answer Jason Egles 24 views 9 comments Most recent by Paul Newcome Formulas and Functions
First post 04/09/20,Last post 04/10/20
I have been able to get YTD results with this formula: =COUNTIFS({DATE SOLD}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))) However, I am unable to get a formula right for MTD. Any assistance would be much appreciated Thanks, Jason
Formulas and Functions249
Jason Egles
• Answered - Pending Review Darla Brown 12 views 11 comments Most recent by Paul Newcome Formulas and Functions
First post 04/09/20,Last post 04/10/20
Hi everyone! Hope you are all well and somewhat sane :) I need help with this formula and I'll explain the meaning: =COUNTIFS([Issuance Date]:[Issuance Date], <=MonthHelper\$1, [Cardmember Status]:[Cardmember Status], "ACTIVE ACCOUN…
Formulas and Functions1211
Darla Brown
• Answered - Pending Review Jennifer Cosgrove 12 views 3 comments Most recent by Andrée Starå Formulas and Functions
First post 04/09/20,Last post 04/10/20
I need help with the formula for my sheet. I need the symbol to change color if I change the status. In progress = blue Complete = green Ongoing = yellow Need confirmation = red https://us.v-cdn.net/6031209/uploads/065/Y80KB61VXANP.png
Formulas and Functions123
Jennifer Cosgrove
• Accepted Answer Amy Arnold 42 views 13 comments Most recent by Paul Newcome Formulas and Functions
First post 03/21/20,Last post 04/10/20
Hi, I created a form to collect survey results, the responses are returned to Smartsheet #1 (image below). The survey has 18 questions with these dropdown (single select) responses: Good Satisfactory Does Not Meet Standards Not applicable…
Formulas and Functions4213
Amy Arnold
• Accepted Answer JessMK 13 views 6 comments Most recent by Debbie Sawyer Premium Apps and Integrations
First post 04/07/20,Last post 04/10/20
I need to create a Spreadsheet/report/calendar of team members who are free/unassigned to projects on each day. Most of our projects are events that take place on certain days and we often need to figure out if we can accept requests based…
JessMK
• Answered - Pending Review Netanel yosef 91 views 7 comments Most recent by Andrée Starå Using Smartsheet
First post 02/09/20,Last post 04/10/20
i have sheet with parent and children tasks and in my report i want to see the children tasks with the parent row. when i try to do this i show only the children.. there is any way to show chldren tasks with parents in report>??
Using Smartsheet917
Netanel yosef
• Accepted Answer Lauren Smith 16 views 1 comment Most recent by Paul Newcome Using Smartsheet
First post 04/10/20,Last post 04/10/20
What does everyone use for the Health Status Color for Completion of a task? My company is debating the following and '-' are my thoughts. Leave the color green on completed task - NO because green indicates good health and there is no …
Using Smartsheet161
Lauren Smith
• ZenTekDS 212 views 3 comments Most recent by Andrée Starå Using Smartsheet
First post 06/28/19,Last post 04/10/20
Maybe we're just doing something wrong, but it seems like it's only possible to upload or take a single picture at a time using the SmartSheets mobile app. Is there a way to upload more than one at a time? Is this in the works by chance?
Using Smartsheet2123
ZenTekDS
• SIRI / Voice AssistantsAccepted Answer
Accepted Answer Sharon Knuth 18 views 3 comments Most recent by Andrée Starå Using Smartsheet
First post 04/07/20,Last post 04/10/20
Good afternoon. Is anyone familiar with how Smartsheet works with voice assistants? More specifically, can I input a new task into Smartsheet with Siri?
Using Smartsheet183
Sharon Knuth
• Answered - Pending Review JLH 100 views 9 comments Most recent by Andrée Starå Using Smartsheet
First post 03/20/20,Last post 04/10/20
Hello - I need to find a way to have a Date field default to the current date on a Form. (I can't use the systen-date field, as user needs to be able to override 'todays Date' if necessary) Unfortunately, selecting the obvious Da…
Using Smartsheet1009
JLH
• Accepted Answer Chantelle Ballesteros 32 views 9 comments Most recent by Andrée Starå Formulas and Functions
First post 04/03/20,Last post 04/10/20
Hi! I am trying to create a sheet summary that counts multiple items in one column. for example: =COUNTIFS([policy_name]:[policy_name], "package B", [policy_name]:[policy_name], "Package C") but it gives me 0. Is there …
Formulas and Functions329
Chantelle Ballesteros
• BarneeL 155 views 5 comments Most recent by Paul Newcome Formulas and Functions
First post 07/31/19,Last post 04/10/20
Hi there, Is there a way that I can build a report so that when a new sheet is added to a smartsheet folder, the contents of the sheet then automatically gets compiled into a report? I saw that it was possible to select a folder when bui…
Formulas and Functions1555
BarneeL
• Answered - Pending Review JonEric Eubanks 24 views 3 comments Most recent by Andrée Starå Formulas and Functions
First post 04/02/20,Last post 04/10/20
Im to do a countif formula across sheets. I keep getting errors. I'm trying to find "Fire" in one column and the City in another Column. I used =COUNTIFS({Test FR Data Range 15}, "Fire", {Test FR Data Range 11}, "A…
Formulas and Functions243
JonEric Eubanks
• 10,000ftQuestion
Answered - Pending Review Sid Richardson 22 views 3 comments Most recent by Andrée Starå Using Smartsheet
First post 04/08/20,Last post 04/10/20
What is the timeline for integration with 10,000ft?
Using Smartsheet223
Sid Richardson