Formulas

 

Discussion List

  • Summary Field, Date Within Range using SUMIFS
    In Formulas and Functions
    Hi, I am trying to use the following SUMIFS formula but I receive a "#INVALID OPERATION" error when trying to create a Sheet Summary Field using the formula. =SUMIFS(Hours:Hours, Status:Status, "Confirmed", FinishDate:…
    Accepted
    12 3
    Accepted Answer 12 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • formular syntax code editor
    In Formulas and Functions
    Hi all, I have some complex and long formulas in my sheet wit a lot of brackets. Do you know any syntax editor which I can use to document and analyse the formulas? Should have highlighting for opening and closing brackets etc. Thanks
    Answered - Pending Review
    41 6
    Answered - Pending Review 41 views 6 comments Most recent by BKing Formulas and Functions
  • IF Function to return Yes or No depending on difference between two dates.
    In Formulas and Functions
    Hello, I have two date columns; [First Date of Absence] and [Start Date]. I am trying to write a formula that returns "YES" if the difference between [First Date of Absence] and [Start Date] is less than or equal to 182 and retu…
    Answered - Pending Review
    18 5
    Answered - Pending Review 18 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Am unable to retrieve Dates from one smartsheet to other
    In Formulas and Functions
    While am trying to use vlookup function the limitation threshold is an error prompt. I tried to use Collect and Index Collect function however they are giving me error prompts as # Date Expected and Incorrect Value
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • Sum of expenses of child rows in a formula row
    In Formulas and Functions
    Hi I have a sheet wherein a column contains all the expenses that is basically generated from the sum of other cells in the same row. This row is indented and I wanted to know if I could have the total of this in the parent of this row. …
    Accepted
    7 3
    Accepted Answer 7 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Show next pending task in Summary
    In Formulas and Functions
    Hello, I am trying to show the next pending (open) task in Summary, so it will show on my Summary report as well. In the summary report I also want to show the delivery date for that task. Basically if the previous task is Completed (che…
    Unanswered
    6 0
    Question 6 views 0 comments Started by Marianna Antoniou Formulas and Functions
  • How to not skip ranks and deal with ties?
    In Formulas and Functions
    Hi all, I worked with the Prodesk on using the RANKEQ function which was helpful, but I am realizing I have records which are ties. Essentially I have a column which ranks our projects; if the weight is 0 it's "not ranked" and s…
    Unanswered
    10 0
    Question 10 views 0 comments Started by summetg Formulas and Functions
  • Formula to collect column names if there is a "1" present
    In Formulas and Functions
    I have a pivot table that I am attempting to use in order to collect a list of all jobs that our subcontractors have/are working on. Basically, I want a roll up of all jobs that each sub has worked on. The sheets where this info is held ar…
    Unanswered
    18 0
    Question 18 views 0 comments Started by Natalia Kataoka Formulas and Functions
  • COUNTIFS and CONTAINS
    In Formulas and Functions
    Hi! I need some guidance for a count analysis of our RAID Log (Risks, Issues, Decision). In the RAID Log source sheet, we have a column where the team selects the Project(s) the risk or issue is tied to. The Project column is set up as mul…
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Brett Wyrick Formulas and Functions
  • How to implement default highlight color in to field name
    In Formulas and Functions
    Hello, At present Smartsheet providing highlight changes for recent updates. Is it possible to add a column/field to indicate the recent changes col name in that field.? For example I want to see all the recent changes for the past 2 days…
    Answered - Pending Review
    17 2
    Answered - Pending Review 17 views 2 comments Most recent by hari_23 Formulas and Functions