-
What is your method for creating recurring tasks?
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 increment my dates =WORKDAY([Due Date]5, 2)) create a bunch of tasks out into the future, and…
-
Multiselect Choices - Pull from Another Smartsheet?
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 products that this client subscribes. This product list is maintained in another…
-
How to eliminate false counts on created date (auto-number deleted line items)
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 autonumbering and so I'm getting a false count with 4 items that were created and then deleted. No…
-
Is there a way to combine a sumif and a countif function within one formula?
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", @cell), {Task Counter}) =COUNTIF({Date Received}, >=DATE(2022, 1, 1))
-
Including child rows in filters
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 filter criteria)? So say I created a filter for all rows matching "teaching/mentoring"…
-
Training Database Help
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 not figure out to set up the correct statement to format the cell red?
-
How can I join non-consecutive parent and child rows into a single name.
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 to do. I'd like to have "Start-Task 1" show up next to Task 1, and "Start-Task 2"…
-
NETWORKDAYS FORMULA
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 accomplish this if at all possible. Please help. Thank you!
-
Missed Premium deduction Formula.
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 Coverage Elected - Missed Payments 2022-02-01 --------- 2022.02.10 ---------------- 1…
-
Approval Automations
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 to the final approver. 2. if they do select the manager, then it would go to another…