Using Smartsheet
Archives for June 2019
Discussion List
-
First post 06/30/19,Last post 06/30/19Dear Smartsheet, I really want to add a formula in report. I think it's mandatory to be supported in smartsheet. is there any upcoming update will cover this function? Thanks a lot.Using Smartsheet31AymanK -
First post 06/30/19,Last post 06/30/19Hello. I am currently traveling and I only brought my tablet and phone. I just noticed you cannot edit formulas on the apps. Why is this locked down?Using Smartsheet131NBurrus -
First post 06/29/19,Last post 06/29/19Hello, I am new to SmartSheet and is playing around with the new automation system I have 2 columns start date and end date, I want to create an alert to some people that if the start date goes past end date and at the same time make end …Using Smartsheet411John Doee
-
First post 06/29/19,Last post 06/29/19My Project has not got a start date so I want an option for weeks and months and the gant chart to show Years Months and Weeks. I am relatively new to smartsheet so any `dummy help' would be appreciated.Using Smartsheet231Hopey -
First post 06/28/19,Last post 07/02/19Hello, I have multiple projects and each project is in its own sheet. I am trying to create a summary sheet (to later show in the dashboard) that shows how many people are assigned to each project currently. Is there a formula for this or…Using Smartsheet1656Westlandadmin
-
First post 06/28/19,Last post 06/28/19We have a data base of Subcontractors, that is created in a sheet. I am trying to have a tracking sheet (Bid/Contract Request) from bidding to contracts per job and per subcontractor. I have a column of subs that I have linked from the d…Using Smartsheet131Kim.Cunningham
-
HELP Nested-if FormulaAnswered QuestionFirst post 06/28/19,Last post 12/15/19Hi there, I'm trying to complete my certification and the following nested-if formula needs to be created: "Use a nested-if formula to automate the RYG light in the "Status "column, depending on the "% Complete"…Using Smartsheet2176Stefanie
-
First post 06/28/19,Last post 07/02/19Hello Community. I am very new to smartsheet. I have created a dashboard and want to add charts from a sheet. The metrics i want to provide are not numeric-based. How can I create the charts without numbers being associated? Thank you!Using Smartsheet273Jenni Sheets
-
First post 06/28/19,Last post 06/28/19I'm having trouble getting a line chart to chart the appropriate data. I am tracking KPIs for my sales team and collecting in a source sheet. I then have a report for each sales person that pulls their data from that sheet. I have made eac…Using Smartsheet131Kendra Michaels, CAPM -
First post 06/28/19,Last post 06/28/19I am currently using this function =COUNTIF(Status:Status, "To Do") to identify the total number of tasks with the status of "To Do". I'd now like to break this out to count the total number of "to do" that st…Using Smartsheet133FactionPMO -
First post 06/28/19,Last post 06/28/19Hi, would it be possible to use a form to get data into a sheet and instead of creating a new line of data it can add into an existing line? Attached an example. (Image)Using Smartsheet151Alexander Torres
-
First post 06/28/19,Last post 06/29/19Maybe we're just doing something wrong, but it seems like it's only possible to upload or take a single picture at a time using the SmartSheets mobile app. Is there a way to upload more than one at a time? Is this in the works by chance?Using Smartsheet1231ZenTekDS
-
First post 06/28/19,Last post 06/28/19I'll keep this simple. In the method I'm using the form every person that uses the form is not required to make a Smartsheet account. They have too many logins and adding another "software" to the mix is not going to go over we…Using Smartsheet25Sinema
-
First post 06/28/19,Last post 07/22/19I'd like to schedule a report each month to automatically cover the next 90 days. But it looks like I'd have to update the "Custom Date Range" each time for the next 90 days. Is there a way to have the Custom Date Ran…Using Smartsheet396Mark Lappegaard -
First post 06/27/19,Last post 07/01/19I want to create a Smartsheet project that has a Start Date of July 1, 2019 and End Date of September 1, 2020. I want to set the timeline to Years/months. When I view or print it, I only want to see the months associated with 2019 and 2020…Using Smartsheet541RCox
-
First post 06/27/19,Last post 08/13/19Hi, I'm working on developing an induction booking process that allows our team to book site induction through Smartsheets. Firstly, I intend to have a Smartsheet induction register that will include columns such as induction date, who t…Using Smartsheet13811sahilhq
-
First post 06/27/19,Last post 06/28/19I have a task with a duration of 12 hours. Smartsheet is showing the end date same as the start date - say, starts today and ends today. Secondly, a dependent task for the same resource has a duration of 4 hours. This should make the sub…Using Smartsheet154Ash2000
-
First post 06/27/19,Last post 12/27/19Hoping to get some guidance on formula to use. Have a scheduled date range in which to get something done. But need to see if there is any overlap of schedule dates against any blackout periods. Sheet 1 has the task to be completed with…Using Smartsheet874STEPHEN ALLEN
-
First post 06/27/19,Last post 06/28/19Hi, I would like to share multiple templates that I have designed so others can use within my company. Does Smartsheet have the capability to share a blank template?Using Smartsheet283Eddie Rayborn
-
First post 06/27/19,Last post 04/03/20I'm hoping the smartsheet Gods can help me. I'm struggling. I have 126 projects in my sheet and about 30 different project leaders. Each project leader is set up as a contact (see 2nd screentshot - Pink) I'm trying to count projects by…Using Smartsheet1304Melissa Shoumlisky
-
First post 06/27/19,Last post 06/27/19Has anyone used Calendar to track employee schedules? If so, how did you do that?Using Smartsheet131Margit Beasley
-
First post 06/27/19,Last post 10/16/19I'm having a problem creating an approval flow. When the approver denies the flow, it automatically sends an email to the one who requested the approval asking him to clear the wrong field. I need that after the field is arranged the …Using Smartsheet883jfabio94151
-
First post 06/27/19,Last post 01/20/20Does anyone know what happened to the Kindle Fire App? It is no longer in the app store and is now unavailable.Using Smartsheet693NBurrus
-
First post 06/27/19,Last post 07/15/19Hello, I am a beginner... Would anybody help me to nest this formulas? They work independently but when I try to integrate them, I cannot make them work. Maybe is not the right formula for what I want to do. I have a symbol column that sho…Using Smartsheet112CarolinaMGB
-
First post 06/27/19,Last post 07/03/19How can we automatically update our columns when it is linked to another columns? I do not want to use copy and paste because I want the range of columns to be unlimited? I am getting update from web forms on my main smartsheet but I want …Using Smartsheet246ABHI
-
First post 06/27/19,Last post 06/28/19We have 2 automated reports for scheduling that have been sending to our SmartSheet groups via email each day however over the last two days these reports have stopped working. To monitor I added myself to the list yesterday and still this…Using Smartsheet475ChuckS
-
First post 06/26/19,Last post 06/27/19Hi, I have setup a workflow around an "Update Request" but the one field that I would like them to be able to update does not allow it. I have checked that the field is not locked as well. I have attached a snap shot of both the …Using Smartsheet283Cap -
First post 06/26/19,Last post 06/27/19I want to denote unavailable time for resources so when a task assigned to that person fell on an unavailable time period, the start and end dates accomodated for that automatically. Is there a way to do that in smartsheet?Using Smartsheet241SophieKelly1
-
First post 06/26/19,Last post 06/27/19Hi everyone! I have a question, so I have workflows that should send out reminders/approvals two week prior to a certain day, but I am trying to test the workflow if it is working and the problem is that I have to wait every top of the…Using Smartsheet951Jovani Enriquez
-
First post 06/26/19,Last post 06/28/19Hi, Anyone see this error message before? Resetting the notifications failed. Please contact your SALESFORCE System Administrator and let them know that notifications from Webhooks are no longer working so that they can investigate. Our…Using Smartsheet321KenC
