Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Technology
Discussion List
-
First post 08/28/19,Last post 01/23/20Sheet 1: Work Scheduled (number of work units scheduled in a given month) Sheet 2: Budgeted Cost of Work Scheduled (to determine the total cost of the work scheduled in a given month) I would like to multiply a cell from Sheet 2 with the…Formulas and Functions24116JoeS -
First post 02/20/18,Last post 01/20/20Is there a way to set a particular field to accept more than 4000 characters? We use SS for managing projects and the "Notes" field we have established is where we run into issues. On occasion, we need more than 4000 characters.Using Smartsheet1017KMart
-
Proofing- Previous VersionsAccepted AnswerAccepted Answer Conner Sherman 40 views 10 comments 0 points Most recent by Conner Sherman Using SmartsheetFirst post 11/28/19,Last post 01/14/20Hello everyone, I have been using the proofing feature in our team for internal proofing. I have an issue where as soon as you add a new document version, the previous versions are no longer visible they sit loading. You can still down…Using Smartsheet4010Conner Sherman
-
#INCORRECT ARGUMENT SETAccepted AnswerAccepted Answer Amanda Chu 240 views 15 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 03/13/19,Last post 01/13/20Hello, I cannot figure out why this SUMIFS is not working. When I break up the SUMIF criteria, they both work fine. But when I put them together, I get #INCORRECT ARGUMENT SET error message. =SUMIFS({MH Client Profiles v2 Range 13}, &quo…Formulas and Functions24015Amanda Chu
-
First post 09/16/19,Last post 01/11/20Thought I would start my own thread regarding this since it seems very quiet around this change. Am I the only one having no luck in using the suggested shortcut CTRL ] to indent? I am using Windows 10, Chrome webbrowser and swedish keyb…Using Smartsheet258Mattias
-
First post 11/18/19,Last post 01/10/20First of all, english is not my native langage, please excuse my mistakes. Hello all, I have a smartsheet with several external counterparts (customers and providers). I manage the smartsheet which is not shared and nobody is able …Using Smartsheet334François Cales
-
First post 08/21/18,Last post 01/08/20Has anyone received this error message before? What are the options for large data? (Image)Using Smartsheet729David Skinner -
First post 11/07/19,Last post 01/03/20My company is using a Smartsheet which uses custom columns fed by a request form. The purpose of this sheet is to process and track product enhancement requests, and occasionally we will migrate JIRA tickets into the process as well, whic…API & Developers322AllenG
-
First post 07/25/19,Last post 01/02/20I've seen so many examples of "Nesting IF" formulas for changing a Harvey Ball to a different color based off of multiple numeric or date scenarios. What I haven't come across is a way to change the ball color based off of verbia…Formulas and Functions7212Athena Hathaway -
First post 10/11/18,Last post 12/30/19As a new user, I found that the % Allocation column does not respond to input from the Duration column, as seems intuitive to me. After reviewing community comments, I find that the % Allocation functionality in Smartsheet does not actual…Using Smartsheet683EdL
-
First post 01/28/19,Last post 12/29/19Hello, I have a need to be able to highlight if a range of dates falls between any other range of dates. I have a checkbox column which needs to be ticked if a range of dates conflicts with other range of dates. So for example, we might…Formulas and Functions596samanthabooty
-
First post 03/14/19,Last post 12/26/19I'd like to request Smartsheet look into adding the "auto-refresh" feature, currently only available on Dashboards, to Reports. We use reports to filter columns for individuals in teams that share a sheet, but who don't need t…Using Smartsheet785Colin Entrekin
-
First post 01/05/18,Last post 12/19/19Is there a formula I can use that would show the last date that a specific column was updated? For instance, when someone checks the checkbox column, could I have a formula in another column that would reflect the date the checkbox was che…Formulas and Functions867Darren McCrea -
First post 09/03/19,Last post 12/17/19Has any one here done an integration with ConnectWise? We have a small company whose resources all work production support and project tickets. If I had a way to feed tickets from CW in so that I could display all open tasks for one perso…Premium Apps and Integrations454Jacque214
-
First post 04/30/15,Last post 12/12/19When using webforms and submitter puts in their name, if their name is already in contacts it doesn't match to contacts name. So you end up with a new name entry the same as an already existing name in your contacts column. Could they be…Archived 2015 Posts4442Mark Bonham
-
First post 04/18/19,Last post 12/12/19Does anyone know how to create a calendar that allows multiple entries per day, and shows time slots such as a meeting for example? Basically looking for a calendar in smartsheet that resembles an Outlook calendar that I can use on a Dash…Using Smartsheet514kdougan85961
-
First post 10/02/19,Last post 12/12/19I would like to know if it's possible to create a form template associated with a Smartsheet. The purpose of this form would be to collect requirements for a request that a client enters into a Smartsheet. The client would access templat…Using Smartsheet313ssimos21791
-
First post 09/19/18,Last post 12/08/19I've reached out to our account manager and also sent a request via the web form, but have not heard back from anyone. What I've been looking for is the "Template Set" for the Product Testing solution (Test Plan, Test Log, Bug Tr…Using Smartsheet394Peterhvh
-
First post 12/06/19,Last post 12/08/19Hi All, I need some CountIFS help with counting dates, I have a sheet that has a column called Device that has either New or Existing. Then my second column is Date Installed. If the Device is New and the Date Installed has a date then I …Formulas and Functions351Chris Trumpey -
First post 12/04/19,Last post 12/08/19Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" Here's …Formulas and Functions366lisarae723
-
First post 08/09/17,Last post 12/06/19I am wanting to use smartsheet alerts to email me each day with tasks that are due and not completed. However they don't always come through each day despite it having the right set up To do this I use a form to add new tasks and then inc…Archived 2017 Posts296Ben W
-
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions352KDub618
-
First post 10/14/19,Last post 12/04/19Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?Using Smartsheet284Michael Lockwood
-
First post 12/03/19,Last post 12/04/19My data input sheet has several columns that are Multi-select dropdowns. For my Metrics summary page, I am struggling with COUNTIF when the user has selected multiple options. Example of options in the Multi-selection dropdown: * Apple *…Formulas and Functions641MJayMay -
First post 12/04/19,Last post 12/04/19I have a multi column Smartsheet that tracks items by date. Part of the functionality shows the number of days the item has been active:- =IF(OR([S.Status]5 = 3, [S.Status]5 = 1), TODAY(0) - [Start Date]5) There is also a check box col…Formulas and Functions331mo'connor113211 -
First post 12/03/19,Last post 12/04/19Hi, I have been asked to create a roster that covers customer support across different time zones and shows who is available (human resources), who is on leave, time, names of the support person and who is on call. Also, includes …Formulas and Functions231Chuck Perez
-
First post 05/13/19,Last post 12/03/19I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - w…Using Smartsheet938latsyrcg3
-
First post 12/02/19,Last post 12/03/19Hi there, I'm learning Smartsheet, so apologies in advance for the basic question. Is it possible to populate the Sheet Summary via a Form? If so, how? We have a sheet we want to create with minimal structural information in place, and t…Using Smartsheet306ryanhnelson
-
First post 12/02/19,Last post 12/02/19Smartsheet appears to be a little slow today in updating charts, reports, etc. and with accurate data. Wondering if this is an anomaly or if this is due to a more global impact from Cyber Monday.Using Smartsheet251April Thornton
-
First post 12/02/19,Last post 12/02/19Hello Team, I would like to know how to enable or create smartsheet to send automated birthday emails with customised template to employees in my org, on their birthdays. aprriciate for the helpUsing Smartsheet282mitta.nithin112911
