IT & Operations

 

Discussion List

  • How to Alter the "Sheet - IT Ticket Metrics"
    In Formulas and Functions
    I want to alter this sheet, found in the IT ticket Template, to just show the metrics for a specific customer. the original formula looks like this: =COUNTIF({Created Date Range}, IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - 1) and my attempt…
    Accepted
    12 5
    Answered ✓ 12 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Emergency Preparedness with Smartsheet
    In Using Smartsheet
    Hello SS Community!  Does anyone of examples of a Corporate Emergency Preparedness Checklist that one can share with me as a starting point?  Tips greatly appreciated!! Thank you!
    45 3
    45 views 3 comments Most recent by Archie Lopez Using Smartsheet
  • Webform not updating after sheet changes
    In Using Smartsheet
    Hello I have created a simple sheet with data for internal materials requests, including an approval loop via workflows. I then created a webform to gather input; in order to test it, in the approver / exectutor user fields I used fake d…
    78 5
    78 views 5 comments Most recent by Genevieve P. Using Smartsheet
  • Can an email template be built in Smart Sheets that is sent out to a DL?
    In Using Smartsheet
    Can an email template be built in Smartsheet that can accept free form text in certain fields and also be able to be emailed out in the G-Suite to a DL. The other condition would be to be able to reuse the sent email message and be able …
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • OneNote integration in Smartsheet
    In Apps, Integrations, and Add Ons
    Based on a suggestion I read on this board, I am posting a product enhancement request I just submitted for the community to see. Request OneNote integration in Smartsheet to easily paste in a link to a OneNote page/paragraph/section/sec…
    3910 11
    3.9K views 11 comments Most recent by Ben Hurst Apps, Integrations, and Add Ons
  • Request Access Notification
    In Using Smartsheet
    I provision all projects for our PMO and each project is housed in a Workspace to control access, so, I am the 'owner' for each project in our organization... This setup worked for a time, but now that we're scaling up, I'm receiving acce…
    350 3
    350 views 3 comments Most recent by Atul Chopra Using Smartsheet
  • Connecting to Amazon QuickSight
    In Apps, Integrations, and Add Ons
    Hello, we currently utilize amazon QuickSight to build automated dashboards from other websites. Would it be possible to connect the data collected on Smartsheet to build automated dashboards on QuickSight?
    Answered - Pending Review
    27 1
    Answered - Pending Review 27 views 1 comment Most recent by Andrée Starå Apps, Integrations, and Add Ons
  • VLOOKUP on the if false of another VLOOKUP
    In Formulas and Functions
    I have a worksheet that I want to reference 5 reference sheets that contain staff members. Because of the large scale of staff members. We split them up by region. I want to create a column formula that will look up a "District ID&quo…
    Accepted
    17 1
    Answered ✓ 17 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • SUMIF with cross sheet referencing
    In Using Smartsheet
    Hello all, I created a sumif formula that would reference another sheet.  Copied below is my formula but it always results as "incorrect argument". I believe the problem is in the sum range (bolded in formula). Can someone plea…
    1147 5
    1.1K views 5 comments Most recent by Seth Morth Using Smartsheet
  • Automated import through the API
    In API & Developers
    Dear Smartsheet-Community, I am doing a semesterthesis in coorporation with a company that has been using Smartsheet for a while. My job is to create an automated order tool for AM parts, which serves as an order backlog including the 3D …
    410 2
    410 views 2 comments Most recent by H.Hillier API & Developers