Using Smartsheet
Archives for July 2020
Discussion List
-
First post 07/14/20,Last post 07/14/20HI, when I trigger alert or reminders mail to end user, all columns are to be add in mail body. so how to avoid columns when when send mail to end users.. I don't need to send any columns details to the end users. send only date based mail…Using Smartsheet60Yashwant Singh
-
First post 07/13/20,Last post 07/13/20Are there any plans down the road for Smartsheet to add the ability to write code behind the scenes (similar to vba for Access, Excel, etc.) or incorporate vba?Using Smartsheet50Michael Murphy -
Does Smartsheet have a debugger tool?Accepted AnswerAccepted Answer Michael Murphy 6 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/13/20,Last post 07/13/20Does Smartsheet have a debug tool where you can walk through a formula and see the results of a function and any subsequent nested functions to assist with troubleshooting? I'm picturing the debug tool used in visual basic that shows the r…Using Smartsheet61Michael Murphy
-
Is there a "run now" option that will initiate a Workflow?Accepted AnswerAccepted Answer Michael Murphy 6 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/13/20,Last post 07/13/20If I am setting up a Workflow that depends on a specific action, date, time, etc., and I want to see the results now to correct any missteps, is there a "run now" option that will initiate the workflow? I'm trying to avoid having…Using Smartsheet61Michael Murphy
-
First post 07/13/20,Last post 07/13/20create an idea bank create the ability to have a submission into the grid as a calendar item set as a recurring item add the contact field to a choice instead of email (it used to be this but SS developers changed it).Using Smartsheet40Joleary24361
-
Answered - Pending Review Julius Patam 7 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/13/20,Last post 07/13/20When I select a row and try to send an email, my recipients are no longer able to receive it. I used to be able to do this for the past few years. Suddenly, in the past weeks/months, i'm no able to do so anymore.Using Smartsheet71Julius Patam
-
Answered - Pending Review Christianne Schrobilgen 12 views 2 comments 0 points Most recent by Christianne Schrobilgen Using SmartsheetFirst post 07/13/20,Last post 07/13/20Hello, I've created a form and have the security setting disabled so that anyone can submit, from anywhere. It works fine on desktop, but if trying to submit via mobile, it is sending users to an "explore what Smartsheet can do" …Using Smartsheet122Christianne Schrobilgen
-
Answered - Pending Review Jordan H 10 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/13/20,Last post 07/13/20I'd like to understand how I can keep the form formatting when using the update request function. I know I can limit the actual columns that are viewed, but the horizontal radio buttons, headings, dividers, etc. do not display in the form …Using Smartsheet101Jordan H
-
First post 07/13/20,Last post 07/13/20Is it possible to use dynamic view in Spanish language?Using Smartsheet50hjuarez
-
Answered - Pending Review Prajna Jain 12 views 2 comments 0 points Most recent by Prajna Jain Using SmartsheetFirst post 07/13/20,Last post 07/13/20Hi, I have may dependent columns in a form that are being controlled through logic setting in the form builder. All the database columns are getting mailed to the Requestor , not only the fields that are visible in the form. I want to avoi…Using Smartsheet122Prajna Jain
-
Answered - Pending Review AmandaM 8 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/13/20,Last post 07/13/20We are a manufacturing company using Smartsheet for product scheduling. We have team members asking for notification of a schedule change - which is no problem - but they are also asking to see the previously scheduled date (basically, wha…Using Smartsheet83AmandaM
-
Answered - Pending Review Colin Silvester 7 views 4 comments 0 points Most recent by Colin Silvester Using SmartsheetFirst post 07/13/20,Last post 07/14/20Hello, Is it possible to adjust the scale of the resource view (either for a particular sheet or for the overall resource view)? I am trying to create a general team resource plan for the coming year, and can accomplish that by creating a …Using Smartsheet74Colin Silvester
-
Answered - Pending Review Shell Strozyk 14 views 2 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 07/13/20,Last post 07/13/20Hi There, I am trying to insert a formula to calculate the number of days between two dates, which I have.... Created Date and Accepted Date. My question is, How can I add to the formula If there is no date entered into "Accepted D…Using Smartsheet142Shell Strozyk
-
work week start MondayAccepted AnswerAccepted Answer Netanel yosef 16 views 14 comments 0 points Most recent by Netanel yosef Using SmartsheetFirst post 07/12/20,Last post 07/14/20i try to make filted "plan look ahead' its mean that i want to filter all task that will be next week. the problem is samrtsheet start the week in Monday and in my place we work Sunday to Thursday so how can i solve it ?Using Smartsheet1614Netanel yosef
-
Answered - Pending Review Nick VanHouten 10 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/10/20,Last post 07/10/20I've imported an excel sheet with "1's" in fields, I'd like to convert those to checkboxes. Is that possible?Using Smartsheet103Nick VanHouten
-
Answered - Pending Review James Tanner 11 views 1 comment 0 points Most recent by Sean Morgan Using SmartsheetFirst post 07/10/20,Last post 07/11/20Hi, Do how I bookmark my forms to show in the mobile app favourites? I know they show under Recents but that doesn't help much. Thanks.Using Smartsheet111James Tanner
-
Autopopulate AddressesQuestionAnswered - Pending Review Sarah Hooper 11 views 8 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/10/20,Last post 07/10/20I am using Smartsheet Forms to evaluate building sites in the field. Can I associate each site with a specific address, which would then get autofilled after user chooses a site name from a dropdown list? I can provide the list and associa…Using Smartsheet118Sarah Hooper
-
Answered - Pending Review DSCarr1962 12 views 2 comments 0 points Most recent by DSCarr1962 Using SmartsheetFirst post 07/10/20,Last post 07/10/20First question, I guess, is can a user, who does not have a Smartsheet account, use the Smartsheet Mobile App to enter data into a form? Now the real question. I want to configure a dashboard for maintenance workers that has links to sever…Using Smartsheet122DSCarr1962 -
Answered - Pending Review Andrea Zenner 16 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/10/20,Last post 07/13/20I am trying to create an application in which users make a request of their supervisor and the supervisor approves or denies the request. I created a sheet with "employee name" as a contact list and "supervisor name" a…Using Smartsheet163Andrea Zenner -
Answered - Pending Review Sbrown882 8 views 4 comments 0 points Most recent by RossL Using SmartsheetFirst post 07/10/20,Last post 07/13/20Ok, so I have about 17 forms created for various employees in different departments. Each employee is required to fill out this form x amount of times a month. I want to make a report to auto populate that shows how many times employee fi…Using Smartsheet84Sbrown882
-
Answered - Pending Review Jennifer Flanagan 12 views 1 comment 0 points Most recent by Paul Newcome Using SmartsheetFirst post 07/10/20,Last post 07/10/20I have a column called "Status" with 3 options: Complete, In Progress, Or Not Started How do i apply a formula to the parent tasks that would be not started if all the children are not started, in progress if at least one of the…Using Smartsheet121Jennifer Flanagan
-
Answered - Pending Review Jennifer Flanagan 11 views 1 comment 0 points Most recent by RossL Using SmartsheetFirst post 07/10/20,Last post 07/10/20Want the % complete cell to automatically turn to 100% if the Done cell is checked Using below but not working =IF([Done]@row =1, [% Complete]@row, = 1)Using Smartsheet111Jennifer Flanagan
-
Answered - Pending Review Jennifer Flanagan 12 views 2 comments 0 points Most recent by Jennifer Flanagan Using SmartsheetFirst post 07/10/20,Last post 07/10/20Formula to use red flag if : Is Milestone is checked, the Planned End Date is today or in the past, and Done is not checked Tried the below but its not working =IF(AND([Is Milestone]:[Is Milestone], 1, [Planned End Date]:[Planned End Date…Using Smartsheet122Jennifer Flanagan
-
Answered - Pending Review John Neels 7 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/10/20,Last post 07/10/20I have one sheet that runs my production schedule. Then we run multiple reports to show the schedule for each station. When we make comments, the alert will direct you to the sheet, not the relevant report. Is there a way to see the com…Using Smartsheet71John Neels
-
First post 07/10/20,Last post 07/10/20I see that this topic was open last year, but the thread was closed quoting a workaround--add the duration column to the report and have users modify it to get the desired end date. My project plans need dependencies enabled but I also ne…Using Smartsheet170Niyati Kumar
-
Answered - Pending Review Tamara Diver 13 views 5 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 07/10/20,Last post 07/13/20I'm trying to create Summary Reports but only ever receive the created date/name, modified date/name and sheet name columns to select from to add to the report. I've tried saving and going back in but no luck. The sheets I'm selecting all …Using Smartsheet135Tamara Diver
-
Conditional Formatting queryQuestionFirst post 07/10/20,Last post 07/10/20I have 3 columns - Monthly Budget, Budget YTD and Total Spent YTD. I want any cells in the 'Total Spent YTD' column that are greater than the adjacent cells in the 'Budget YTD' column to highlight in a different colour. I don't seem to be …Using Smartsheet81TeeM
-
Conditional FormatingQuestionFirst post 07/09/20,Last post 07/10/20I need help creating (2) condition in conditional formatting or a formulas that turns do the following; highlight all rows that are are between 3 and 5 days in the future from today's date highlight all rows that are more than 5 days in th…Using Smartsheet10124
-
First post 07/09/20,Last post 07/10/20Hi, I currently have an Expiration Column date, and I need to set up an alert for when the expiration date is within the next 30 days. I browsed the forum and noticed someone had a similar ask, and was told to insert another column with th…Using Smartsheet102yheng
-
Custom sortingQuestionAnswered - Pending Review Tanya Brooks 9 views 1 comment 0 points Most recent by RossL Using SmartsheetFirst post 07/09/20,Last post 07/09/20HI - Anyone know if it is possible to create a custom sort in smartsheet? Example, in column “Title” I have the following values: · Assistant Professor · Associate Professor · Instructor · Professor If I sort by title a…Using Smartsheet91Tanya Brooks
