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.
Construction
Discussion List
-
Automatic ticket numbering by locationAccepted AnswerAccepted Answer M. David 28 views 11 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/22/20,Last post 01/23/20Hello. I worked with someone on a previous discussion, but for some reason cannot locate it now. I have one data base file with the work orders from many different community locations. I wanted a solution for the Work Order Number to be a …Formulas and Functions2811M. David -
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
-
First post 05/17/19,Last post 01/23/20Hey Is it possible to have the the drop-down list of a column changed based on the value of another column? Eg. If column A's value is set to "Work stage 2" column B's drop-down list will have a specific list, but when it is se…Formulas and Functions29916[email protected]
-
First post 09/17/19,Last post 01/20/20How do I get child rows to move to specific parent rows based on data from a specific column? I have active, lead, not bidding, and submitted statuses. When a bid is submitted I would like that row to move to the submitted parent. If it is…Using Smartsheet393alycia104251
-
First post 01/14/20,Last post 01/15/20Hi, I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet. Right now they are using a sh…Using Smartsheet341Ian B
-
First post 01/14/20,Last post 01/15/20Hi, I work in construction and after our project managers inspect a project in the field I'd like them to have the ability to generate an inspection form for the property owner to sign on site using a tablet. Right now they are using a sh…Using Smartsheet225Ian B
-
Log of user access to sheetsAnsweredAnswered M. David 45 views 6 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 01/03/20,Last post 01/14/20In the Control Center, I create a group of files each time a new project is started. I am being asked to create a report/sheet/dashboard that shows the date of the last time the project manager viewed/edited the sheet. If successful, this …Premium Apps and Integrations456M. David
-
First post 09/16/19,Last post 01/11/20Thought I would start my own thread regarding this since it seems very quiet around this change. Am I the only one having no luck in using the suggested shortcut CTRL ] to indent? I am using Windows 10, Chrome webbrowser and swedish keyb…Using Smartsheet258Mattias
-
First post 08/21/18,Last post 01/08/20Has anyone received this error message before? What are the options for large data? (Image)Using Smartsheet729David Skinner -
First post 01/02/19,Last post 01/05/20Hi everyone! New to Smartsheet and trying to figure out the automation aspect - which is what really sold us on the software. So, I have a question - is it possible to send out notifications/alerts based on specific changes within a row…Using Smartsheet153dawn73751
-
Baseline/Actual Schedule formula helpAccepted AnswerAccepted Answer Nick Monroe 45 views 13 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 12/19/19,Last post 12/20/19Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additiona…Formulas and Functions4513Nick Monroe
-
Opening Dashboard Hyperlinks in new tab.Accepted AnswerFirst post 02/15/19,Last post 12/20/19The dashboards that I've created for out Project Management teams contain a report that lists all their active projects with a hyperlink to a project schedule (A different Smartsheet Grid). I've been asked if it is possible for them to o…Using Smartsheet9211RMRGSA
-
First post 12/04/19,Last post 12/18/19Hi All, I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula: =COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, &qu…Formulas and Functions619RySols -
First post 12/05/19,Last post 12/06/19Hi, I need help to solve this puzzle. I'm using this sumif formula =SUMIF({Supplier Invoice register Order Number}, [PO Main Contract]10, {Supplier Invoice register value}) to sum up the total value of invoices against a particular o…Formulas and Functions293kane.godfrey
-
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions352KDub618
-
First post 12/03/19,Last post 12/04/19Hello, I'm evaluating the use of Forms for a "field ordering" system from an Item Master Table. Best scenario is to create a form to request multiple items via a single submission (not multiple items in a single cell = less desi…Using Smartsheet473SupplyChain
-
First post 12/04/19,Last post 12/04/19Trying to get a formula to evaluate 2 columns and if the 1st column is CURRENT and the 2nd Column is CHECKED, return a value of YES, and if either column doesn't show the CURRENT of CHECKED, return a value of NO. Have tried many combos an…Formulas and Functions322dskpetersen
-
First post 11/27/19,Last post 12/02/19Hello. I am trying to use a COUNTIFS formula to count the number of records in a second sheet that meet two criteria; the Project Status of the record matches the project status of the row where the formula is, and the year of the Move-In …Formulas and Functions328M. David
-
First post 12/02/19,Last post 12/02/19I need to be able to unhide one single column. NOT ALL. Is there a feature where I can pick the column I need to view. We have weekly columns that go back 2 plus years. I do not need to see over 100 columns unhidden. The unhide all feature…Using Smartsheet231haleyp123
-
First post 08/07/17,Last post 12/01/19My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in E…Archived 2017 Posts202Michael.Baker
-
First post 11/27/19,Last post 11/28/19Are there any templates available for architectural design project? I know there are several construction templates but I am more interested in architecture / design specific and the workflows related to the specific processes.Using Smartsheet302NP
-
First post 11/27/19,Last post 11/27/19I'm having trouble with creating a formula that flags my status column as "overdue" when I'm not at 100% complete and past a tasks end date for that line. i've read a lot of the other posts but none of the formulas seem to apply…Formulas and Functions191Irishalum2002
-
First post 11/26/19,Last post 11/26/19Hello. I am trying to create a graph that shows the top 10 tasks ranked by the variance between Initial Duration and Actual Duration. To make this work, I want to ignore tasks that are parent records. What would this formula look like? I h…Formulas and Functions211M. David
-
First post 11/25/19,Last post 11/26/19Sending a single update request does not always generate a response because many people are not good about answering all their emails, and then it gets lost in old email. I'd like to generate a daily update request that begins on a set day…Using Smartsheet292DanR
-
First post 11/25/19,Last post 11/26/19Good Day All, I am trying to familiarize myself with Dynamic View. My questions is, upon sharing the view with someone (lets say I share with my accountant) how do we send requests to update things WITHIN dynamic view? Let me propose a…Premium Apps and Integrations321PMA98681
-
First post 11/22/19,Last post 11/23/19Hi There, I am using my smartsheet to manage a production of furniture goods. I have set columns up for Start/ Finish/ Expected finish/ Duration/ and Delay to Expected finish. This will enable me to see where the delays are happening in …Using Smartsheet251ew112261
-
Closed Sarah Link 17 views 3 comments 0 points Most recent by Richard Rymill SBP Archived 2016 PostsFirst post 04/14/16,Last post 11/23/19We are new to smartsheet and looking for advice on the best templates to use to track schedules, and being able to track delays, etc. Would anyone be willing to share ideas or sheets that you have found useful to your business? Thank …Archived 2016 Posts173Sarah Link
-
First post 08/09/19,Last post 11/22/19Is there a hard limit to the number of fields we can add into the new Sheet Summary page?Using Smartsheet343cmondo -
First post 11/18/19,Last post 11/21/19I recently contacted support to find out if there was an option within dashboard charts to keep the charts from plotting 0. I received the following response: Currently we don't have a feature in place that will prevent specific values fr…Using Smartsheet164Tama Wagner -
[email protected] 32 views 3 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 11/19/19,Last post 11/20/19I created a project management financial sheet (client / projects / deliverables & invoicing). I am trying to sum the value of invoices between a date range (screen grab). This is what I thought would work: =SUMIF(DTI:DTI, AND(@cell…Formulas and Functions323[email protected]
