Automations

 

Discussion List

  • ADD LAST COMPLETE DATE
    In Formulas and Functions
    I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Completion Date will register the da…
    Unanswered
    6 0
    Question 6 views 0 comments Started by Rob_PM Formulas and Functions
  • Grouped Update Requests
    In Using Smartsheet
    I am looking for a way to send multiple update requests in a single email. Here is the scenario. Once a product is inspected, I want to check a Smartsheet checkbox saying that it passed inspection. Then I want Smartsheet to automatically s…
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Kelly Moore Using Smartsheet
  • New here, general questions
    In Using Smartsheet
    Hi, Do you have to write all the functions yourself or are there tools to help with the process. I need to do a xlookup index and matching update to another sheet. I'm use to work with ablebits tools. While I'm here, it is possible to upl…
    Unresolved
    8 1
    Question 8 views 1 comment Most recent by Jeff M. Using Smartsheet
  • Employee Fit Testing Tracking
    In Formulas and Functions
    I am very new to creating my own smart sheets, I am looking to create a tracking of Employee Respirator Fit Testing. This sheet would need a away to annually updated by testing completion date as well as the type of mask they tested on, no…
    Answered - Pending Review
    15 4
    Answered - Pending Review 15 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • All cross sheet references randomly removed from sheet
    In Using Smartsheet
    Hey all, I have a weird issue. I have a sheet we use for our install calendar and randomly all the cross sheet references will be removed. This has only happened one time in November and again this Wednesday. I spoke with support and they …
    Answered - Pending Review
    17 2
    Answered - Pending Review 17 views 2 comments Most recent by Justin Ramos-Flynn Using Smartsheet
  • Ranking Formula
    In Formulas and Functions
    Hello all, I have a sheet with columns that look like this: Spot in Queue Case Number Case Prep Completed Case Completed 1 100 x …
    Answered - Pending Review
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • Automatic workflow not working
    In Using Smartsheet
    I am trying to set up a recurring date to be entered into the sheet using automatic workflow (photos enclosed) I want to be able to type in "blah blah blah" into the event name column and have it repeat every month on the the thi…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by renogawj Using Smartsheet
  • Random assignation
    In Formulas and Functions
    Hi, I'm trying to assign a task to one of my team members (there are four). Every time a new project is added to the queue, instead to manually add one of them, i would like one randomly chosen person among them four. Can you please help m…
    Answered - Pending Review
    109 4
    Answered - Pending Review 109 views 4 comments Most recent by Alberto CONCEJAL LÓPEZ Formulas and Functions
  • Record changes to only 1 cell
    In Formulas and Functions
    In a sheet where another user and I download files and mark them in different stages (proofed, processed, uploaded), is there a way to record who last modified a cell rather than a whole row? I'd like to have a cell automatically record wh…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Timing Issue for Moving Row from Staging Sheet to Main Sheet
    In Formulas and Functions
    I'm building a workflow for our HR and Recruiting department to use to track job posting requisitions. If they check a box on the master sheet to repost the job again I am copying the row to a staging sheet, making a few cell updates to ch…
    Answered - Pending Review
    18 4
    Answered - Pending Review 18 views 4 comments Most recent by Bethany Garcia Formulas and Functions