Formulas and Functions

Archives for June 2018

Discussion List

  • Elapsed time - 24hr workday - Display bug?
    In Formulas and Functions
    See the attached pic.    * The sheet is set for 24hr workdays.  Mon-Fri.    * There are 2 tasks.   one with duration 7d  and one with duration e7d. * The e7d  task does not display 7 days of working.  The gantt chart bar does not show sun…
    32 views 3 comments Most recent by Chris Atkinson Formulas and Functions
  • COUNTIF Function
    In Formulas and Functions
    I'm trying to count everything in a Type column that = "Risk" that match a status of "Red" and "Yellow". How would I add "Yellow" to this statement? =COUNTIFS(Type:Type, "Risk", Status:St…
    1 view 1 comment Most recent by J. Craig Williams Formulas and Functions
  • Copying formula across columns
    In Formulas and Functions
    Hi, I'd like to copy a SUMIF formula across columns, where the only change in each would be to have the formula automatically update to match the new column name. Specifically, it would autmoatically change from the original colum =SUMI…
    31 1
    31 views 1 comment Most recent by Shaine Greenwood Formulas and Functions
  • Count number of days between two dates and return the difference and if early or late?
    In Formulas and Functions
    Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date…
    536 3
    536 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • "If clause" in Dependancies
    In Formulas and Functions
    Hi all, I am struggling to find a solution for this. I have 15 individual sheets for a project. One of the activities on sheet 2 will include a "yes/no" question. If yes, then sheet 3 needs to be completed. If no, then sheet…
    1 view 2 comments Most recent by Paul Newcome Formulas and Functions
  • COUNTIF Function
    In Formulas and Functions
    Im trying to count 2 columns on a issue sheet and want to count out each specific type (Risk, Action, Issue, Decision) that are open (not counting the closed or in progress types) I have these formuals but its not producing a result * =C…
    21 views 2 comments Most recent by Mike Wilday Formulas and Functions
  • validating cell value
    In Formulas and Functions
    Hi, I have a sheet with diferent columns, one is "Initial Date" and other one is "Ending date". How can avoid users update "Ending Date" with a date earlier than today?
    124 5
    124 views 5 comments Most recent by amedina52556 Formulas and Functions
  • Auto Downfill?
    In Formulas and Functions
    Is there a way for smartsheet to implement an auto-downfill function that allows users to input their desired formula into a column heading that makes every cell within that column (including cells added in the future) populate with said f…
    1008 6
    1K views 6 comments Most recent by Andrée Starå Formulas and Functions
  • Formula help
    In Formulas and Functions
    Hello, I am trying to do a vlookup on my smartsheet task list to reference a different smartsheet which looks up for example "312" returns the value two columns over, which is a date, and then minus 90 days from that date and ret…
    2 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Nested IF and OR (and possibly AND)
    In Formulas and Functions
    Hello, I have two checkbox columns: one for Arabic and one for English.  These columns will either be checked, unchecked or say "n/a". What I want is to have another checkbox column where it is checked if Arabic and English are…
    1 view 1 comment Most recent by Paul Newcome Formulas and Functions