Solution Center

Discussion List

  • Integrate with Microsoft Access
    In Apps, Integrations, and Add Ons
    Does Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?
    1530 3
    1.5K views 3 comments Most recent by Marian Hanright Apps, Integrations, and Add Ons
  • Integration with Oracle Primavera P6
    In API & Developers
    Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6?  We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible.  …
    960 3
    960 views 3 comments Most recent by Srija Kalavala API & Developers
  • Automatic roll up of the same Field?
    In Formulas and Functions
    I have an internally corrupted data base. Our people have been inputting the wrong/random ID numbers for the same Model #. I exported some of our data from our database into a Smartsheet to see if I could sort them. Below is snip of a 20,0…
    23 3
    Accepted Answer 23 views 3 comments Most recent by Genevieve P. Formulas and Functions
  • Updating rows with multi_contact cell?
    In API & Developers
    Hello, I'm using the Python API to update some rows as follows: copy cell values in specific columns from an old row, and append these to an update request as cells in the respective column for a new row. This works for all but a contact c…
    151 4
    Accepted Answer 151 views 4 comments Most recent by nschum API & Developers
  • 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
    64 9
    Answered - Pending Review 64 views 9 comments Most recent by Aravind Formulas and Functions
  • Cursor Bug when Referencing other Sheets in a Formula
    In Formulas and Functions
    Hi, I found a bug when referencing other sheets in a formula. When referencing multiple ranges from other sheets, the cursor will go outside of the braces for the first reference, then will go inside the braces for every reference after. I…
    34 2
    Accepted Answer 34 views 2 comments Most recent by Andrew James 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
    342 3
    Accepted Answer 342 views 3 comments Most recent by Genevieve P. 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
    66 1
    Answered - Pending Review 66 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.
    1660 4
    1.7K 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…
    2237 8
    2.2K views 8 comments Most recent by Andrée Starå Using Smartsheet