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

  • Disappearing Formulas in Locked Column
    In Formulas and Functions
    I have a locked column with a formula used for a calculation. The formula is dragged all the way down. The formula keeps disappearing within blank cells. The activity log says it is changed by cell link. I keep dragging down the formu…
    Accepted
    1 7
    Accepted Answer 1 view 7 comments Most recent by Andrée Starå Formulas and Functions
  • Can you search for a column name?
    In Using Smartsheet
    I can't find an answer to this question which means it is likely obvoius to everyone but me: can the search function search for column names? I'm trying to clean up our sheets so that reports work, but there are almost 200 unique column ti…
    Answered - Pending Review
    1 1
    Answered - Pending Review 1 view 1 comment Most recent by Andrée Starå Using Smartsheet
  • Copy Rows Automation - Only certain columns?
    In Using Smartsheet
    When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row? If not, is there a way to then take the output sheet data and cross reference to matching rows in a third sheet, and can I build furt…
    Answered - Pending Review
    101 5
    Answered - Pending Review 101 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Proofing File Never Loads
    In Using Smartsheet
    We decided to experiment with proofing to see if it might meet a need for our organization. I setup a blank sheet, enabled proofing, and added a single proof by clicking in the proof column and uploading a 4MB PDF. The file uploaded, but…
    Answered - Pending Review
    3 13
    Answered - Pending Review 3 views 13 comments Most recent by Andrée Starå Using Smartsheet
  • Text Wrapping is not working.
    In Using Smartsheet
    Hi, I've created a new sheet and a form, I've applied text wrap to the columns that might need it and I've tested certain cells, inputting more text than the cell than would be visible.  I've clicked an unclicked the text wrap button on t…
    457 views 7 comments Most recent by Sarah Newhouse Using Smartsheet
  • Departmental Ticketing System
    In Using Smartsheet
    I'm looking to merge several of our ticketing request forms into one form, such as maintenance requests, IT requests, and marketing requests. Based on the type of request, automation would be set to move those rows to another sheet for the…
    Answered - Pending Review
    11 7
    Answered - Pending Review 11 views 7 comments Most recent by Ramzi K Using Smartsheet
  • Why are unlicensed users asked to upgrade to Premium?
    In Using Smartsheet
    Hi there, Not sure whether this is request for change or an error in our licensing/configuration, but the unlicensed users in our configuration see a message that reads "You have limited access to Smartsheet. Upgrade to use premium fe…
    Answered - Pending Review
    41 3
    Answered - Pending Review 41 views 3 comments Most recent by Devynn Johnson Using Smartsheet
  • Count if Formula help for a count within a date range
    In Formulas and Functions
    Here is my current formula - =COUNTIFS({Retail MarketingLead}, [Primary Column]@row, {Actual in MarketStart Date}, @cell <= TODAY()) I need to capture the count for April 1, 2020 - March 31, 2021
    Answered - Pending Review
    1 1
    Answered - Pending Review 1 view 1 comment Most recent by John Jonassen Formulas and Functions
  • Have a specific cell auto increment up as a new number is added
    In Formulas and Functions
    Per the example below, column "Total UG Footage Complete", I would like have the cell with "50" in it auto increment up when the box is highlighted and I added another 50 for it to show 100. Can that be done? (Image)
    Answered - Pending Review
    11 4
    Answered - Pending Review 11 views 4 comments Most recent by John Jonassen Formulas and Functions
  • WeekNumber Across Years
    In Formulas and Functions
    I have been able to find success at using the weeknumber formula and combining that with a 'past due' vs 'due this week' vs 'due next week' indicator. I have a separate sheet that identifies what 'this week' vs 'next week' vs 'last week' …
    Answered - Pending Review
    11 5
    Answered - Pending Review 11 views 5 comments Most recent by John Jonassen Formulas and Functions