Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
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
-
First post 08/17/19,Last post 08/18/19I am trying to set up a formula that counts the number of cells containing information in the first column on another sheet. I just don't want it to count the text that is in row 1 (ie I just want it to count from row 2 onwards as I am con…Formulas and Functions112kat_h -
First post 08/17/19,Last post 08/18/19I am working on a budget tracking sheet where I have a forecast column. The forecast column is dependent on if there is a value in an estimated cost column or actual cost column. If there is no value in the actual cost column, then the …Formulas and Functions141Tim Kuykendall -
First post 08/12/19,Last post 08/18/19I have admin access and have set the Gantt settings on a particular sheet to Primary heading: Months Secondary heading:Weeks I have shared the sheet with another user and given them Editor - can share permissions but they are seeing a…Using Smartsheet173c_griffin_DR
-
First post 08/14/19,Last post 08/17/19I know... the title sounds weird. I'll try to explain. I have a Workflow set up with the SFDC Connector. It's currently tracking all opportunities entered by the sales reps within a specified period of time that are staged as [OPEN]. My…Premium Apps and Integrations171Charlie.H -
First post 08/14/19,Last post 08/17/19Im looking for a formula that will allow me to index down through a number of children and count the number of decendents under that child. Any help?Formulas and Functions225SAB3012
-
First post 12/02/18,Last post 08/17/19Hello, I am trying to sum values from a reference sheet based on common criteria. However I am running into either "#INCORRECT ARGUMENT SET" or values that are not the exact sum as expected. My idea is to SUM the values from th…Using Smartsheet638RtchSS
-
First post 08/12/19,Last post 08/17/19EDITED TO ADD: I was able to figure out this morening w/ fresh eyes/brain and tested all scenarios which tested true: =IF(OR([STATUS]@row="Barrier",AND([Due Date]@row<TODAY(),NOT([STATUS]@row="Completed"))), "…Formulas and Functions82[email protected]
-
First post 08/16/19,Last post 08/17/19Hi Folks, Is there a way to get the full URL of the current sheet so that path can be put in to a cell using a formula?Formulas and Functions133Huntb2000
-
Closed [email protected] 29 views 2 comments 0 points Most recent by Lachlan Stead Archived 2017 PostsFirst post 10/25/17,Last post 08/16/19I have several sheets with forms. Each form has columns using drop down lists. When creating the drop down lists, there is a checkbox below that says: "Restrict to drop down values only". I do NOT have this box checked, but no va…Archived 2017 Posts292[email protected] -
ilene_healy68056 46 views 2 comments 0 points Most recent by ilene_healy68056 Formulas and FunctionsFirst post 08/16/19,Last post 08/16/19Dear Community I am having the hardest time debugging some #NO MATCH errors with my INDEX/MATCH formula. I have triple checked and can’t find any reason for things not to match. The rows right above and below work fine. I am pulling in…Formulas and Functions462ilene_healy68056
-
First post 08/02/19,Last post 08/16/19Hey There, I am new to smart sheet :) I want to use SmartSheet to... * ... get an overview over all projects that are going on in the team. * ... get an overview about the project status. * ... see how many resources are available (aka h…Using Smartsheet285BlackDevil
-
First post 08/15/19,Last post 08/16/19I'm having trouble putting together a correct formula or workflow to do certain tasks. I have a rent tracker spreadsheet and want a formula to basically say "When it's 30 days prior to the Rent Increase Date then automatically turn th…Formulas and Functions123chelsea
-
First post 08/07/19,Last post 08/16/19I am trying to return the earliest date in a Date Column where another column does not contain "Done". Simple statement, but I am completely flummoxed. Additionally, I need to return this date to a non-date column. I am using t…Formulas and Functions667Ben Donahue -
First post 08/14/19,Last post 08/16/19Hi, I have a sheet within parent/child rows, and need to count the number of unique contacts within each of the children rows of each parent. I have a vendor column that has a parent row and children row (only the children rows list the …Using Smartsheet323Crystal.Jaimes90511
-
First post 08/15/19,Last post 08/16/19Good Morning Smartsheet Community, I have having a couple of issues regarding the nested If logic against Date data and having the RGY ball symbol output. Here is my request: 1. First column of dates * If the Date is over Today(-365), …Formulas and Functions205vnjeffery96856 -
First post 08/15/19,Last post 08/16/19I am creating a report using data from 5 different sheets. All 5 sheets use the same columns, including a primary column called Project Name. The column has data in on all 5 sheets, however this data is not showing in the report. Interest…Using Smartsheet173Bonnie du Plessis
-
First post 08/15/19,Last post 08/16/19Hi, I need to have 2 upload fields on my smartsheet (1 for a logo and the other for photos). Can you please assist in helping me get this built. - KyraUsing Smartsheet195kkoncar
-
First post 08/15/19,Last post 08/16/19Is it possible to group by a column in reports like Excel does? I need to create a report that groups projects by OKR/Goal and then by Project. So management wants to see how many projects are there per OKR.Using Smartsheet624Bonnie du Plessis
-
First post 06/13/18,Last post 08/16/19I want to use the formula: =TEXT(*CELL WITH DATE*,"mmmm") But this doesn't seem to be a valid formula on Smartsheet. So if I have a cell with the date "01/01/19" - I want it to show "January" in another ce…Formulas and Functions2977AGillespie -
First post 11/08/17,Last post 08/16/19Hi, Is there any way to edit the rules in conditional formatting? For example, if I have a rule that has 10 conditions, is there any way to go into the rule and delete one of the conditions? Example: If column 1 is 'yes' and column …Archived 2017 Posts327ogonzalez
-
First post 08/15/19,Last post 08/16/19Hey there! I'm trying to find a way to reference data from one sheet into another, with a formula that will count some metrics to display on my dashboard. I've managed to do it for counting task status for the whole project but am struggli…Formulas and Functions145siofra.keane98086
-
First post 08/14/19,Last post 08/16/19An employee retired without transferring his sheets and reports, that are in various workspaces and folders, to me. How do I keep the sheets and reports in the same workspace and folders while transferring ownership to me? I'm SysAdm and l…Using Smartsheet161Just Jean
-
First post 08/14/19,Last post 08/16/19How can I get sheets to remain in the workspace/folder when bulk transferring a user's sheets to someone else?Using Smartsheet171Just Jean
-
First post 08/16/19,Last post 08/16/19Hello everybody, I'm a licensed user and want to change the color of the sheets and the company logo. When I click in the account the "Personal colors and logo.."button and pop up window opens and want to upgrade me. As I don't …Using Smartsheet163hpb
-
First post 08/15/19,Last post 08/16/19Hello! I have a project I am working on where I've created a little bit of a manual schedule that I'm integrating into a smarter excel sheet, but I'm struggling with a formula to duplicate information. I've attached a screenshot below …Formulas and Functions2611hildegrant
-
First post 08/15/19,Last post 08/16/19Is there a way to exclude tasks/rows from the % Complete Calculation?Using Smartsheet171KBeem
-
First post 08/15/19,Last post 08/16/19Hello, I have several date columns that track the scheduled release dates of a product in various territories. I'd like to have a formula in a field that looks at each of the columns that have dates and returns a string that allows for a…Using Smartsheet191mitch.steele100316
-
First post 08/16/19,Last post 08/16/19I need your help regarding to inactivity period. I saw that minimum activity time is 1 minute. But this time is so much for us because we are planning to use as 4 user and we want to auto save time is at least for example 15-20 second…Using Smartsheet104sebahat
-
First post 08/14/19,Last post 08/16/19I want to create a form that is a quiz. For some of the questions I want to have a picture where the quiz taker is asked to look at a picture and then answer a question about the picture. Is there any way to have a picture appear in the c…Using Smartsheet753Chuck Mihaliak
