IT & Operations

 

Discussion List

  • Formula to count of items in a multi dropdown list
    In Formulas and Functions
    Hi The drop-down multi select is very nice and useful.  I started to use it yesterday, but I need to use the formula =countif(range, criterion).  I want to count how many times a value is repeated in a range that has multi values. I use …
    Accepted
    23264 42
    Accepted Answer 23.3K views 42 comments Most recent by Paul Newcome Formulas and Functions
  • Automation Trigger "When Rows are Changed" not working
    In Using Smartsheet
    I have been banging my head on this. I need to set up a very simple trigger that when a cell is updated, a notification is sent about that row. I am using the "When Rows are Changed" trigger and defining my cell condition, and fi…
    1588 14
    1.6K views 14 comments Most recent by Genevieve P. Using Smartsheet
  • Please add admin ability to force password resets
    In Using Smartsheet
    Forcing the reset of a user's password is critical to the security and efficiency of any user management system. Every other web service I can think of that uses an admin/multi-user structure has such a feature. Here are some examples whe…
    Answered - Pending Review
    7 4
    Answered - Pending Review 7 views 4 comments Most recent by Genevieve P. Using Smartsheet
  • Effort Vs Duration
    In Using Smartsheet
    Hi I am new to smartsheet and wondered if you could help. I would like to create a project plan which shows the effort required vs the duration. for example: a task may take 2 days to complete however they can complete this anytime with…
    Em Profile Photo Em
    1794 12
    1.8K views 12 comments Most recent by Ted Hassanein Using Smartsheet
  • Gnatt chart Bar formatting - grid missing
    In Using Smartsheet
    H Folks, For some reason I have areas in my smartsheet plan that have grid missing, some are ok.   Does anyone have an idea how I can correct this and add the gridelines back please.   thanks Mark,
    311 3
    311 views 3 comments Most recent by Paul Ayres Using Smartsheet
  • Loop back to the start of a Bridge Workflow
    In API & Developers
    I am trying to build a help chatbot that our team members can use to quickly find help docs on various topics/processes. For example the chat would look something like this - If you answer yes I want the chatbot to loop back to the very…
    Accepted
    42 1
    Accepted Answer 42 views 1 comment Most recent by Garrett Henke API & Developers
  • Quickbooks & Smartsheet
    In API & Developers
    So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.  It has many application & the proof of concept exists and we use it.  We use it for an approval process (for in…
    4208 30
    4.2K views 30 comments Most recent by JeremiahHorstick API & Developers
  • Please add a successor column or function
    In Using Smartsheet
    A way to show successors is needed. It's important for critical path scheduling that every task has a predecessor and a successor. After a couple hundred lines it becomes nearly impossible to eyeball everything to make sure that's true. A …
    592 4
    592 views 4 comments Most recent by AW10101 Using Smartsheet
  • Forms that need to incorporate multiple line entries
    In Formulas and Functions
    We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is fi…
    541 24
    541 views 24 comments Most recent by Karen M Formulas and Functions
  • Smartsheet policy for your organization?
    In Using Smartsheet
    Asking this again since the thread I found did not have many responses - has anyone written a Policy & Procedure for your organization for rules around using Smartsheet? Looking to cover: User management- who gets licenses/levels of ac…
    Answered - Pending Review
    24 1
    Answered - Pending Review 24 views 1 comment Most recent by Krissia B Using Smartsheet