Company Management

Company Management

Discussion List

  • John.Bruzza
    John.Bruzza 303 views 5 comments Most recent by Vanessa_SOS Using Smartsheet
    First post 06/18/19,Last post 05/27/20
    Hello, I have a sheet where I am tracking construction progress.  There are a lot of data/calculations that my field personnel do not need.  I want a simple interface for them to update data (% Complete, Actual Date Completed, etc.)  Each…
    Using Smartsheet3035
    John.Bruzza
  • Sam Ng
    Answered - Pending Review Sam Ng 17 views 1 comment Most recent by Ramzi Using Smartsheet
    First post 05/20/20,Last post 05/25/20
    Hello, Working days and non-working days are configurable on sheet-level and account-level, but I wonder whether we can configure that on the organization-level. I want to set the default non-working days and public holidays for my organi…
    Using Smartsheet171
    Sam Ng
  • beth_linder28141
    beth_linder28141 285 views 8 comments Most recent by Lillian Fenner Using Smartsheet
    First post 05/21/19,Last post 05/22/20
    I LOVE the work flows!!! But I have 15 facilities and 15 of the same worksheets. Is it possible to: 1. Clone the work flow from one worksheet to another or 2. print the work flow so i can enter the same verbiage & flow in all the sh…
    Using Smartsheet2858
    beth_linder28141
  • TeeM
    TeeM 201 views 7 comments Most recent by Elizabeth Alonso Using Smartsheet
    First post 08/27/18,Last post 05/21/20
    I want to use an image for a Dashboard banner however, I cannot find any size dimensions for it and some experimentation is not working. I note this shows on Smartsheet's own examples yet I can't reproduce it. See attached screen shot. (I…
    Using Smartsheet2017
    TeeM
  • TeeM
    TeeM 566 views 14 comments Most recent by Chuck Muirhead Using Smartsheet
    First post 08/27/18,Last post 05/21/20
    Can I send a PDF of a Dashboard on a reoccurring basis? Recipients just want to receive by email on a regular basis and not need to login to view.
    Using Smartsheet56614
    TeeM
  • skarkhoff
    Adding to InventoryAccepted Answer
    Accepted Answer skarkhoff 33 views 3 comments Most recent by Paul Newcome Formulas and Functions
    First post 12/03/19,Last post 05/07/20
    I'm sure this is simple, but I've searched for a while and haven't found anything similar!  I have a sheet set up to track each piece of marketing collateral.  It starts w/ the beginning quantity (say 100 pieces) and deducts the number of…
    Formulas and Functions333
    skarkhoff
  • Alexander Wirtz
    First post 03/26/19,Last post 05/07/20
    I want to use smartsheet as an international project management tool. One thing is driving me creasy. I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
    Formulas and Functions2135
    Alexander Wirtz
  • JWattz
    JWattz 155 views 7 comments Most recent by Mona Singh Using Smartsheet
    First post 10/31/19,Last post 05/06/20
    I have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
    Using Smartsheet1557
    JWattz
  • Michael Maxson
    Accepted Answer Michael Maxson 17 views 2 comments Most recent by Andrée Starå Using Smartsheet
    First post 04/24/20,Last post 04/24/20
    Hello! We are trying to find the best way to track employee training and certifications categorized by department and type of position. Has anyone been working on anything similar that they could share? TiA!
    Using Smartsheet172
    Michael Maxson
  • SRenner
    First post 09/04/19,Last post 04/24/20
    I am looking to have a drop down cell called "run name" that when changed will populate all the stores on that run.  I was using VLOOKUP from a master store/run sheet to do this but could only figure out how to get one store to …
    Formulas and Functions8037
    SRenner
  • Anna Mullins
    Anna Mullins 110 views 12 comments Most recent by Andrée Starå Formulas and Functions
    First post 02/05/19,Last post 04/23/20
    HI,   I have a formula  =IF(E3>0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE  can anyone help fix this issue?? Please see attached excel with formula in Column D  Thank you …
    Formulas and Functions11012
    Anna Mullins
  • JWattz
    First post 10/02/19,Last post 04/22/20
    Hi there, Attempting to write formula to automate RYGB symbols when task is In Progress, On Hold or Complete. I've prepared a few formulas and none seem to be accurate. If someone would take a look at below attempts and let me know what ne…
    Formulas and Functions8112
    JWattz
  • Amy Tomlinson
    Accepted Answer Amy Tomlinson 58 views 17 comments Most recent by Joachim Mund Formulas and Functions
    First post 04/01/20,Last post 04/14/20
    I have searched for a formula to calculate the number of days holiday, but I would like it to be more specific to tell me the number of days taken this month. So far I have this: =SUMIFS(Duration:Duration, Absence:Absence, "holiday&qu…
    Formulas and Functions5817
    Amy Tomlinson
  • Noga Ginzburg
    Answered - Pending Review Noga Ginzburg 33 views 2 comments Most recent by rgochee Using Smartsheet
    First post 04/08/20,Last post 04/12/20
    Hi all, I'm fairly new to smartsheet, and i wanted to know how do i use the "bill rate", ca I change it? How can I access it? I think this is the solution for my issue which is i want to add the costs to my resources and I could…
    Using Smartsheet332
    Noga Ginzburg
  • EdL
    EdL 371 views 4 comments Most recent by Eleshia Robinson Using Smartsheet
    First post 10/11/18,Last post 04/09/20
    As a new user, I found that the % Allocation column does not respond to input from the Duration column, as seems intuitive to me. After reviewing community comments, I find that the % Allocation functionality in Smartsheet does not actual…
    Using Smartsheet3714
    EdL
  • andreajs
    andreajs 80 views 2 comments Most recent by Jessica Donovan Using Smartsheet
    First post 08/09/19,Last post 04/03/20
    Hi all -- I am new. Trying to get a bubble chart template that I can use to make a gorgeous bubble chart. No results when I start a new sheet and type in "bubble chart."  Ideas? Help? Thanks very very much -- Andrea
    Using Smartsheet802
    andreajs
  • katherinehall
    katherinehall 288 views 13 comments Most recent by Andrée Starå API & Developers
    First post 02/01/19,Last post 04/03/20
    Hi there,  I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If…
    API & Developers28813
    katherinehall
  • RySols
    RySols 790 views 15 comments Most recent by Paul Newcome Formulas and Functions
    First post 12/04/19,Last post 03/23/20
    Hi All,  I need help with a formula to Count every instance a name appears in a multi-select row of a column based on criteria from another column first. At present this is my first formula: =COUNTIFS({CORP ADMIN TEAM TASKS Range 1}, &qu…
    Formulas and Functions79015
    RySols
  • Kyle Morgan
    Kyle Morgan 54 views 5 comments Most recent by Francine Haman Premium Apps and Integrations
    First post 12/10/18,Last post 02/27/20
    Does anyone know if there is a way to NOT display a contact's full email address (but show their name, instead) when they are assigned as "Task Owner" in the Smartsheet Calendar App? We have a calendar that references an existin…
    Premium Apps and Integrations545
    Kyle Morgan
  • lnelsen
    lnelsen 1K views 11 comments Most recent by Paul Newcome Formulas and Functions
    First post 04/08/19,Last post 02/24/20
    I am trying to count the number of requests types between a date range.  This is what I thought would work:   =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 0…
    Formulas and Functions103311
    lnelsen
  • JeremiahHorstick
    JeremiahHorstick 941 views 13 comments Most recent by Andrée Starå API & Developers
    First post 07/26/19,Last post 02/19/20
    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…
    API & Developers94113
    JeremiahHorstick
  • Actual Goodfella
    Answered - Pending Review Actual Goodfella 34 views 1 comment Most recent by Paul Newcome Using Smartsheet
    First post 02/10/20,Last post 02/10/20
    Hi, If we use the Outlook Smartsheet app, will calendar items on Smartsheet be pushed to the users Outlook? Thank you, Jared
    Using Smartsheet341
    Actual Goodfella
  • Junio`
    Junio` 23 views 4 comments Most recent by kunal kumar Using Smartsheet
    First post 02/09/19,Last post 02/05/20
    Hi,  I got 5 sales reps that all log their new customer in rows on a master sheet. Each row has an assign to column for each sales rep. How could I share this sheet to each one of the sales rep so that they can only see their customers an…
    Using Smartsheet234
    Junio`
  • Dajah
    First post 11/27/18,Last post 02/04/20
    I understand I can likely do this with a very, very long VLOOKUP  or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.  Situation: I would like to have a form where someone selects one op…
    Formulas and Functions189117
    Dajah
  • Jose da Silva
    Jose da Silva 40 views 2 comments Most recent by mattc Using Smartsheet
    First post 06/21/19,Last post 01/29/20
    Hi all, Would it be possible to backup/export a spreadsheet on a scheduled basis more often than daily? One of the Departments on my company asked if it would be possible to do it hourly or even every 10min, but the smallest period i can…
    Using Smartsheet402
    Jose da Silva
  • lisarae723
    Accepted Answer lisarae723 33 views 4 comments Most recent by Andrée Starå Using Smartsheet
    First post 01/24/20,Last post 01/27/20
    I work at a manufacturing company & have implemented Smartsheet to be used within every department. Right now I am currently the only admin who creates and/or updates the sheets, reports & dashboards etc. We have over 300 active sh…
    Using Smartsheet334
    lisarae723
  • brettwad
    brettwad 928 views 16 comments Most recent by Paula R Using Smartsheet
    First post 01/13/18,Last post 01/23/20
    Does anyone have a template or know of an existing template that could be used for OKR's?
    Using Smartsheet92816
    brettwad
  • hcosta52671
    hcosta52671 101 views 3 comments Most recent by eeismartsheetco104211 Using Smartsheet
    First post 06/26/18,Last post 01/21/20
    The Activity Log properly logs the system users and their activities. What shows is the user's name and the activity info. I notice however, that several entries in the log lists "Publised User" as the person whose acivity is tr…
    Using Smartsheet1013
    hcosta52671
  • Dantawn
    Dantawn 76 views 6 comments Most recent by Tucker Webb Using Smartsheet
    First post 02/05/18,Last post 01/19/20
    When creating a project many times the comments are as much instructions, as comments. Just like this modal when creating community comments, add the ability to apply Rich Text Formatting; Bold,underline,bullets, and numbered lists. RTF fu…
    Using Smartsheet766
    Dantawn
  • IdoIcan
    Accepted Answer IdoIcan 43 views 1 comment Most recent by Genevieve P Using Smartsheet
    First post 01/10/20,Last post 01/13/20
    I wonder how to automate the approval process when If the Applicant = employee, then Department Manager Approve + GM Approve If the Applicant = Department Manger, then GM Approve It seem not possible using "condition" in the auto…
    Using Smartsheet431
    IdoIcan