Formulas and Functions

Archives for December 2018

Discussion List

  • SUMIF Formula returning incorrect number
    In Formulas and Functions
    Hello! Smartsheet newbie here:) I was trying to use a simple SUMIF formula to calculate the total number of days for a specific field. For example: I want to add all the days or duration for all projects that were labeled as "Conver…
    21 3
    21 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Nested IF(ISBLANK & Date Columns w/Progress Bar
    In Formulas and Functions
    Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar.  Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've …
    61 2
    61 views 2 comments Most recent by lisarae723 Formulas and Functions
  • Keeping persistent dates for status changes
    In Formulas and Functions
    Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done.  I'd like to track cycle times and throughput.  I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and…
    51 4
    51 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • COUNTIFS a start date is less than today, and is an ancestor level 3
    In Formulas and Functions
    I am currently struggling with the following COUNTIFS formula =COUNTIFS(AND([Start Date]:[Start Date], <= TODAY(), ISDATE([Start Date]:[Start Date]), [% Complete]:[% Complete] <= 0.5, [Helper Column]:[Helper Column] = 3)) It should…
    21 3
    21 views 3 comments Most recent by Brian W Formulas and Functions
  • Date Stamp
    In Formulas and Functions
    Over the past couple of days, I have searched and read every article and even solicited help from SS and have worked myself in a circle. I have a drop-down list (Submitted, Approved, Declined), I need to "auto-populate" a date c…
    612 22
    612 views 22 comments Most recent by Mike Wilday Formulas and Functions
  • Formula cross referencing sheet via template
    In Formulas and Functions
    Hello!  I have a workflow created using Zapier so that when a new row is added to my master project sheet via a form entry it will update the first row in a template sheet and create a new project sheet from that sample sheet. This all wo…
    101 2
    101 views 2 comments Most recent by Dominique WINTHER Formulas and Functions
  • Lookup on a form?
    In Formulas and Functions
    Hi all,  Is there a way to have a date/time field on a form look up data in a separate sheet to populate itself? I'm setting up a form for people to select a date and time slot to attend a training session. I thought about having the lis…
    184 6
    184 views 6 comments Most recent by Paul Newcome Formulas and Functions
  • Calculating total hours worked in a shift
    In Formulas and Functions
    I'm trying to create a weekly work schedule for all of the employees at our company, so that we can see the start and end of shift and total hours worked per day and per week for each employee.  I contacted the Smartsheet team only to fin…
    512 7
    512 views 7 comments Most recent by Paul Newcome Formulas and Functions
  • If Statement for three columns
    In Formulas and Functions
    Hi Guys! I am working on the following Formula:  =IF(AND([Date Completed]1 < (TODAY(-3)), Cause1 = "", Correction1 = ""), "Overdue", "OK") Goal: If the date in a date column [Date Completed] is…
    2 5
    2 views 5 comments Most recent by Kevin Sitech Formulas and Functions
  • if statement
    In Formulas and Functions
    Hi, Can someone help me on this formula. Please check the formula if the % is greater than 100 % its should shows as Yes but in my formula its showing as No.    
    1 3
    1 view 3 comments Most recent by Andrée Starå Formulas and Functions