Formulas

 

Discussion List

  • Countifs with reference to another sheet
    In Formulas and Functions
    Hello, I am trying to use the following formula: =COUNTIFS({Facilities Scorecard - All Lots Region}, "1", [{Facilities Scorecard - Traffic Count Standard}, "Y,"]) and =COUNTIFS({Facilities Scorecard - All Lots Region}, …
    Answered - Pending Review
    6 4
    Answered - Pending Review 6 views 4 comments Most recent by AMendy12 Formulas and Functions
  • Count Netdays if Project Status is "Complete"
    In Formulas and Functions
    Hello Forum, I am having difficulty writing a formula to count NETDAYS if a project status is "Complete". I hope this is not too confusing, but here goes..... 3 COLUMNS: "Project Status", "Actual Start Date&q…
    Accepted
    18 3
    Accepted Answer 18 views 3 comments Most recent by Dearick Milton Formulas and Functions
  • Change symbol based on date
    In Formulas and Functions
    Good morning Everyone,  I have been having some issues configuring a formula in smartsheets. Currently the only two columns that matter are named "Status" and "Last Run". What I'm trying to write is a function in which…
    405 4
    405 views 4 comments Most recent by 22Wordsmith Formulas and Functions
  • Date 6 months out (to the day)
    In Formulas and Functions
    Hello colleagues and guests. I would like to learn a forumula to retrieve a date that is exactly six months later than a known date; i.e. Jan 1 - July 1, Feb 4 - Aug 4. Presently, I'm using 182 days, which is close, but not exact. I'm also…
    1116 10
    1.1K views 10 comments Most recent by EimearC Formulas and Functions
  • Programming with Smartsheets
    In Formulas and Functions
    Is there any way that I can use external programming to effect my Smartsheets. Is there an API that would let me right seperate programs to control my Smartsheets?
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Cell Link or Formula for Start and Finish Dates
    In Formulas and Functions
    I'm looking to find a solution to populate the start and finish date columns based on info in another sheet. However, because I have dependancies turned on the date columns cannot use a vlookup or other function to pull the dates from anot…
    Unanswered
    9 0
    Question 9 views 0 comments Started by Matt Toews Formulas and Functions
  • need help with an IF function
    In Formulas and Functions
    Hello community, I am trying to come up with a cell formula that is a simple difference function, but I need it to be triggered by the number in another cell. It is for an inventory/ordering sheet. Someone will count the inventory and typ…
    Accepted
    17 2
    Accepted Answer 17 views 2 comments Most recent by Sarah_lee123 Formulas and Functions
  • If with And Formula help
    In Formulas and Functions
    Hello, I'm trying to write an If with And formula to flag if my micro/QC column contains a specific phrase, and my Date Submitted column is past its date by 12 days. Here's what I have =IF(AND([Date Submitted]@row - TODAY() >= 12, [Micr…
    Accepted
    17 7
    Accepted Answer 17 views 7 comments Most recent by Sarah Waldrop Formulas and Functions
  • Date Formula Automation
    In Formulas and Functions
    I am trying to auto generate a start and end date for each task in a project tracker. I want the start date of the new task to look at the prior task, add the number of days to complete and then calculate the nest start date (and end date…
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Genevieve P. Formulas and Functions
  • SUM a value found in a string within each cell across a range?
    In Formulas and Functions
    Due to memory limitations i have all projects rolling up some user metrics data into a single cell per project. This cell has a text string with a value, followed by another text string and value, over and over for all my variables, for ex…
    Answered - Pending Review
    21 1
    Answered - Pending Review 21 views 1 comment Most recent by Paul Newcome Formulas and Functions