Recent Discussions
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
First post 05/25/20,Last post 05/25/20I have a cell with a dropdown list, I want that smartsheet memorizes the date when I go from one option of the dropdown list to another one. I have no idea how to do it Thanks for your helpUsing Smartsheet81Oscar Velandia -
First post 07/19/19,Last post 05/25/20Hi Smartsheet Team, I am new to your tool and so far I find it very intriguing. I have a question though: We have organized our files in sharepoint libraries. And while I was happy to see the OneDrive support in smartsheet, I was a lit…Using Smartsheet1263Habsi1
-
Accepted Answer JDen 58 views 7 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/18/20,Last post 05/25/20Good morning everyone. I have a sheet linked to a request form which based on the info submitted needs to be approved by a number of people. I have 14 approval workflows, based on country of the requestor, the total amount requested, and o…Formulas and Functions587JDen
-
Function AVERAGE CHILDREN excluding some "childen"Accepted AnswerAccepted Answer Julie Barbeau 8 views 2 comments 0 points Most recent by Julie Barbeau Formulas and FunctionsFirst post 05/25/20,Last post 05/25/20I have a problem with formula "Average Children". In my example below, when there is no cost so % is 0%, it's included in the average of children but should not. In this case, on the third row "3%" should be 23% and in …Formulas and Functions82Julie Barbeau
-
How to create a template smartsheets which all deadline dates change automatically to the new yearQuestionAnswered - Pending Review Marco de Oliveira 22 views 7 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/23/20,Last post 05/25/20I have a working document that I would like to create a template for so that all deadline dates change the year automatically when the new calendar year begins. The month and day must remain the same, just the year must change based on the…Using Smartsheet227Marco de Oliveira
-
Answered - Pending Review Snigdha Singh 15 views 1 comment 0 points Most recent by Genevieve P API & DevelopersFirst post 05/20/20,Last post 05/25/20I have build a webpage that uploads attachments to a row in smartsheet. It works fine for 12 MB file. But I have been trying to upload a file which is 100MB via API to a row, but everytime I get below error: {"response": {"s…API & Developers151Snigdha Singh
-
Health Color Bubbles Tied to % Completion & DatesAccepted AnswerAccepted Answer Lauren Smith 27 views 6 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 04/23/20,Last post 05/25/20Hellow, I am trying to take the following plan with the follow formula to follow these rules and am stuck. Disclaiming not the best at the large multi conditional formulas yet. I use the Health Column bubbles RYGB If a task has 0 % Comp…Formulas and Functions276Lauren Smith
-
Accepted Answer Marco de Oliveira 15 views 2 comments 0 points Most recent by Marco de Oliveira Formulas and FunctionsFirst post 05/23/20,Last post 05/25/20I have a document that is setup per client as the primary column. Each client row represents a task to complete audited financials each year for each client. Each column from left to right represents a sub-task during the audit process out…Formulas and Functions152Marco de Oliveira
-
IF Statement with cell either blank or with any dateAccepted AnswerAccepted Answer Marco de Oliveira 14 views 2 comments 0 points Most recent by Marco de Oliveira Formulas and FunctionsFirst post 05/23/20,Last post 05/25/20Hi everyone Please can you assist me with correcting this formula? I have a column 1st queries received that is locked to dates only. This formula is for the health status column. If the deadline is in the future, then the health status m…Formulas and Functions142Marco de Oliveira
-
[email protected] 27 views 1 comment 0 points Most recent by Genevieve P Premium Apps and IntegrationsFirst post 05/19/20,Last post 05/25/20We setup a Smartsheet Admin account so that there is no one person owning the Data Uploader scripts, but rather this shared account. This works well. In addition, we have a different OneDrive sign in that we need to use to pull the file(s)…Premium Apps and Integrations271[email protected]
-
Forms duration stampAccepted AnswerFirst post 05/22/20,Last post 05/25/20Is there a way to add a START and END timestamp to the Form/Sheet that will enable me to determine the duration it has taken for each respondent to complete the form?Using Smartsheet145Marijan
-
Licence Visibility as a SysAdminQuestionAnswered - Pending Review Tony Slater 13 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/22/20,Last post 05/25/20Hi, I was wondering if it's possible as the SysAdmin, to see the number of available licences on our Enterprise account. I can see how many are actively being used but not how many are currently free for use. Cheers TonyUsing Smartsheet133Tony Slater
-
UnparseableAccepted AnswerAccepted Answer Lenya McGrath 22 views 6 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/23/20,Last post 05/25/20Hi, I'm trying assign a number to the $ symbol. I'm using this formula: =IF(6_state_$ = "Empty", 0, 6_state_$ = "One", 1, IF(6_state_$ = "Two", 2, IF(6_state_$ = "Three", 3, IF(6_state_$ = "Four…Formulas and Functions226Lenya McGrath
-
First post 05/20/20,Last post 05/25/20Hello, Working days and non-working days are configurable on sheet-level and account-level, but I wonder whether we can configure that on the organization-level. I want to set the default non-working days and public holidays for my organi…Using Smartsheet171Sam Ng
-
Answered - Pending Review Simon England 14 views 1 comment 0 points Most recent by Ramzi Using SmartsheetFirst post 05/20/20,Last post 05/25/20We have time shown in resource view for an operative, the sheet from which the allocation is coming from doesn't have any sign of the said allocation. Everything is largely complete with most things marked to 100% and complete, the rest o…Using Smartsheet141Simon England
-
Returning entire rowQuestionAnswered - Pending Review Kuldeep Gera 14 views 2 comments 0 points Most recent by Kuldeep Gera Formulas and FunctionsFirst post 05/23/20,Last post 05/25/20I want to Pull Data from a sheet name (Daily Sales Sheet) to another sheet (Payable). https://us.v-cdn.net/6031209/uploads/E73T4HVD5Y0D/image.png https://us.v-cdn.net/6031209/uploads/NHOICNDZE53E/image.png This is the entire row from Dail…Formulas and Functions142Kuldeep Gera
-
First post 06/01/18,Last post 05/24/20Is there an easy way to populate the preferred dropdown choices in a Contact List? If I had 50 (the limit), mentioned here https://help.smartsheet.com/articles/504619-column-types#contactlist do I need to select them one by one? No imp…Using Smartsheet1293J. Craig Williams -
First post 05/30/18,Last post 05/24/20Is there a setting that would allow "Viewer" users to add comments, but not change any fields? I have users entering records via a Form, but once the Form is submitted I need to lock all of the fields except the "Comments&q…Using Smartsheet2389AverageUser -
Answered - Pending Review Sheila Mullen 13 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/21/20,Last post 05/24/20How do you set up the calendar (from the calendar app) imported via the web content widget to open in another window?Using Smartsheet131Sheila Mullen
-
Answered - Pending Review Sheila Mullen 13 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/21/20,Last post 05/24/20How do I make the calendar (from calendar app) automatically resize to fit the space on the dashboard? https://us.v-cdn.net/6031209/uploads/0PD009JHVS10/ss-calendar-on-dashboard-jpg.jpgUsing Smartsheet131Sheila Mullen
-
Creating a new GroupQuestionAnswered - Pending Review StephanieR 22 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/21/20,Last post 05/24/20Good Morning, I use groups to give staff access to the different sheets that I build, it makes giving large numbers of staff access to a sheet very easy. But...today I tried to create a group the way I have in the past, "Group Managem…Using Smartsheet221StephanieR
-
Answered - Pending Review Sheila Mullen 15 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/21/20,Last post 05/24/20Is there a limit to the number of characters a rich text widget can contain? The client wants to type information directly into the rich text box instead of using a sheet or form yet doesn't want to lose previous information.Using Smartsheet151Sheila Mullen
-
Automatically Collapse Empty Card View LanesAccepted AnswerFirst post 05/21/20,Last post 05/24/20Hi All, I have been foraying into the wide world of SmartSheet card view. I was wondering if anyone knows if it is possible to automatically collapse the empty lanes? I have lanes that I have "listed" in the drop down that I anti…Using Smartsheet121Shesha_K -
Answered - Pending Review Ryan Nix 19 views 1 comment 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/22/20,Last post 05/24/20Good afternoon everyone, I was curious to know what everyone's best practices are when it comes to managing a large number of reports and how to implement holistic changes? We have dashboards designed for multiple locations and in those da…Using Smartsheet191Ryan Nix
-
Answered - Pending Review Frank Smith 15 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/20/20,Last post 05/24/20Process starts with a form, and information is added to main sheet. The forms allows the user to select a category and want to copy that row information to a separate category sheet and keep the information in the main sheet. Do not want t…Using Smartsheet153Frank Smith
-
Answered - Pending Review Mike Mitchell 16 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/20/20,Last post 05/24/20I want to create a custom ID column from contents coming from a Formstack integration. Submitter email plus submission time from the form will make each row ID unique as they are added, and also have meaning to the users of the sheet. To …Formulas and Functions163Mike Mitchell
-
First post 05/24/20,Last post 05/24/20Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sh…Formulas and Functions250Andrée Starå -
Answered - Pending Review Anthony Soyak 13 views 1 comment 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/23/20,Last post 05/24/20Hello! I am in need of help writing a formula to auto-calculate the "% Complete" column based on the "Start" column date and "Finish" column date. Additionally, I also have an auto column for "Duration&qu…Formulas and Functions131Anthony Soyak
-
How to Capture 1st Child to Change?Accepted AnswerAccepted Answer SYSPK 19 views 4 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/17/20,Last post 05/24/20I have child rows that will change status colors. Once it changes, it remains that color. I'd like to find out which child changed first. Is there a way to do that? Thank you https://us.v-cdn.net/6031209/uploads/069/FGSZ1NJYF9N9.pngFormulas and Functions194SYSPK -
Multiple conditions with IF and PARENT ()Accepted AnswerAccepted Answer Jean Kim 11 views 2 comments 0 points Most recent by Jean Kim Formulas and FunctionsFirst post 05/23/20,Last post 05/23/20Trying to get multiple conditions working with IF + PARENT () If formula works when it's used alone. =IF([email protected] = "task", "") -> Works =IF([email protected] = "subtask", PARENT([email protected])) -> Works How…Formulas and Functions112Jean Kim
