IT & Operations

Discussion List

  • Countif logic not working
    In Formulas and Functions
    Hi Team, I need a formula that should count the based on Priority High, Medium, Low . So if the priority is High and Status is Completed it should count the number on closed column if the priority is High and status is In progress,Hold it…
    Answered - Pending Review
    66 4
    Answered - Pending Review 66 views 4 comments Most recent by Heather Duff Formulas and Functions
  • Multiple users and automated backups
    In Using Smartsheet
    If multiple users have access to the same sheets, what impact does that have on automated backups? It would not be desirable to have more than one person backing up a single smart sheet.
    63 5
    Accepted Answer 63 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • 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
  • Smartsheet - Azure DevOps integration
    In Apps, Integrations, and Add Ons
    Hey guys,  I'm trying to create a connection between Azure DevOps and Smartsheet but I'm having a lot of issues with it.  Has anyone ever made a two-way connection between the two? Especially being able to update an item in Azure when a ro…
    Answered - Pending Review
    76 1
    Answered - Pending Review 76 views 1 comment Most recent by Genevieve P. Apps, Integrations, and Add Ons
  • Change status automatically when selecting % done
    In Formulas and Functions
    Hello I have searched through the Help centre (center!) and I can't find the formula (if one exists....) that will automatically select the appropriate value in the % done when one of 6 choices from Status is chosen. So when I select Not …
    Answered - Pending Review
    11 3
    Answered - Pending Review 11 views 3 comments Most recent by Danielle O'Connell Formulas and Functions
  • Default Sheet Displayed when opening Smartsheet
    In Using Smartsheet
    With the old UI, the object (sheet) that was opened when we closed Smartsheet was displayed when we opened Smartsheet the next time; however, with the new UI, this seems to be hit and miss.  Is there a way to set a object (sheet) to be the…
    214 3
    214 views 3 comments Most recent by BHN Admin Using Smartsheet
  • 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 …
    163 1
    Accepted Answer 163 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Tracking age in hours
    In Using Smartsheet
    Hello, We are using Smartsheet as a ticket queue (users submit tickets via a Form) and I'm wondering if there is a way to track age in hours as well as hours between updates. For example, if we want to show how many hours it took to assign…
    Answered - Pending Review
    2 3
    Answered - Pending Review 2 views 3 comments Most recent by Andrée Starå Using Smartsheet
    In API & Developers
    We have been using HYPERLINK("", "Click Here") in both excel and google spreadsheet, and since we need jotforms integration for client our current links in smartsheet is very long and creating hyp…
    466 2
    466 views 2 comments Most recent by Chris Brock API & Developers
  • Celling Linking-Multiple rows
    In Using Smartsheet
    I need to link about 50 cells in my Inventory sheet to the SAME cell in my Inventory Price sheet. Can I do that as a group? I tried selecting all the cells in my Inventory sheet, then selected the linking option, navigate to the Inventory …
    650 3
    650 views 3 comments Most recent by StephanieR Using Smartsheet