Discussion List

  • Workaround for Sheet Reference Limit?
    In Using Smartsheet
    Hi everyone, On our project we have two sheets, a project plan which contains around 50 items, each containing around 9 sublevel actions. We have a separate sheet that we were manually maintaining in excel containing all of these sublevel …
    Answered - Pending Review
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Devin Lee Using Smartsheet
  • How to include an if statement
    In Formulas and Functions
    I have a vlookup formula. =VLOOKUP([Attribute Name]@row, {Standards List - Enhanced - Business Rules Range 1}, 4, false) . I need to be able to use this formula and check another column based on the version number. I need it to pull in x i…
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Forms with formulas
    In Formulas and Functions
    I'd like to include a formula (hidden) in a Form that includes a vlookup to another sheet with known email addresses. This would save the user time on entering their email when completing the form. The email is used to contact them back th…
    2714 16
    2.7K views 16 comments Most recent by Jennifer Whittemore Formulas and Functions
  • Sub tasks appearing in an Uncategorised column
    In Using Smartsheet
    When I setup sub tasks in Smartsheets Card view, they appear in an Uncategorised column as separate cards. How do I stop this? Thanks
    12 3
    Accepted Answer 12 views 3 comments Most recent by Genevieve P. Using Smartsheet
  • Remove the "0" in the column formula cell.
    In Formulas and Functions
    Help please! I am trying to put the item name (column name) in a cell if it's listed as "Complete". This is working for the most part, but if none of my IF criteria matches, it shows a "0" in the cell or if only the las…
    2 2
    Accepted Answer 2 views 2 comments Most recent by Kayla Formulas and Functions
  • Dashboard Chart Widget Axis changes with each refresh
    In Formulas and Functions
    The axis label on the dashboard chart widgets consistently changes with each refresh and will not maintain the order that it is in on the Report. This is pulling from a summary report. Occurring on a monthly report widget and quarterly. …
    34 3
    Accepted Answer 34 views 3 comments Most recent by Kayla Formulas and Functions
  • Formula to add "No" to a blank cell, but leave value if not blank
    In Formulas and Functions
    On a Smartsheet project intake form, I have several Yes or No dropdown selections. If Yes, the user must answer additional questions. If No, they do not and those cells are left blank. Auditors do not like Blank cells, so I'm looking fo…
    13 5
    Accepted Answer 13 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Calculate the time between two dates by days, hours and minutes
    In Formulas and Functions
    Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
    2651 26
    2.7K views 26 comments Most recent by Julie Barbeau Formulas and Functions
  • Access Issues with Smartsheets?
    In Using Smartsheet
    Hi All, I have a paid license on Smartsheets and need to invite free users to certain spaces/documents to collaborate on work documents. However, when I share to users (both free and paid) with admin or editor access, they can't edit the d…
    Answered - Pending Review
    14 5
    Answered - Pending Review 14 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • How can I share a report to an user without sharing him paper, source of report?
    In Using Smartsheet
    I would share some data in a report with an user but I do not want share with him the paper, source of report. The aim is to use report as a tool able to visualize data for all users and to track and modify data on a paper used only by our…
    13 2
    Accepted Answer 13 views 2 comments Most recent by giusece Using Smartsheet