Formulas

Discussion List

  • Merging the text of 2 cells into 1.
    In Archived 2016 Posts
    Hello, is there a way to merge the text of 2 different cells into 1 please? I have tried several versions of this but I get different error messages.    =(([cell]1) &” “&([cell]2)     Thankyou.
    32 2
    Closed 32 views 2 comments Most recent by DawnM Archived 2016 Posts
  • Send emails with live links other than web links
    In Archived 2016 Posts
    It would be great to have the hyperlink feature not just be limited to web sites.   If I could put a link to a file located on my network, I could then send a notification or send a row and the email that would be delivered would allow m…
    Ian Profile Photo Ian
    1 2
    Closed 1 view 2 comments Most recent by Ian Archived 2016 Posts
  • Sheet Size
    In Archived 2015 Posts
    I have sheets that vary in size but most lean to the larger size due to the amount of formulas in the sheet. I am looking to see if on average people are choosing to have more sheets and less size or less sheets and fill the sheets to the …
    521 26
    Closed 521 views 26 comments Most recent by Jim Hook Archived 2015 Posts
  • Fetching Parent Cell value for Children Cells
    In Archived 2016 Posts
    Hello, I would like my Children Cells to fetch their value from the Parent cell. Is it possible? Will it be possible soon? NB - I do not want to fetch the value from the "cell reference" of the parent ("=[Related Invoice]1 …
    294 2
    Closed 294 views 2 comments Most recent by J. Craig Williams Archived 2016 Posts
  • Formula to include new data added to my sheet
    In Archived 2016 Posts
    I have set up a formula that works very well however it isn't taking into account new entries added to my sheet. For example my formula is on Row 1 under the column 'total' I then have other information in rows 2-15 so therefore my formula…
    212 5
    Closed 212 views 5 comments Most recent by KrisWalsh Archived 2016 Posts
  • Combining Formulas
    In Archived 2016 Posts
    I am currently using 2 columns to identify tasks "Due in Next 2 Days" and "Past Due/No Schedule". I have been trying to nest the two formulas together to get the status in the same column. How can the following formulas…
    222 1
    Closed 222 views 1 comment Most recent by Travis Archived 2016 Posts
  • Combining formulas for child rows
    In Archived 2016 Posts
    I have an easy formula to work out the average data entered into my child rows, the formula is as follows: =AVG(CHILDREN()), this gives me the average of all data put into the child rows perfectly. However, if nothing is entered into these…
    41 3
    Closed 41 views 3 comments Most recent by Irene Plant Archived 2016 Posts
  • Auto Checkbox Completion
    In Archived 2016 Posts
    Hi All,   I am trying to get a formula to work that checks a box based on a column with percentage. I.e when 100% is reached the box is checked.   I have tried the following to no avail   =IF([Compliance]5 = "100%", 1, 0) …
    61 4
    Closed 61 views 4 comments Most recent by Leo Plant Archived 2016 Posts
  • Formula to show monthly count
    In Archived 2016 Posts
    Hi, I am trying to figure out a formula that tells me how many entries have been entered for a particular month. I have a date column and an tonnage column so if I have 10tonne of material made on 1st February i would enter in the date col…
    996 5
    Closed 996 views 5 comments Most recent by JamesR Archived 2016 Posts
  • Formatting Date in Smartsheet with Month Name Displayed
    In Archived 2016 Posts
    When using the column type of "DATE" the only way dates are always displayed as numeric values. However, some of my colleagues are requesting that the dates be displayed as Feb 12, 2016 or 12 Feb 2016, etc.   Is this possible i…
    1146 2
    Closed 1.1K views 2 comments Most recent by Travis Archived 2016 Posts