Solution Center

Discussion List

  • 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
  • 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
  • Countifs formula to count a value within a date range?
    In Formulas and Functions
    Our company has ongoing surveys and the raw data is organized by different dates (dates the survey was complete). We want to only count the cells for a particular date range in our calculations sheet to give us the survey results for that …
    Answered - Pending Review
    28 1
    Answered - Pending Review 28 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Dashboard Widget Dividers
    In Using Smartsheet
    Is there an easy way to get a diving line or border between widgets on a dashboard?  The only thing we've found is to insert images of lines from Powerpoint - not the best.
    1157 4
    1.2K views 4 comments Most recent by Sunitha Rachapalli Using Smartsheet
  • Assigning Multiple Resources
    In Using Smartsheet
    I've seen posts going back 3 years that address this subject, and it's little mind blowing that a feature as basic and essential as this does not seem to be possible yet. My team works on multiple projects each day, and each project has at…
    1330 8
    1.3K views 8 comments Most recent by Andrée Starå Using Smartsheet
  • Is there an automated workflow that populates data in cells based on triggers and conditions?
    In Using Smartsheet
    Hi Smartsheet SMEs! Please share any success you've experienced in creating a workflow to automatically populate cells using select triggers and conditions without using a formula. Thanks in advance for your feedback/suggestions. Edwina -
    Answered - Pending Review
    37 5
    Answered - Pending Review 37 views 5 comments Most recent by Edwina Sampler-Wright Using Smartsheet
  • translating Content
    In Using Smartsheet
    Hi all, Looking for any ideas, I am working on a sheet that is being used in 10 countries, currently, we use English as the main language, however, content can get lost in translation.  is there any way for users to use their home languag…
    420 6
    420 views 6 comments Most recent by Zack Miller Using Smartsheet
  • OFFSET Function
    In Formulas and Functions
    Hi, I need to calculate the sum across a number of columns that will change every month (mon columns are set from January to December for each year). This would easily be done in Excel via an OFFSET function and I can't find what the equiv…
    Answered - Pending Review
    25 5
    Answered - Pending Review 25 views 5 comments Most recent by Heather D Formulas and Functions
  • Report builder - Collapse and Expand Rows
    In Using Smartsheet
    Hi, Is there a way to expand and collapse rows in the report builder just like the functionality that the sheets have? I want to be able to display in my project dashboard the same view that from the project sheet but unable to do so bec…
    200 4
    200 views 4 comments Most recent by Chris Atkinson Using Smartsheet
  • Dynamic View: Un-editable Fields
    In Premium Apps and Integrations
    I am having an issue with Dynamic View treating (random) editable fields as "Read Only." In this instance, Dynamic View is treating a Date Field as if it were a "Read Only." In the first screen shot, you will see that t…
    Answered - Pending Review
    38 6
    Answered - Pending Review 38 views 6 comments Most recent by Genevieve P Premium Apps and Integrations