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
-
How do i write the following formulaAccepted AnswerAccepted Answer SharonR 44 views 2 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/18/20,Last post 02/18/20I am trying to write a If-nested formulas that works out the following. What i am trying to say with this formula is the following: IF the status is Complete and the planned end date is today or within five working days = Green IF the sta…Formulas and Functions442SharonR -
COUNTIFS, OR with three reference columnsAccepted AnswerAccepted Answer maberry34826 62 views 2 comments 0 points Most recent by maberry34826 Formulas and FunctionsFirst post 02/18/20,Last post 02/18/20I'm trying to test for three conditions with a COUNTIFS. One column consists of status checking for "70", the next two columns are dates that must be populated or other functions will not produce correct data. Count If, Status…Formulas and Functions622maberry34826
-
Issue Sorting by TimeAccepted AnswerAccepted Answer Michael Shubeck 35 views 4 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/13/20,Last post 02/18/20As many are aware, the "sort by time" function is not (yet) available in SmartSheet as it is in Excel. Essentially SmartSheet treats time sequentially as opposed to recognizing AM/PM. So sorting a time field would, for instance…Formulas and Functions354Michael Shubeck -
concatenating if statementsAccepted AnswerFirst post 02/18/20,Last post 02/18/20Hi Guys, First post and would really appreciate your help. I am trying to combine multiple if statements in one cell. I am not looking for AND / OR support but how I can return multiple values. IF([Bananas]2 = "x", [Bananas]1 + &…Using Smartsheet142Jag Johal
-
First post 08/13/19,Last post 02/18/20Hello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line dedicated to the class. We can teach as…Formulas and Functions10814MattSederquist
-
Smartsheet Search Bar Pop-Up WindowAccepted AnswerFirst post 02/13/20,Last post 02/18/20I was hoping to see info on the new Search bar pop-up that's now in Smartsheet. **Is there a way to turn it off, please? **Or at least once we hit "Ok" for the cursor to automatically return to the spot in the search bar where …Using Smartsheet134Loann McGee -
Sheet ownership was transferred without a requestAccepted AnswerAccepted Answer Dale Heincelman 15 views 7 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 02/14/20,Last post 02/18/20I believe there was a side effect to a mistake I did. Our structure is one workspace for all of our projects, with each project in a separate folder. I mistakenly removed sharing of my coworkers at the sheet level that were shared at the w…Using Smartsheet157Dale Heincelman
-
Accepted Answer Karen Stulc 46 views 2 comments 0 points Most recent by JReisman27 Formulas and FunctionsFirst post 02/17/20,Last post 02/18/20Hi, I am developing a project plan for a global team. I have built a project plan that shows the start and end times in PST but other team members would like to see when a task is going to be triggered in their local time zone. In MS Pr…Formulas and Functions462Karen Stulc
-
Cross-Sheet COUNTIFS helpQuestionAnswered - Pending Review System 22 views 2 comments 0 points Most recent by Alejandra Formulas and FunctionsFirst post 02/17/20,Last post 02/18/20This discussion was created from comments split from: COUNTIFS Referencing Other Sheets.Formulas and Functions222System -
Counts of values in a multi-select columnAccepted AnswerAccepted Answer Shawn Borror 42 views 4 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 02/13/20,Last post 02/18/20I'm trying to count the number of values in column that allows for multi-select. In this case, column is Contract Type - and the request can involve multiple contract types...I'd like to be able to count/total individual the types of cont…Formulas and Functions424Shawn Borror
-
Answered - Pending Review Stacey Grey 22 views 1 comment 0 points Most recent by Eric M Oliveira Formulas and FunctionsFirst post 02/10/20,Last post 02/18/20We are using the following formula in a project sheet: (TODAY()-StartLine#)/DURATIONLine# Example Schedule Activity Setup: Task Name - Start Date - Finish Date - %Complete - Status - Duration - Calc In the Calc column, is the above formula…Formulas and Functions221Stacey Grey
-
Creating templates correctlyAccepted AnswerAccepted Answer Julie Hill 23 views 16 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 02/17/20,Last post 02/18/20Hi, I created a template for expense reports in order to create specific expense reports per job (I film destination weddings). 2 weird things are happening: 1) When I send my employees the form to the report to fill out as they go, it…Using Smartsheet2316Julie Hill
-
=AVG functionAccepted AnswerFirst post 02/12/20,Last post 02/18/20I'm trying to get an average sales total for 2020. We are only on week 7 but it counts ALL 52 and averages it out. How can I get the function to work so it only averages the current week and prior weeks?Formulas and Functions222ginamt3
-
What day of the week does the weekly back up occur?Accepted AnswerAccepted Answer David Soto 25 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 02/17/20,Last post 02/17/20Does it start on the day of the week you initiate the back up or on a day that Smartsheet has picked? ThanksUsing Smartsheet253David Soto
-
Combining a Symbol & NumberQuestionAnswered - Pending Review Lisanne Schliemann 44 views 1 comment 0 points Most recent by cmondo Formulas and FunctionsFirst post 02/17/20,Last post 02/17/20Hello, I have a column that calculates Q/Q growth and displays it as a percent. The next column shows that as a symbol based on an if statement. For example, Q/Q growth is -61%, then the down arrow is displayed. I'm building a dashboard, w…Formulas and Functions441Lisanne Schliemann
-
Date (Less Then)QuestionAnswered - Pending Review Jasmin Shah 13 views 2 comments 0 points Most recent by Jasmin Shah Using SmartsheetFirst post 02/14/20,Last post 02/17/20I am currently working on a smartsheet. Is there a way in a report to have dates that is someting create a certain date. For instance, I have a ticket that need to be shown on a report that is older then three days. How would I do this ?…Using Smartsheet132Jasmin Shah
-
Week number @row functionAccepted AnswerFirst post 01/31/20,Last post 02/17/20https://us.v-cdn.net/6031209/uploads/571/TY4ICAHM5EB3.png Is there a more efficient way I could write this formula? I'm looking for the week number and I physically have to go in and change it for each cell. I would like so I can just copy…Formulas and Functions655ginamt3
-
Publishing and Google Search indexing and crawlingAccepted AnswerFirst post 02/11/20,Last post 02/17/20Business and Enterprise users can publish a sheet, report, or dashboard. My question is can these pages be discovered by Google Search indexing and crawling? These are the options I refer to: https://us.v-cdn.net/6031209/uploads/838/W1JO7W…Using Smartsheet655Mary_A
-
Answered - Pending Review Claire Kennedy 23 views 1 comment 0 points Most recent by Josh Strong Premium Apps and IntegrationsFirst post 02/14/20,Last post 02/17/20I am really struggling to make this work in my project. I have a calculation formula which turns the sprint estimates into a number. E.g 1 = 14, 2 =28, 3 = 42 etc I am trying to get the duration column to pick this up nd hence give me the …Premium Apps and Integrations231Claire Kennedy
-
Answered - Pending Review Dainius 25 views 2 comments 0 points Most recent by Dainius Formulas and FunctionsFirst post 02/17/20,Last post 02/17/20Hello, Maybe someone could help with formula preparation. Example: I have a task that lasts for several months (06.02.2020- 18.04.2020). How to calculate a numbers how many days task took per specific month (separately for FEB, MAR, APR)?…Formulas and Functions252Dainius
-
First post 02/07/19,Last post 02/17/20Is it possible for a single user to have access to multiple Smartsheet accounts with the same login? If so, is it possible to login to one account and then switch to the other account .Using Smartsheet1003jond17
-
Automatically Move Row TriggerAccepted AnswerFirst post 02/07/20,Last post 02/17/20It seems that it is not possible to move a row based on a formula or date. I'd like to move it daily based on status rather than immediately. (Why, because people make mistakes.) Is there any way to do that inside of Smartsheet (no third…Using Smartsheet275ker9
-
Deleting questions in Smartsheet CommunityAccepted AnswerFirst post 02/17/20,Last post 02/17/20Hi, What is the process of deleting questions and posts that I have started on Smartsheet community?Using Smartsheet125sahilhq
-
Last Row Created URL ParameterQuestionAnswered - Pending Review Mike Jones 13 views 1 comment 0 points Most recent by Genevieve P API & DevelopersFirst post 02/13/20,Last post 02/17/20Is there a URL parameter that will get the last row created? Is there a list of URL parameters?API & Developers131Mike Jones
-
SUM function not working on cells with formulaAccepted AnswerAccepted Answer Dora Berky 49 views 3 comments 0 points Most recent by Dora Berky Formulas and FunctionsFirst post 02/13/20,Last post 02/17/20Hi, I faced an issue with the SUM function, since it seems to not work on a column in which the cells contain a formula to return a number. The cells that i want to SUM contain (JOIN(COLLECT)) formulas that pull data from another sheet. Wh…Formulas and Functions493Dora Berky
-
Answered - Pending Review Christine Rosenberg 23 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 02/07/20,Last post 02/17/20We have a list of customers, where the invoice changes from month to month according to use of specific items. Example: Customer A will in January pay for 2 item Y, 0 zero item X, and in February pay for 3 item Y, 0 item X and in March …Using Smartsheet233Christine Rosenberg
-
Resources are not always showing up Resource ViewsAccepted AnswerAccepted Answer Richard Heath 28 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 02/13/20,Last post 02/17/20I've been successfully utilising the Resource Views capability for 6 months. Today I noticed that a number of Workspaces are not reporting through to the Resource Views. Each workspace our company uses, utilises a simple Gant Chart with Re…Using Smartsheet283Richard Heath
-
Copy Sheet Summary Fields to Different SheetAccepted AnswerFirst post 02/13/20,Last post 02/17/20Is it possible to copy sheet summary fields to a different sheet using automation?Using Smartsheet226ker9
-
Answered - Pending Review Alan Sun 13 views 1 comment 0 points Most recent by Genevieve P API & DevelopersFirst post 02/15/20,Last post 02/17/20Hi There, We are checking API to revoke licenses for existed users. How can transfer the content owned by the user to another? Then, we can remove the licenses. BRs,API & Developers131Alan Sun
-
Email Forms not working to contacts listAccepted AnswerAccepted Answer Trevor Ford-Batey 22 views 4 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 02/12/20,Last post 02/17/20Hi I am a new user to Smartsheet and I have an individual licence. The forms allows me to preview and send to myself as it does on the free trial. The form is to collect Supplier quotes for products we are asked to provide and each suppli…Using Smartsheet224Trevor Ford-Batey
