Company Management

Discussion List

  • How do we improve formatting such as merged cells?
    In Using Smartsheet
    What other options do we have to format the sheet better, perhaps even in sections? Merging some cells will help get rid of the lines and make things look better spacing wise.
    52 4
    52 views 4 comments Most recent by James Watt Using Smartsheet
  • Working Days Configuration for an Organization
    In Using Smartsheet
    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…
    Answered - Pending Review
    32 1
    Answered - Pending Review 32 views 1 comment Most recent by Ramzi K Using Smartsheet
  • Work Flow - Clone to another worksheet
    In Using Smartsheet
    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…
    772 8
    772 views 8 comments Most recent by Lillian Fenner Using Smartsheet
  • Dashboard Header Banner
    In Using Smartsheet
    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.
    869 7
    869 views 7 comments Most recent by Elizabeth Alonso Using Smartsheet
  • Adding to Inventory
    In Formulas and Functions
    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…
    Accepted
    90 3
    Answered ✓ 90 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • One VLOOKUP cell gives me a column list of returns
    In Formulas and Functions
    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 …
    346 37
    346 views 37 comments Most recent by Paul Newcome Formulas and Functions
  • FORMULA NOT WORKING
    In Formulas and Functions
    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 …
    260 12
    260 views 12 comments Most recent by Andrée Starå Formulas and Functions
  • RYGB symbols automated to reflect status/progress
    In Formulas and Functions
    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…
    540 12
    540 views 12 comments Most recent by Paul Newcome Formulas and Functions
  • I would like a formula to tell me the number of days holiday taken this month
    In Formulas and Functions
    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…
    Accepted
    345 17
    Answered ✓ 345 views 17 comments Most recent by Joachim Mund Formulas and Functions
  • Adding resources cost
    In Using Smartsheet
    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…
    Answered - Pending Review
    382 2
    Answered - Pending Review 382 views 2 comments Most recent by rgochee Using Smartsheet