Formulas and Functions

Archives for February 2022

Discussion List

  • What is your method for creating recurring tasks?
    In Formulas and Functions
    I have a Task List sheet which is pretty standard stuff. Task Name, Due Date, Assigned To. But we create some tasks that are a recurrence, like, "Check on Person A Every Two Days." Obviously, I can manually (using a formula to in…
    Answered - Pending Review
    98 4
    Answered - Pending Review 98 views 4 comments Most recent by Genevieve P. Formulas and Functions
  • Multiselect Choices - Pull from Another Smartsheet?
    In Formulas and Functions
    Greetings! Reaching out to the Smartsheet community for assistance with a multiselect question. I have a Smartsheet that contains a client list, we'll call it Client List. I would like to add a multiselect drop-down to choose the various…
    Answered - Pending Review
    14 2
    Answered - Pending Review 14 views 2 comments Most recent by John Crick Formulas and Functions
  • How to eliminate false counts on created date (auto-number deleted line items)
    In Formulas and Functions
    Hi there, Thanks for helping with this. I'm creating a sheet summary formula that does a count of items created within a specific year. All good there. =COUNTIFS([C-Year]:[C-Year], "2022") The wrinkle is that the sheet has autonu…
    Accepted
    26 1
    Answered ✓ 26 views 1 comment Most recent by AMB_L Formulas and Functions
  • Is there a way to combine a sumif and a countif function within one formula?
    In Formulas and Functions
    I am trying to find the number of "tasks" completed within a certain date range. The following are the formulas I have been using, but I can't figure out how to combine them. =SUMIF({Content Type}, CONTAINS("Wiki", @ce…
    Answered - Pending Review
    29 3
    Answered - Pending Review 29 views 3 comments Most recent by Jeff Reisman Formulas and Functions
  • Including child rows in filters
    In Formulas and Functions
    I have a follow-up question to a question I asked earlier today about including parent rows in a filter. Now I'm wondering: is there a way to create a filter and include the matching rows' child rows (when the children don't match the fil…
    Accepted
    88 5
    Answered ✓ 88 views 5 comments Most recent by Brian Pitts Formulas and Functions
  • Training Database Help
    In Formulas and Functions
    I have a column that has the date that safety training was completed. I would like the cell to turn red if the date is expired. The date would be three years after the training was taken. I tried to use conditional formating but could…
    Answered - Pending Review
    15 3
    Answered - Pending Review 15 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • How can I join non-consecutive parent and child rows into a single name.
    In Formulas and Functions
    I've searched the community and can't seem to come up with an adequate answer. I've made myself a helper column, and I'd like to join or concat the parent with each of the child rows, but I keep coming up unparseable. Here's what I'd like…
    Accepted
    26 5
    Answered ✓ 26 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • NETWORKDAYS FORMULA
    In Formulas and Functions
    Hello, I am trying to construct a formula to calculate the number of business days between two date columns (date received and date entered into system, for example) within a specific date range (from 02/18/2022 - 03/18/2022). How can I …
    Answered - Pending Review
    76 4
    Answered - Pending Review 76 views 4 comments Most recent by Sidonia Posteuca Formulas and Functions
  • Missed Premium deduction Formula.
    In Formulas and Functions
    So I need a formula to compare the date an insured coverage began against the date they selected benefits and provide the statement either one missed payment or two missed payments. So I have two Columns: Coverage Start Date ----- Date Co…
    Accepted
    12 2
    Answered ✓ 12 views 2 comments Most recent by April Barrera Formulas and Functions
  • Approval Automations
    In Formulas and Functions
    We have created a form that requires specific approvals based on the job title of the person submitting the form. There are two different variables with the approval process. 1. If they do not select the manager assigned, then it would go …
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Andrée Starå Formulas and Functions