Discussion List

  • Is there a way to recover a deleted user?
    In Using Smartsheet
    Someone was termed who shouldn't have been termed and their account was deleted. Is there a way to recover a list of all the smartsheets that were shared with her or recover the smartsheets shared to her? Her owned sheets are fine as they …
    10 1
    Accepted Answer 10 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Having Issue with "COUNTIF" returns "0"
    In Formulas and Functions
    Hi Guys, I have to count the status. Let's assume I have 5 different statuses (0,1,2,3,4) in another sheet. I have prepared a separate metric sheet to count the status specifically for a date range but I got the result as "0" for…
    Answered - Pending Review
    21 3
    Answered - Pending Review 21 views 3 comments Most recent by Malaina Hudson Formulas and Functions
  • Calendar Displaying blank fields
    In Formulas and Functions
    I am trying to create a smartsheet calendar off a workplan, and am running into the following issue. I don't need all the items from the workplan to populate on the calendar. My main column is [task name], and for some rows, I have an asso…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Genevieve P Formulas and Functions
  • Can you automate attachment exporting?
    In Using Smartsheet
    We can export sheet data automatically using tools like Power Query but is there a way to get attachments out of smartsheet and into our server? Or is this something that needs to be done by hand? Thanks
    11 0
    Question 11 views 0 comments Started by Lucas Argueza Using Smartsheet
  • Auto-Number/System field Created (Date) changes back to "Date" field
    In Formulas and Functions
    I have an Auto-Number/System field called "Date Submitted" as Created (Date). This is used on the manual form (which we are phasing out) and also to capture any new rows that come in from Salesforce sync. For some crazy reason it…
    11 5
    Accepted Answer 11 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Require people outside my organization to log on to access form
    In Using Smartsheet
    Hi, I created a custom form to be filled by a team outside our organization, but I want them to sign in. How do they signup for Smartsheet as free users, to be able to fill in the form. Thank you
    16 2
    Accepted Answer 16 views 2 comments Most recent by Ana Sainz Using Smartsheet
  • Smartsheet - Procore & Cyberco Sync
    In Premium Apps and Integrations
    We just started creating schedules in Smartsheet and are trying to sync them to Procore via Cyberco and running into issues. Cyberco's site is vague with little in ways support material. Would love to hear some experiences / input on this …
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Chris Mondeau Premium Apps and Integrations
  • Help With Collect Function
    In Formulas and Functions
    I have a sheet that has three columns - DueDate, Status and "Status by Color" respectively. Based on the entries in the status column the "Status by Color" cell is assigned the color Red, Green or Blue. My need is to …
    Answered - Pending Review
    363 5
    Answered - Pending Review 363 views 5 comments Most recent by Chamudi Withanawasam Formulas and Functions
  • Convert text date, to date 2018-04-18
    In Formulas and Functions
    I have a primary field that contains date information and I need to convert it to a date, so that I can compare it against another date field.     The format of the text date is 2018-04-18, and I need to convert it to a date, and cannot …
    664 3
    664 views 3 comments Most recent by jg124 Formulas and Functions
  • The correct VLOOPUP formula?
    In Formulas and Functions
    Hello I am needing a formula that will pull an employee level and assign it to the alias listed. I have used differed variations of VLOOKUP and nothing seems to work. Breakdown: Sheet #1 will contain a list of an employee alias's, sometime…
    Answered - Pending Review
    28 7
    Answered - Pending Review 28 views 7 comments Most recent by BCK Team Formulas and Functions