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
-
Can users just disappear from Smartsheet?Accepted AnswerFirst post 01/23/20,Last post 01/23/20We've had this on several occasions where a user with a licence was suddenly "deleted", meaning that all of their folders disappeared as well. This is very strange and we don't understand if it's an internal issue or if this has …Using Smartsheet142Ivana -
Display Project Resource View in DashboardAccepted AnswerFirst post 01/22/20,Last post 01/23/20Is it possible to show the project resource view as a dashboard widget? I'd like the project team to have the ability to see the project resource allocation from the dashboard rather than clicking through to the sheet. If this can't be do…Using Smartsheet241Steve Haag
-
I cant get the TODAY function to work in this script.Accepted AnswerAccepted Answer Robert Stuffings 29 views 6 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20=COUNTIFS({Quality Inspection System (Failures) Range 2}, "01-05204", {Date}, >=TODAY(-90), {Date}, <TODAY()) I am new to writing scripts and am kind of stumbling about. I have used the TODAY function once on another sheet …Formulas and Functions296Robert Stuffings
-
Question Kenny Stolze 13 views 0 comments 0 points Started by Kenny Stolze Premium Apps and IntegrationsFirst post 01/22/20,Last post 01/23/20I am trying to set up a column in my intake sheet that will be updated via cell link FROM the profile data. I understand I can use CC to set up my intake to push data to the profile data for a project. I essentially want to do the reverse…Premium Apps and Integrations130Kenny Stolze
-
Counting Unique EmployeesAccepted AnswerAccepted Answer [email protected] 30 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/21/20,Last post 01/23/20Hi All I collect data from the staff in the following form: || Date || Employee Name || Task || Units Done || Time Taken || I want to write a formula that answers the following question: How many unique employees worked on "Tas…Formulas and Functions305[email protected]
-
Need to add multiple rows to a Smartsheet from a formAccepted AnswerAccepted Answer Stephanie Stewart 34 views 4 comments 0 points Most recent by Stephanie Stewart Using SmartsheetFirst post 01/17/20,Last post 01/23/20Hi all! Based on what I've seen online this isn't possible, but thought I would ask anyway. I've created a form for an internal team to submit requests on. If they have more than request (the average is 10-40 at a time) I'd like the Sm…Using Smartsheet344Stephanie Stewart
-
Answered Kelly Buse 40 views 11 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 12/18/19,Last post 01/23/20Hello, Another request for information! I have a parent status ball that I would like to change color based on the 2 deadline status balls and the dominant completion ball (i.e. row 1 & row 2 - then row 3 being the dominant ball). The…Formulas and Functions4011Kelly Buse
-
First post 01/22/20,Last post 01/23/20Hello, I'm looking to accomplish the following and am hopeful that someone will be able to help support. Thank you in advance. I have a Live, Start Date and End Date column. What I am proposing to accomplish: Live = Red, if the Start Date/…Formulas and Functions175mmac
-
First post 01/17/20,Last post 01/23/20Hi team, I'm using Placeholders in a workflow to generate individual emails for an update request. Although the same individual received the update, they will forward as needed, so I need to ensure each update request for the day doesn't …Formulas and Functions319Rob Kozak
-
First post 01/23/20,Last post 01/23/20Hi, I often receive feedbacks from my colleagues that the Smartsheets dashboards we create on the project are not very interactive and "smart". I am in the process of creating a new dashboard at the moment and would like to make …API & Developers91sahilhq
-
Fill across not working as expected?UnansweredFirst post 01/22/20,Last post 01/23/20Wondering if anybody else is experiencing this - I have performed this scenario hundreds of times without issue so wondering what's up! I have a formula based on full Column:Column ranges. The criteria ranges are set with $, the range to s…Formulas and Functions250Jaye Tatone -
Ordering Jira connector by rankUnansweredQuestion Rob Sandberg 16 views 0 comments 0 points Started by Rob Sandberg Premium Apps and IntegrationsFirst post 01/21/20,Last post 01/23/20We want to be able to display in smartsheets our backlog by rank. Meaning we want it displayed in the order the product owner has arranged it in. We also need to use JQL to get the detail we need. Here is the query that works as expected i…Premium Apps and Integrations160Rob Sandberg
-
First post 01/21/20,Last post 01/23/20I'm trying have have my rows automatically update priority while allowing the user to move the rows to arrange their desired priority order. Its all working good with the exception if i move the first row or try to move another row as the…Formulas and Functions260Terry Ables
-
Datamesh - blanking mapped columnsUnansweredQuestion Fabien Videotron 15 views 0 comments 0 points Started by Fabien Videotron Premium Apps and IntegrationsFirst post 01/21/20,Last post 01/23/20In Datamesh, when the lookup value in the target sheet is blanked out (delete) or even changed to a value that has no match in the source sheet, all the mapped columns in the target sheet remain with the previous value which makes the data…Premium Apps and Integrations150Fabien Videotron
-
First post 01/23/20,Last post 01/23/20The column name is [Task] and a cell value called "Project Details" is located somewhere in the column. Their children is project 1, project2, ... etc.... I want to count the number of children under "Project Details". …Formulas and Functions81Chuen
-
Limiting chart limit to a valueAccepted AnswerAccepted Answer sahilhq 6 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/23/20,Last post 01/23/20Hi, I have created a chart widget in Smartsheet dashboard and I would like the horizontal axis to go up to the value of 100 only and not 120. Is there any way to bring it to 100? Please see attached images of the chart and the data that t…Formulas and Functions61sahilhq
-
First post 01/22/20,Last post 01/23/20I set up a very simple automation rule to move a row to a different sheet when the Status changes to Complete. it isn't working. I am the owner of both sheets. There are no other Admins. Proofing is not enabled. I have screen shots to sho…Using Smartsheet161Sarah Krueger
-
First post 01/22/20,Last post 01/23/20Hello, I'm looking to accomplish the following and am hopeful that someone will be able to help support. Thank you in advance. Working with the following columns: Start Date End Date Sale Status Assignee QA Status Scenarios: If a sale…Formulas and Functions221mmac
-
Answered andrew.taylor37161 24 views 6 comments 1 point Most recent by Richard Rymill SBP Using SmartsheetFirst post 01/20/20,Last post 01/23/20Hi I am creating master sheets with the basic information that most of our sheets would require. We are a Strata company so that info would be the names and addresses (and other data) of all the buildings we have under management. I then w…Using Smartsheet246andrew.taylor37161 -
JOIN COLLECT formulaAnsweredAnswered Rebecca Panaccione 27 views 4 comments 0 points Most recent by Genevieve P. Formulas and FunctionsFirst post 01/17/20,Last post 01/23/20Hello, I could use assistance building a JOIN COLLECT formula, I think. Here is what I'm trying to do. Using the formula =JOIN(COLLECT(rangecriterion_range1criterion1[criterion_range2criterion2...]) , I don't understand what I'm colle…Formulas and Functions274Rebecca Panaccione
-
First post 01/21/20,Last post 01/23/20Does anyone have an example of how to query for all sheets that were created using the project template? Thanks!API & Developers123Neall Alcott
-
Query String to Filter A SheetAnsweredFirst post 01/21/20,Last post 01/23/20Is it possible to use query strings to link a filtered sheet? E.G. ?Row=1&Task=Review&Resource=John If so I think this should be submitted for enhancement, as it could prove to be extremely useful.Using Smartsheet166ahill
-
Flag column based on date & other criteriaAccepted AnswerAccepted Answer [email protected] Seattle 13 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20I'm trying to figure out how to set up an alert to automatically notify someone if the entry row hasn't met criteria (checkbox) within 5 days. I was thinking about creating a flag column that kicks off an email alert but I can't figure out…Formulas and Functions133[email protected] Seattle -
When creating a work flow how to I get the alert to trigger based on a if a value "greater than" a cAnsweredAnswered Mark Weighner 19 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/16/20,Last post 01/23/20When creating a work flow, how to I get the alert to trigger based on a if a value "greater than" a certain amount of time?Formulas and Functions193Mark Weighner
-
Answered Tucker Webb 13 views 3 comments 0 points Most recent by Richard Rymill SBP Using SmartsheetFirst post 01/22/20,Last post 01/23/20Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best sol…Using Smartsheet133Tucker Webb
-
Accepted Answer Justin Runner 38 views 7 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/21/20,Last post 01/23/20I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format.…Formulas and Functions387Justin Runner
-
First post 10/14/19,Last post 01/23/20Hi All, Our department is looking to produce a Training Request form for our staff. How do we set up an automated workflow where it'll allow the original requester to edit the training request if it has been declined by the manager? For…Using Smartsheet595Ken Young
-
First post 01/10/19,Last post 01/23/20Is there a way to limit form entries to one per person? Can the link to the form be limited to single use? Thanks in advance!Using Smartsheet269SummerEdwards
-
CountIF with dynamic criterionAccepted AnswerAccepted Answer Stewart Ennew 11 views 2 comments 0 points Most recent by Stewart Ennew Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20Hi i'm trying to count the number of rows in a Smartsheet where the name in the "Engineer" column is the same name in the "Approved By" column I can get it to work by looking at a single row =IF(Engineer4 = [Approved By…Formulas and Functions112Stewart Ennew
-
First post 04/03/18,Last post 01/23/20i have a sheet that has data with dates added from a form. it always adds a new request from the form to the top and i have to manually sort it by date in descending. is there not a way to have it automatically add the data by the date in …Using Smartsheet24121lisa.nichols43261
