Join the Smartsheet Community
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
-
Is it possible to change the definitions attached to the symbols?In Using SmartsheetTo make it easier when asking others to complete a form, is it possible to change the 'Yes, No, Hold' definitions?
-
Lost with vlookup or matching?In Formulas and FunctionsI am needing to update a Smartsheet to reflect the date listed in a cell from another Smartsheet. Both sheets have an IP address that can be match on as there are no duplicates. The feeder sheet with the date has 210 entries and master she…
-
copying row to top of another sheet via automationIn Using SmartsheetHello, I have an automation in place that copies a row from one sheet to a secondary sheet but adds it to the bottom. As we're using this for a new hire process, I'd like the row to be added to the top of the sheet when copied. I have a co…
-
Data Shuttle to import Children rows based on another column?In Premium Apps and IntegrationsSo we have Assets in Smartsheet that are part of a Project sheet. For each type of Asset (Asset Type is it's own dropdown column), I would like to pull in a set of 'steps' (children) from another Smartsheet or some source file. So if the A…Answered - Pending Review 1 view 2 comments 0 points Most recent by Jeana Premium Apps and Integrations
-
How to create this COUNTIFS with AND/OR/NOTIn Formulas and FunctionsI cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No", @cell <> "…
-
Daily Emails / Sheet Change Emails TimeIn Using SmartsheetWe're having a client, who pays around $40k a year to Smartsheet looking at alternatives now, because the emails are getting out of hand and being at 11pm. So they're being bombarded with a ton of alerts waking up some on-call employees in…
-
IF Function for multiple valuesIn Formulas and FunctionsCan someone please help me with the formula where if the column1 has any value from the list (i.e. test1, test2, test3, test4) the output should be "Test Result". I tried this with the formula =IF([Column1]@row, = "Test1&quo…
-
Can workflows include rules to move rows only if not present on the recipeint sheet?In Using SmartsheetHi, I am creating a "customer information system", where the customer will fill out a form with contact information ext. It will populate a sheet with added info including ticketnumber and delivery document information. I want to…
-
Linking Two Sheets to update dynamically When columns are added and removed.In Formulas and FunctionsI have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5 I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were…
-
¿Hay manera de distinguir si una fila es subtarea o no?In Formulas and FunctionsQuiero que en una columna se muestre un icono sólo si la fila no tiene subtareas ¿es posible con una fórmula? Gracias
