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.
Other
Discussion List
-
First post 01/15/20,Last post 01/22/20I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned &a…Using Smartsheet163poweb048 -
First post 08/15/18,Last post 01/20/20I am running a report from my sheet however the primary column shows up even though I did not select it and I cannot hide it. I don't want/need it in my report. I was wondering if there was a way to remove or prevent it. Thanks!Using Smartsheet635Sgiovinazzo
-
First post 01/16/20,Last post 01/16/20Excuse me, my english isn't very well. I need your help. https://us.v-cdn.net/6031209/uploads/847/8ISQKGZA1P18.jpg When I want to put an URL in smartsheet I click in the box to join an URL and on my mouse but nothing are been proposed to …Using Smartsheet261Lisa Savard -
First post 11/13/19,Last post 01/16/20I am wanting to create an approval workflow that requires different levels of approval. The number of levels depends on where the request is coming from. As an example request comes in that requires Director, VP, and CEO approval to procee…Using Smartsheet304benfking
-
First post 12/04/19,Last post 01/06/20Hello everyone! Hoping I can get some assistance from the Gurus around here. Currently, we have an =IF formula that looks at the Due Date of a project and: * if the project is today, it returns THIS WEEK * if the project was last week,…Formulas and Functions313DiAlmeida
-
First post 12/05/19,Last post 12/31/19Hi, is there a way to automatically merge rows to a google document when a new row is added? Example: We track phone monitoring in a sheet and want them to auto-merge into the Google Doc or PDF instead of someone having to do manually.Using Smartsheet355rmcbride108121 -
First post 11/10/19,Last post 12/30/19I'm working to have a request sheet move rows to a active list sheet. I'm getting the following error and having trouble finding information on what column name actions I need to look to correct. Any help pointing me where I can find col…Using Smartsheet4610joshyboy
-
Workspace "cover page"AnsweredFirst post 12/17/19,Last post 12/18/19Would anyone find it useful to have a cover page for Workspaces that, when the workspace is first opened (or every time it's opened), you see a rich text explanation of what that Workspace is for and how a person could or should interact w…Using Smartsheet324brianmorgs
-
First post 12/06/19,Last post 12/07/19Hi! So--I have basic formula knowledge but feels like I'm outside my wheelhouse. All I want to do is return a specific start date based on a couple criteria: Week (1-7, beginning 2/20/20) Start time (morning, midday, night) Note: all m…Using Smartsheet261kolfinna
-
First post 12/06/19,Last post 12/06/19Hi all, We have contact columns that we are trying to add hundreds of contacts too. The number is not above the limit specified by Smartsheet that I found; however, names continuously disappear. For example, User A may be able to drop-…Using Smartsheet383atfrost -
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/04/19,Last post 12/05/19Hi All! I am at a loss at how to even start this design. I have approximately 15 tasks that occur every month on the same BUSINESS day I have another 5 tasks that occur on the same business day every quarter. I would like to…Using Smartsheet272Jeager
-
First post 05/20/17,Last post 12/03/19Have a super basic question I just can't seem to find a quick answer for. Want to sum cells with both numbers and text in them like "15 min" + "15 min" and get the result of "30 min". I formatted the cell wit…Archived 2017 Posts68517Dereck H
-
First post 12/01/19,Last post 12/02/19Can anyone recommend a purpose-built portable device for scanning barcodes that could be used with the SmartSheet (i.e. not a smartphone or tablet)? We're looking for something we can use in a laboratory environment, so it should be fairly…Using Smartsheet231Chuck Mihaliak
-
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 trying to count instances of a specific selection in a multi-select column when "Yes" is in another column. I've tried various FIND, COUNT, COUNTIF, COUNTIFS then IF or AND, but I'm not able to figure this one out. Thi…Formulas and Functions263tmccray
-
First post 11/27/19,Last post 11/27/19Is this possible, only seem to be able to add one at a time, is there a way to add multiple?Using Smartsheet171Lisa.stubbs112706
-
First post 06/23/15,Last post 11/27/19Good afternoon, I'm not aware of a current way to do this, so I'm wondering if it's on the dashboard for enhancements. In our use, we find ourselves needing to attach/copy the same documents from one line to another and currently the onl…Archived 2015 Posts10620Loann McGee -
First post 11/26/19,Last post 11/26/19I would like to auto assign and update the Assigned To field based on a value in another field. I've tried something like this; IF([Contract Type]=NDA, John Doe) So if Contract Type equals NDA, then put John Doe in the Assigned To field…Formulas and Functions221Shawn Borror
-
First post 11/19/19,Last post 11/26/19If I need a database page where other sheets can pull information from it, to standardise data input, but having the following criteria/situation: 1) database page will keep information for 1 year (database = employee data) 2) will excee…Using Smartsheet2210Vivien Chong
-
First post 11/22/19,Last post 11/25/19Hello! I am looking for help in building a formula for a sheet. I create semester reports on a sub-group of persons that we track in a master database. Because this database is extensive (multiple years) but my reports are created from…Formulas and Functions191kbrussel
-
First post 11/20/19,Last post 11/25/19Hi, I am hoping someone can help with the below formula additions we would like to make as it would be greatly appreicated! * Today our formula provides a status of In Progress for NIR code and LI code in the SMCC Action column. Once an …Using Smartsheet145JD_425
-
First post 11/19/19,Last post 11/22/19I tried to use index/match to reference multiple columns from a resource sheet. I can't seem to get the formula correct. My table (resource) has a list of teams with start times, parking information, notes, etc. The table includes all the …Formulas and Functions493Serena Williams -
First post 11/20/19,Last post 11/22/19We have a gremlin! There have been two instances now where we manually move a row, smartsheet appears to be moving it, then it ends up back on the original smartsheet. The activity tracker shows the attempts on both smartsheets. Any id…Using Smartsheet155Paula Cosentino
-
First post 11/20/19,Last post 11/21/19Hi, i am wondering if there's a way to validate any External URL to check if it is a valid URL with a status 200. Any help is highly appreciated. ThanksUsing Smartsheet222sandeep-bonthu
-
monique.mason111691 23 views 1 comment 0 points Most recent by Alejandra Premium Apps and IntegrationsFirst post 11/18/19,Last post 11/21/19Hi, The PDF download does not print the calendar month at the top. Strange the month does not appear at the top of each calendar month PDF download. Can someone please assist? The only options for viewing the month include: 1. Print l…Premium Apps and Integrations231monique.mason111691 -
First post 11/20/19,Last post 11/21/19Hi - I am trying to download the very first risk register template that is referenced on this page. https://www.smartsheet.com/risk-register-templates When I click the Smartsheet version, I get a completely different Risk Register. When …Using Smartsheet211latsyrcg3
-
First post 12/05/18,Last post 11/20/19Hello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance odedFormulas and Functions1015odedL
-
First post 11/20/19,Last post 11/20/19So i have parent cells and dependencies. The dependencies have color balls (red, yellow, green, grey). Here is what I want: If one of the dependencies has a red color ball, I want the parent ball color to be red. If all dependencies have…Formulas and Functions364NaNa
