Formulas and Functions
Archives for February 2022
Discussion List
-
What is your method for creating recurring tasks?In Formulas and FunctionsI 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 views 4 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
Multiselect Choices - Pull from Another Smartsheet?In Formulas and FunctionsGreetings! 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 views 2 comments 0 points Most recent by John Crick Formulas and Functions
-
How to eliminate false counts on created date (auto-number deleted line items)In Formulas and FunctionsHi 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…
-
Is there a way to combine a sumif and a countif function within one formula?In Formulas and FunctionsI 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 views 3 comments 0 points Most recent by Jeff Reisman Formulas and Functions
-
Including child rows in filtersIn Formulas and FunctionsI 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…
-
Training Database HelpIn Formulas and FunctionsI 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 views 3 comments 0 points 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 FunctionsI'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…
-
NETWORKDAYS FORMULAIn Formulas and FunctionsHello, 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 views 4 comments 0 points Most recent by Sidonia Posteuca Formulas and Functions
-
Missed Premium deduction Formula.In Formulas and FunctionsSo 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…
-
Approval AutomationsIn Formulas and FunctionsWe 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 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions