Using Smartsheet

Using Smartsheet

Archives for August 2019

Discussion List

  • royerg42102371
    royerg42102371 90 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 08/31/19,Last post 09/01/19
    Locked out of my account. It seems they assigned an administrator to my account and they have locked me out.
    Using Smartsheet901
    royerg42102371
  • Ivonne Mejia
    Ivonne Mejia 74 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 08/30/19,Last post 08/30/19
    If I build a Dashboard and add a non-licensed user as editor. Will that person be able to edit and make changes to the Dashboard?
    Using Smartsheet741
    Ivonne Mejia
  • Savanna
    Savanna 11 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 08/30/19,Last post 08/30/19
    Is there a way to password protect a portal without making someone sign up to have an account with Smartsheet or making the link public?
    Using Smartsheet111
    Savanna
  • L@123
    [email protected] 12 views 6 comments Most recent by Andrée Starå Using Smartsheet
    First post 08/30/19,Last post 09/07/19
    Anyone else having issues with cloudflare when editing comments? Trying to fix some code i miss-submitted and can't change it. Basic stuff too, just missed some parenthesis.
    Using Smartsheet126
    [email protected]
  • Peggy P
    Peggy P 25 views 9 comments Most recent by Paul Newcome Using Smartsheet
    First post 08/30/19,Last post 09/03/19
    I'm trying to use a formula in the Parent row of several date columns that will: 1) give me the MAX date from the child (anywhere from 1-12 rows) 2) add 540 days to that date (from #1) This will work using: =MAX(CHILDREN()) + 540 Excep…
    Using Smartsheet259
    Peggy P
  • Saumya
    Saumya 39 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 08/30/19,Last post 09/01/19
    Hi I have a created a form, I would like the client to fill the field- Point of Contact- which is an email address. How can one enter multiple emails in a single form field? Any help is appreciated. Thanking you, Regards Saumya
    Using Smartsheet391
    Saumya
  • Teodora
    Teodora 14 views 1 comment Most recent by [email protected] Using Smartsheet
    First post 08/30/19,Last post 08/30/19
    I need help with determining the right formula - Scenario:  If the value in colum 1 row 2 is "word" , than multiply (column 2 row 2, column 3 row 2, etc) Thank you in advance for your help!  
    Using Smartsheet141
    Teodora
  • Carolyn Tong
    Carolyn Tong 208 views 2 comments Most recent by Andrée Starå Using Smartsheet
    First post 08/30/19,Last post 08/30/19
    I created a form which includes a text field for the person's email address.  I want to create a workflow to trigger sending an email to the person when a specific field is changed.  However, the person's email is NOT part of the contacts.…
    Using Smartsheet2082
    Carolyn Tong
  • luckyest1
    luckyest1 14 views 3 comments Most recent by Andrée Starå Using Smartsheet
    First post 08/30/19,Last post 08/30/19
    I seem to have uncovered a glitch.  The calendar view is making the year 8148...even with all the advances in technology and medicine I don't think I will be around in that year...I just want to see 2019 right now, and going forward probab…
    Using Smartsheet143
    luckyest1
  • LisaB:-)
    LisaB:-) 330 views 39 comments Most recent by Paul Newcome Using Smartsheet
    First post 08/30/19,Last post 10/02/19
    Hi, I want to run a report that will return all rows for tasks that need to be worked on next week.  So that will include tasks where the start date is next week, or the end date is next week, or simply tasks that are ongoing through next …
    Using Smartsheet33039
    LisaB:-)
  • Richard
    Richard 62 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 08/30/19,Last post 08/30/19
    Hi Is it, will it be possible to print the 'Sheet Summary' panel or export to PDF etc? Thanks Cheers Richard
    Using Smartsheet621
    Richard
  • Dal41
    Dal41 12 views 2 comments Most recent by [email protected] Using Smartsheet
    First post 08/29/19,Last post 08/30/19
    In a form I have created, I would like a particular radio button to cease working once 5 people out of 50 have hit that button.  In other words, that radio button is no longer available and they need to choose another radio button.  Does a…
    Using Smartsheet122
    Dal41
  • JZoshak
    JZoshak 33 views 1 comment Most recent by Richard Rymill SBP Using Smartsheet
    First post 08/29/19,Last post 09/10/19
    Hi Smartsheet Community,  My name is John Zoshak and I'm a product manager at Smartsheet for our mobile apps. We're looking to do some work on our app-navigation / home screen experience and I'm looking for a few customers to chat with ab…
    Using Smartsheet331
    JZoshak
  • Jayson R
    Jayson R 48 views 2 comments Most recent by Jayson R Using Smartsheet
    First post 08/29/19,Last post 09/04/19
    Hello everyone! New to the community, but loving how detailed Smartsheet is! I am setting up alerts to trigger when a due date is approaching, 6 months, 3 months and 1 month to staff whose certifications will expire on that date.  I would…
    Using Smartsheet482
    Jayson R
  • styless
    styless 12 views 3 comments Most recent by Andrée Starå Using Smartsheet
    First post 08/29/19,Last post 08/30/19
    I am trying to count how many openings each time I added a children row. However, I wanted it to NOT count the Openings if one of the candidate is already hired into that position and or if the HM's decision column is changed to "Hire…
    Using Smartsheet123
    styless
  • josh87861
    First post 08/29/19,Last post 09/03/19
    Hi-   I have been doing some searching on the community and cannot find a clear reason or explanation as to how to to set up the "Optional: Define Row Groups" I cannot find any documentation or help videos on YouTube or the co…
    Using Smartsheet971
    josh87861
  • GetITDone
    First post 08/29/19,Last post 08/30/19
    I have an approval form where once they click on approve it triggers an update request for.  I want the approver to be able to provide a pathname <project foler...> in the comments section that will be included in the update form. Is…
    Using Smartsheet718
    GetITDone
  • uptown.tc
    uptown.tc 22 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 08/29/19,Last post 08/29/19
    I created a form for a smartsheet. Within the smartsheet, i have drop down fields for city, state and zip and included the most common values people will need for those fields. I did NOT click the box that states "Restrict to values o…
    Using Smartsheet221
    uptown.tc
  • L@123
    First post 08/29/19,Last post 09/03/19
    Smartsheet dashboards are just begging to be used as a kiosk. A rotation between a list of user specified dashboards showing different KPI's, and a home dashboard that is navigated to upon any user input would be amazing to have, and I wou…
    Using Smartsheet426
    [email protected]
  • styless
    styless 11 views 5 comments Most recent by Mike Wilday Using Smartsheet
    First post 08/29/19,Last post 08/29/19
    I have a formula going on for the RYG. I added a new column, "Status". I wanted it to be If the status column is FILLED or CANCELLED, the ball will turned Green and canceled out all the other formatting. How can I corporate that …
    Using Smartsheet115
    styless
  • BenP
    BenP 37 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 08/29/19,Last post 08/29/19
    I've just begun using SmartSheet and like it a lot, but it seems as though my team and I keep running into the same problem in various contexts when using Gantt view. Specifically: It's hard to find today's date. Every time we open a shee…
    Using Smartsheet371
    BenP
  • Grant Coordinator
    Grant Coordinator 14 views 1 comment Most recent by Andrée Starå Using Smartsheet
    First post 08/29/19,Last post 08/29/19
    I have created an automated workflow, using the Request Update step.  This automatically creates the form to send to the user to update.  I would like to  change the way the form appears and allow multiple line entries. When I go into Form…
    Using Smartsheet141
    Grant Coordinator
  • Terrapin69
    Terrapin69 119 views 1 comment Most recent by styless Using Smartsheet
    First post 08/29/19,Last post 08/29/19
    I noticed that if I enter a new comment using the little text bubble icon in a row, that cell turns yellow automatically.   Why would this be? (Image)
    Using Smartsheet1191
    Terrapin69
  • Blessing
    Blessing 36 views 1 comment Most recent by Paul Newcome Using Smartsheet
    First post 08/29/19,Last post 08/30/19
    I recently used one of the existing templates "Contract Management" under the Client and Customers in the Solution Center, and it worked great. However, When my users get a notification the header still shows the old name (see at…
    Using Smartsheet361
    Blessing
  • ssamuelson
    ssamuelson 169 views 2 comments Most recent by [email protected] Using Smartsheet
    First post 08/29/19,Last post 08/29/19
    I need help with an AverageIF formula. SmartSheet support gave me this formula for help: =AVERAGEIF([Column6]1:[Column6]22, >0). Essentially, I want the formula to give me the average of the numbers in the Time-to-Fill (Working Days) c…
    Using Smartsheet1692
    ssamuelson
  • cpezz
    cpezz 16 views 2 comments Most recent by Paul Newcome Using Smartsheet
    First post 08/29/19,Last post 08/30/19
    Hi all, Is there a formula I can use so that when I change a status in one of the columns, a day counter in another column returns to 1 and starts counting? For example, if I have an entity in "processing" and in another column …
    Using Smartsheet162
    cpezz
  • RonPB
    RonPB 90 views 1 comment Most recent by Paul Newcome Using Smartsheet
    First post 08/29/19,Last post 08/30/19
    Hi, I created a grid, with each row in the grid representing an individual project. I set the predecessors between the various rows, so Smartsheet draws the links between the various projects. I need to show this grid, including links be…
    Using Smartsheet901
    RonPB
  • neil.pattinson90956
    First post 08/29/19,Last post 09/03/19
    I have built an automated alert that determines which columns to include from a large Smartsheet which uses the max 200 columns based on a number of parameters held within certain rows on the sheet. This works well. However the issue I hav…
    Using Smartsheet1111
    neil.pattinson90956
  • CaKing
    CaKing 37 views 6 comments Most recent by Andrée Starå Using Smartsheet
    First post 08/28/19,Last post 09/01/19
    Hi,    I need help with finding a way to automate the RYG balls so that if no dates are input, it's white. If the first date is input, it's red. If the second date is input, its yellow. And if the final date is input, it's green.   Tha…
    Using Smartsheet376
    CaKing
  • Devan Hutchens
    Devan Hutchens 24 views 10 comments Most recent by Andrée Starå Using Smartsheet
    First post 08/28/19,Last post 09/13/19
    Hello, I have a data sheet used for a call log for project issues.  I'd like to be able to run a report that displays all calls for a specific serial number based on which serial number is entered into a cell, a variable search value.  Id…
    Using Smartsheet2410
    Devan Hutchens