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 11/12/19,Last post 11/14/19Hi, We have an order intake sheet that has an "Order Date" column and a Status Column. One of the ten selectable statues is "Complete" What is the formula that I can use in a flag column to say - Flag any with an Orde…Formulas and Functions537Actual Goodfella -
First post 11/14/19,Last post 11/14/19We cannot set automated reminders after minutes. Our need: Send email if row has not been modified within 30 minutes of created. We also can't calculate in minutes with a formula? Just seems like a huge oversight.Formulas and Functions141ShawnTerry -
First post 11/08/19,Last post 11/14/19I am looking as to why during one of the last updates in Smartsheet when using Send to Contact in a Cell in Alerts we no longer see the reference column detail under Recipients in the Manage Workflows Pane. My users are questioning who get…Using Smartsheet412Ella -
First post 11/13/19,Last post 11/14/19Hi, I just created a new form in google forms and when I try to sync with smartsheet I get this error: Error: Start Send (create sheet): Exception: No item with the given ID could be found, or you do not have permission to access it. Bo…Using Smartsheet451Amelia Karlsson
-
First post 11/14/19,Last post 11/14/19I would like to recommend an additional option to swap the red and green arrows so that there is an option for red arrow = up and green arrow = down. This is helpful for budgeting in project management where at a quick glance you can see …Using Smartsheet251volchic16
-
First post 11/12/19,Last post 11/14/19I have never had an issue provisioning projects. As of yesterday, myself and another PM that I have given privileges to provision have encountered the same error. Something did not go through! Please check your network connect and try ag…Using Smartsheet161LeeAnn_F -
First post 11/13/19,Last post 11/14/19Is there a way to remove sub-rows from formula tracking? Ex: We want to track the general Task but not the detailed items below that task. Can we do this with a formula and generate a single metric number? Thanks for all the help!Using Smartsheet172Sarah_Michael
-
First post 07/22/19,Last post 11/14/19Is there a way to get the parent row to indluce sum of parent plus children? We use a JIRA connector, and the team bills hours to the parent or Epic, as well as the Stories and Tasks with that Epic Link. As another screwball, JIRA reports …Formulas and Functions275jonathan.beaty91616
-
First post 11/05/19,Last post 11/14/19Hi, I'd like to add an auto number column, but I would like to set the specific range in numbers. For example, I need the auto numbers to be between 0 and 250 without duplicating. Is there a way to set those limits? Thanks. Jay DuqueUsing Smartsheet234Jay Duque -
First post 11/03/19,Last post 11/14/19Hi Smartsheet community, I am looking for formulas or ways to automatically fill sheet B with the information of certain columns of sheet A for all rows in sheet A that contain a value. In a dynamic way, meaning if a row is added to sheet…Formulas and Functions254Elias_NIO
-
First post 11/05/19,Last post 11/14/19Is there a way to place drop down lists on the dashboard yet? Need direction..Using Smartsheet783marine8888
-
First post 11/05/19,Last post 11/14/19Hi there, I've set up multiple automated emails as part of the workflow process, and have just noticed that the dates contained in the automated emails are in the incorrect format, despite me setting my regional preference in the settings…Using Smartsheet353Colin_G
-
First post 11/08/19,Last post 11/14/19As the resource view in resource management is only viewable by licensed users, and is in days, I'm interested to hear from other users how they were able to export data to excel and calculate for a week or month view. I've tried to expor…Using Smartsheet1185B.Germain
-
First post 11/05/19,Last post 11/14/19I would like to be able to automatically populate rows in a sheet based on the change in status in another sheet. For example, if I have a spreadsheet of jobs I'm bidding on that has a column with dropdown options of "Bidding", …Using Smartsheet465Horace
-
First post 11/13/19,Last post 11/14/19Is there a way to increase formula reference data. The default restriction is 25k cells and i'm exceeding this (Image)Formulas and Functions171Dicko
-
First post 11/14/19,Last post 11/14/19Hi All I know how to lock a row when a certain condition (or a set thereof) is met. But is there a way that when a row gets auto-locked, all its child-rows also get locked automatically? In other words, some kind of inheritance mechanis…Formulas and Functions301[email protected]
-
First post 11/13/19,Last post 11/13/19I am using a this Vlookup formula =VLOOKUP([Capex APR# / Opex WBS]1, {array}, 4, false) This formula works ok and looks at data in the one sheet {array} due to the amount of data, two sheets are now required to be looked at by the form…Formulas and Functions132Dicko
-
First post 11/13/19,Last post 11/13/19I am new to cross sheet formula's and a formula that works locally on a sheet, I am trying to cross reference so that the data that I successfully found will be on another sheet. Here is the formula that I used on the local sheet =COUNTIF…Formulas and Functions471Billy-Rock
-
First post 11/08/19,Last post 11/13/19I have three different gantts with some summary data that is fed into the main project data sheet. Only one of the gantt sheets is used in a project, so I thought of linking each of the gantts' data (exact same field/cell in each sheet) to…Formulas and Functions251Ezra -
First post 11/13/19,Last post 11/13/19Hi, I have two sheets for 2 separate processes in our production workflow. For each of the sheets I have forms for people to fill out. I would like to have it where the 2nd sheet is able to pull data from the first sheet. The 2nd sheet ne…Using Smartsheet362ScionoftheNight
-
First post 11/13/19,Last post 11/13/19I want to make a simple dashboard pie chart. I have a pipeline worksheet and I am setting up the COUNTIF formula but I keep getting the #UNPARSEABLE error. see the two screenshots. I looked up the smartsheet error page and it gives some…Using Smartsheet181Steve Tornallyay
-
First post 11/12/19,Last post 11/13/19I thought I was quite brilliant when I figured out that the reason a formula I created in a checkbox only column returned a #BOOLEAN EXPECTED error. I solved the problem by appending +"" to the end of my formula, and celebrated …Formulas and Functions896khankoff -
First post 11/13/19,Last post 11/13/19For our smartsheet we keep track of vehicles that are or are not repaired. To keep track of how many "open claims" we have I am trying to count how many blank cells we have in the column that signifies if something is complete, b…Formulas and Functions728Billy-Rock
-
First post 11/11/19,Last post 11/13/19Hello Community. I'm having difficulty de-linking from one google drive account and linking to another. I have revoked all app in my smartsheet profile and also de-linked in my google account; even when I do all that I'm still linked t…Using Smartsheet181David McMahon
-
First post 11/09/19,Last post 11/13/19Hello All! I have a folder template that has a sheet with task tracking. I have forms for entering certain tasks, Internal, External, and SCRUM tasks. Currently, I have a link to the form on a dashboard, however, the link is static and …Using Smartsheet361Devan Hutchens
-
First post 11/11/19,Last post 11/13/19My sheet is view only. I am not sure how it got in this mode I don't see a way to get out of mode. This is happening on Android phone nothing changed no new phone I have a tablet can log in and make changes on the sheet. The tablet i…Using Smartsheet251bacrissman
-
First post 11/11/19,Last post 11/13/19Hi. I'm trying to update a cell on a row which is a data field using the C# api. However, I'm getting an error {"Value is not supported for this column type. Use objectValue instead."} But when I'm trying to set objectvalue i…API & Developers241hanemay
-
First post 11/13/19,Last post 11/13/19the hide column option is greyed out. I am an editor for the sheet, and overall the sys admin for the account (Image)Using Smartsheet402jwilson111026
-
First post 11/13/19,Last post 11/13/19Is anyone else having issues with the predecessors in SmartSheet? Right now, I have several sheets that have predecessors that have a duration of 1d and are following the row above without a 'type' (finish to start, start to start, etc.). …Using Smartsheet261swood0908
-
First post 11/13/19,Last post 11/13/19Hello everyone, I read some of the threads about this issue, but cannot find the right answer. Members of my team are consultants and work primarily on weekends so I am using the NETDAY function to calculate the variance. If I use the fo…Formulas and Functions281Philippe Honore
