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
-
Answered - Pending Review Vladislav Lehelt 41 views 2 comments 0 points Most recent by Genevieve P API & DevelopersFirst post 05/20/20,Last post 05/27/20differs = do not work Project: https://app.smartsheet.com/b/publish?EQBCT=f76e6458a3f64d7d8186be3ed70674ce In UI critical path contains more then 20 rows. For example #6,#7,#8,#9, etc. In API I see only two elements. #44 and #45. I checked…API & Developers412Vladislav Lehelt
-
Answered - Pending Review Lawrence West 31 views 13 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 05/19/20,Last post 05/27/20I use conditional formatting. When I review the dashboard, the formatting doesn't update until I go to the sheet and save. I would like the sheet to save automatically when conditional formatting makes changes. Thank You.Using Smartsheet3113Lawrence West -
Answered - Pending Review Garrett Ricker 30 views 2 comments 0 points Most recent by Emma Smyth Formulas and FunctionsFirst post 04/29/20,Last post 05/27/20https://us.v-cdn.net/6031209/uploads/046/RFT8B36MG9ZR.pdfFormulas and Functions302Garrett Ricker
-
Answered - Pending Review Oscar Velandia 16 views 3 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/25/20,Last post 05/27/20Hi guys We have a source sheet that creates new rows ( sequentially) when new information is added. this source sheet is the master source for different departments. When a new row is added in the source sheet that has to do with my depart…Using Smartsheet163Oscar Velandia
-
Answered - Pending Review Sarah Ko 11 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/26/20,Last post 05/27/20Hi there, I just wanted to clarify that the limit (250 MB for Licensed user) is based on the full sheet storage, correct? Not per upload? I'm a licensed user and am creating an intake/approval form that would allow others from aro…Using Smartsheet111Sarah Ko
-
First post 05/26/20,Last post 05/27/20I have a set number of tasks that individuals are expected to complete for each day, week and month. I have combined all of the tasks to show a percent of tasks completed. however, the issue with is this approach is that it does not acco…Formulas and Functions150Ron Geiser
-
Answered - Pending Review Sara Lindquist 13 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/26/20,Last post 05/27/20I have 25 sheets that need to have the permission level changed for about 25-50 users per sheet. Is there way to do this all at once, or do I have to check each person on each sheet to viewer access?Using Smartsheet131Sara Lindquist
-
Connector to Qlik sense softwareAccepted AnswerAccepted Answer Gustavo Tonielo 10 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/26/20,Last post 05/27/20Dear all, Have someone already connected Smartsheet to the Qlik sense software? Thanks in advance, Gustavo TonieloUsing Smartsheet101Gustavo Tonielo -
Answered - Pending Review Simon Cusack (CCHD) 13 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/26/20,Last post 05/27/20When printing across two pages, can I repeat the columns with task, duration, start and end date, etc on each page.Using Smartsheet131Simon Cusack (CCHD)
-
How do I get a formula cell to return to blank when the corresponding cells don't have any values?Accepted AnswerAccepted Answer Liz Zofka 8 views 5 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 05/27/20,Last post 05/27/20I am using the formula below to calculate the number of years between today's date and a persons start date in another column. =(TODAY() - [Start Date at TDG]1) / 365 If the start date has not been entered, the Years @ Company cell is sh…Formulas and Functions85Liz Zofka
-
Answered - Pending Review Julia Peterson 11 views 3 comments 0 points Most recent by Andrée Starå Premium Apps and IntegrationsFirst post 05/27/20,Last post 05/27/20Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be abl…Premium Apps and Integrations113Julia Peterson
-
Vlookup to another sheet and the use of @cell / @rowAccepted AnswerFirst post 05/19/20,Last post 05/27/20Hi, I'm using a Vlookup formula (=VLOOKUP(true, {ABC Range 3}, 3, false)) to get back information from another sheet (ABC) only when a row is flagged. When dragging the current formula I only manage to get the value from the first row tha…Formulas and Functions5426Joh
-
Answered - Pending Review Brian_Vaughan 30 views 4 comments 0 points Most recent by Brian_Vaughan Formulas and FunctionsFirst post 05/20/20,Last post 05/27/20Hi All! I am using a =Count(Distinct({Range})) which works exactly as expected with one range of data, but returns a "1" with the exact same formula on an adjacent column of data. The only difference between the data in the 2 c…Formulas and Functions304Brian_Vaughan
-
Automated Workflow or Assign Tasks to prioritise requestsAccepted AnswerFirst post 05/27/20,Last post 05/27/20Hi, I am hoping someone can assist me! I have a smartsheet which contains capital requests received from Local Governments (via a grant application process). I have included a ‘region’ column & ‘regional contact’ (contact list) column…Using Smartsheet145Natasha D
-
VLOOKUP Multiple MatchesAccepted AnswerAccepted Answer Dennis Wierzbicki 39 views 18 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/21/20,Last post 05/27/20I have a table that sometimes has duplicate entries in a column. I'm doing a VLOOKUP on this column, however, obviously, if there is more than one match, this generates an error. What I'd like to do is return a match for the most recent d…Formulas and Functions3918Dennis Wierzbicki
-
Answered - Pending Review Donna T 17 views 3 comments 0 points Most recent by Andrée Starå Using SmartsheetFirst post 05/19/20,Last post 05/27/20I am using the Communications template Smartsheet has available. I modified the categories to suit them to our business. I went into Report Builder to modify the report and the categories do not appear to select. Just for testing's sake…Using Smartsheet173Donna T
-
Can't perform date calculations on a Date returned by a cross sheet JOIN(COLLECT(VLOOKUP functionQuestionAnswered - Pending Review Kevin Segrist 17 views 9 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/26/20,Last post 05/27/20Hi, To populate DueDate3, I'm using: =JOIN(COLLECT({GUT Column 7}, {GUT Column 2}, <>"Postponed", {GUT Column 2}, <>"Rescheduled", {GUT Column 1}, VLOOKUP(TaskName1, {GUT Column 1}, 1, false))) to return a…Formulas and Functions179Kevin Segrist
-
How can I count the amount of actions in one specific month?Accepted AnswerAccepted Answer Carolina Rivera 12 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/27/20,Last post 05/27/20Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month (May), I want the counter to return "5". I've been trying to use the formula below but all I get in return…Formulas and Functions123Carolina Rivera
-
Answered - Pending Review Carolina Rivera 14 views 1 comment 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/26/20,Last post 05/27/20Hi, I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month, I want the counter to return "5". I've been trying to use the formula below but all I get in return is a…Formulas and Functions141Carolina Rivera
-
Answered - Pending Review Beronica Muller 55 views 8 comments 0 points Most recent by Beronica Muller Formulas and FunctionsFirst post 04/17/20,Last post 05/27/20Hello, I need assistance with creating a formula to produce a weekly and monthly report from my Smartsheet? I will need to provide a weekly report containing total number of request received for the week, also how many were completed, stil…Formulas and Functions558Beronica Muller
-
Count Formula to total percentageAccepted AnswerAccepted Answer Virtual Assistant 13 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 05/26/20,Last post 05/27/20I'm trying to get the overall total of percentage on all % of Project Done but it's working (77%) I'm using the count functionality as it's not working when I use AVG. Count formula I'm using. Overall total when i use microsoft spreadshee…Formulas and Functions133Virtual Assistant
-
Answered - Pending Review Cassie Hart 12 views 2 comments 0 points Most recent by Cassie Hart Formulas and FunctionsFirst post 05/27/20,Last post 05/27/20Hello! I am trying to calculate the amount of times a cell dropdown is changed per day. Is this even possible or would it need some magic workaround? In any given day the "current stage" column changes possibly many times. An exa…Formulas and Functions122Cassie Hart
-
First post 12/06/19,Last post 05/27/20Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project. Most of the reports and dashboards I've tried to crea…Using Smartsheet3209Fairorth
-
Answered - Pending Review torcengineering66646 49 views 7 comments 0 points Most recent by SmartSheet Management Using SmartsheetFirst post 02/29/20,Last post 05/27/20Hello, I have two sheets, Quotations and Work Orders. I would like to create an automation that copies a Quotation row to the Work Orders sheet when that row's Status is changed to "Ordered". As I use different Quotation numbers…Using Smartsheet497torcengineering66646 -
Pull license details using APIQuestionAnswered - Pending Review ycd 9 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/24/20,Last post 05/27/20Does smartsheet have APIs to pull license details? I am looking for the *Total number of purchased licenses by our Org/Domain. I am currently pulling the number of assigned licenses using REST API by looking up the User object's attribute …Using Smartsheet91ycd
-
Lotus Notes ConnectionQuestionAnswered - Pending Review Lianne Fernandes 14 views 1 comment 0 points Most recent by Genevieve P Using SmartsheetFirst post 05/22/20,Last post 05/27/20Hi, Is there a calendar connector between SmartSheet and Lotus Notes 9.0? I looked on previous posts however there is no information provided or the links no longer work. Thanks.Using Smartsheet141Lianne Fernandes
-
Answered - Pending Review JHand 11 views 1 comment 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 05/26/20,Last post 05/27/20I am writing a simple COUNTIFS formula and I am getting a very different answer when I created a column reference vs. referencing a specific range within the column. What am I missing? I am trying to count the number of customers that ar…Formulas and Functions111JHand
-
Assign formulaQuestionAnswered - Pending Review Karla Tovar 9 views 1 comment 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 05/26/20,Last post 05/27/20Hello, I'm trying to get a count or sum of my team resources and having can't find the formula - help!Formulas and Functions91Karla Tovar
-
First post 05/26/20,Last post 05/27/20Hello Developers, I was recently using Smartsheet on my mobile phone and found this really frustrating bug, I hope you guys fix it soon or if I'm doing something wrong and there is already way to fix this, then please please let me know! P…API & Developers121Amit Wadhwani
