Join the Smartsheet Community

Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.

Discussion List

  • Sheet ID as value in Cell
    In Formulas and Functions
    Is there a formula (or some other method) of automatically having Smartsheet input the Sheet ID into one of the cells on the sheet?
    Answered
    12 1
    Answered 12 views 1 comment Most recent by Kelly Moore Formulas and Functions
  • Return Current Month
    In Using Smartsheet
    Hi I am trying to pull specific data from a Column when its end date field = current month. I have gotten this far. =COUNTIF(EndDate:EndDate, IFERROR(MONTH(@cell), 0) = 11, IF(ASite:ASite, 1)) I am getting an incorrect argument error. Here…
    Accepted
    17 2
    Accepted Answer 17 views 2 comments Most recent by MCSCOO Using Smartsheet
  • Automation with Gantt chart sheets
    In Formulas and Functions
    I have a sheet created from project plan with Gantt chart template. It has naturally duration, start and end date columns. I added baselines to it. I also have Status column and '% complete' column. I am setting up a set of automations…
    Answered
    13 1
    Answered 13 views 1 comment Most recent by Devin Lee Formulas and Functions
  • Form not scaling properly from desktop to mobile
    In Using Smartsheet
    Hi Community, Please may I ask advice on how to improve the scaling of my Smartsheet form when it is loaded on a smartphone? The desktop version looks perfect but when I open it on my phone it is cut of on both sided and only if I turn it …
    Answered
    11 1
    Answered 11 views 1 comment Most recent by Devin Lee Using Smartsheet
  • Associated cost for each consultant
    In Formulas and Functions
    Hello, so I've created a sheet to record a project that has multiple consultants working on it. I would like to be able to choose one or multiple consultants for a task, their time spent and automatically their associated cost is calculate…
    Answered
    14 1
    Answered 14 views 1 comment Most recent by Devin Lee Formulas and Functions
  • How do I correctly use Sum & Value formulas together?
    In Formulas and Functions
    I'm trying to get the total monthly parking charges for my office. I have a column showing each individual's monthly parking charges, if applicable (enabled or disabled). For the sheet summary, using =sum([Monthly Cost]1:[Monthly Cos…
    Accepted
    11 2
    Accepted Answer 11 views 2 comments Most recent by PAS at Vista Formulas and Functions
  • Cross Sheet Joining Automation
    In Formulas and Functions
    Hello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox th…
    Answered
    59 3
    Answered 59 views 3 comments Most recent by Devin Lee Formulas and Functions
  • Ranking without Duplicating Ranks
    In Formulas and Functions
    I used the RANKEQ function for the first time recently and realized that any identical values will have the same rank. It will skip however many duplicates you had in the ranking numbers, so you may have a ranking scheme that looks like 1,…
    522 10
    522 views 10 comments Most recent by Devin Lee Formulas and Functions
  • Automating a Roll up for RYG Symbols for Health
    In Formulas and Functions
    Team, Thank you for your patience, I'm still learning. I have gone down a rabbit hole trying to figure out how to roll up Health symbols RGY. In my search for help I came across this formula but it's not working. =IF(COUNTIFS(CHILDREN()…
    Accepted
    24 4
    Accepted Answer 24 views 4 comments Most recent by NCharleb Formulas and Functions
  • Using the cell data of a link in "Smartsheet1" to open and filter data in "Smartsheet2"
    In Using Smartsheet
    Hello, Extremely new to Smartsheet, so bear with me. I'd like to create a list of names (let's say "Alpha, Bravo, Charlie") in Smartsheet1, with each name being a link to Smartsheet 2. Smartsheet 2 contains a table in which the c…
    Answered
    21 3
    Answered 21 views 3 comments Most recent by Andrée Starå Using Smartsheet