Discussions

Discussion List

  • Volunteer Allocation
    In Formulas and Functions
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    64 3
    64 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Date and Balance Formula
    In Formulas and Functions
    Hi there, I need help creating 2 formulas I am trying to create a formula that takes into account if the Week Ending is a specific date than the balance for that week ending displays accurately. The second formula would essentially be t…
    Answered - Pending Review
    12 4
    Answered - Pending Review 12 views 4 comments Most recent by Ileana Stover Formulas and Functions
  • Copy and Paste Error
    In Using Smartsheet
    Hello Experts, My Sheet is having 10300+ rows. I am trying to delete entire rows and performing a copy and Paste. After attempting to copy and Paste 1st 500 Items and tried to SAVE. I am getting this error. Its forcing me to log out but wh…
    Answered - Pending Review
    12 2
    Answered - Pending Review 12 views 2 comments Most recent by Sandra Guzman Using Smartsheet
  • Column Number Function
    In Formulas and Functions
    Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
    233 4
    233 views 4 comments Most recent by David Joyeuse Formulas and Functions
  • Count If Current Week
    In Formulas and Functions
    Hi Everyone, I have some daily data with dates and I want to get the week to date numbers off that data (Monday - Sunday of current week). I know countif is needed but I'm not sure how to go thru the rest. Your help is appreciated.
    1676 10
    1.7K views 10 comments Most recent by alexis.ray89371 Formulas and Functions
  • Creating a community forum through smart sheet
    In Using Smartsheet
    Hi everyone, I'm pretty new to smart sheet and was wondering if Smartsheet is able to be used to develop a type of community forum / discussion board within smart sheets? Like could we develop something similar to this Smart sheet Communit…
    Answered - Pending Review
    22 4
    Answered - Pending Review 22 views 4 comments Most recent by Genevieve P Using Smartsheet
  • Engage Track Sneak Peek: How Smartsheet uses Smartsheet
    In Using Smartsheet
    I have the honor of partnering with a number of colleagues from across the organization to bring you the "How Smartsheet uses Smartsheet" track as part of our annual Engage Conference this year! Real use cases provide so much ins…
    13 0
    13 views 0 comments Started by elektra_h Using Smartsheet
  • Saved Filters Issue Date Type Column
    In Formulas and Functions
    I'm running into a very odd issue with consistent filtering on a date column thats being generated from a formula: We have a column labeled "Filter date" that is set to Date (Restrict to dates only not checked) which has the fo…
    11 5
    11 views 5 comments Most recent by Howard Pyett Formulas and Functions
  • Formula to count of items in a multi dropdown list
    In Formulas and Functions
    Hi The drop-down multi select is very nice and useful.  I started to use it yesterday, but I need to use the formula =countif(range, criterion).  I want to count how many times a value is repeated in a range that has multi values. I use …
    Accepted
    8316 32
    Accepted Answer 8.3K views 32 comments Most recent by Paul Newcome Formulas and Functions
  • Can anybody correct my below if condition ? I need that asap
    In Formulas and Functions
    =IF(OR(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",[DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)"), "FILLING"), IF(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 …
    Answered - Pending Review
    11 4
    Answered - Pending Review 11 views 4 comments Most recent by David Joyeuse Formulas and Functions