Using Smartsheet
Archives for August 2019
Discussion List
-
First post 08/31/19,Last post 09/01/19Locked out of my account. It seems they assigned an administrator to my account and they have locked me out.Using Smartsheet451royerg42102371 -
First post 08/30/19,Last post 08/30/19If 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 Smartsheet471ivonne.mejiaberzunza87666 -
First post 08/30/19,Last post 08/30/19Is 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 Smartsheet121Savanna
-
First post 08/30/19,Last post 09/07/19Anyone 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]
-
First post 08/30/19,Last post 09/03/19I'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 Smartsheet189Peggy P
-
First post 08/30/19,Last post 09/01/19Hi 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 SaumyaUsing Smartsheet251Saumya
-
First post 08/30/19,Last post 08/30/19I 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 Smartsheet131Teodora
-
First post 08/30/19,Last post 08/30/19I 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 Smartsheet942Carolyn Tong
-
First post 08/30/19,Last post 08/30/19I 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 Smartsheet153luckyest1
-
First post 08/30/19,Last post 10/02/19Hi, 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 Smartsheet18839LisaB:-) -
First post 08/30/19,Last post 08/30/19Hi Is it, will it be possible to print the 'Sheet Summary' panel or export to PDF etc? Thanks Cheers RichardUsing Smartsheet451Richard
-
First post 08/29/19,Last post 08/30/19In 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 Smartsheet132Dal41
-
First post 08/29/19,Last post 09/10/19Hi 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 Smartsheet261JZoshak
-
First post 08/29/19,Last post 09/04/19Hello 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 Smartsheet362Jayson R -
First post 08/29/19,Last post 08/30/19I 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 Smartsheet133styless
-
First post 08/29/19,Last post 09/03/19Hi- 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 Smartsheet541josh87861
-
First post 08/29/19,Last post 08/30/19I 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 Smartsheet518GetITDone -
First post 08/29/19,Last post 08/29/19I 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 Smartsheet231uptown.tc
-
First post 08/29/19,Last post 09/03/19Smartsheet 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 Smartsheet296[email protected]
-
First post 08/29/19,Last post 08/29/19I 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 Smartsheet125styless
-
First post 08/29/19,Last post 08/29/19I'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 Smartsheet281BenP
-
First post 08/29/19,Last post 08/29/19I 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 Smartsheet171Grant Coordinator
-
First post 08/29/19,Last post 08/29/19I 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 Smartsheet631Terrapin69
-
First post 08/29/19,Last post 08/30/19I 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 Smartsheet301Blessing
-
First post 08/29/19,Last post 08/29/19I 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 Smartsheet1002ssamuelson
-
First post 08/29/19,Last post 08/30/19Hi 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 Smartsheet122cpezz
-
First post 08/29/19,Last post 08/30/19Hi, 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 Smartsheet481RonPB
-
First post 08/29/19,Last post 09/03/19I 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 Smartsheet681neil.pattinson90956
-
First post 08/28/19,Last post 09/01/19Hi, 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 Smartsheet286CaKing
-
First post 08/28/19,Last post 09/13/19Hello, 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 Smartsheet2410Devan Hutchens
