- COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
- Copying Alerts From Column on Sheet 1 to Column on Sheet 2
I've set up a set of three alerts triggered by a date in a column and it's quite lengthy (but works). I now want to eliminate rekeying it to 15 other sheets within the same workbook by copying the alerts and placing them in the remaining sheets. Is there a way to paste them into another sheet? Please let me know if anyone…
- Alerts & Reminders for "Assigned to"
你能发送提醒给即将到来的任务由于年代吗omeone that is "Assigned to" a task? Currently I just send the automated reminders to shared users but, recently I had the need to just send particular tasks to selected individuals that would not be interested in the majority of the other tasks. I am thinking the answer is…
- Need help getting multiple sheets pulled into a single report in the correct order
I have three "what if" schedules that I'm trying to pull into a single report. They are simply named Scenario 1, Scenario 2, and Scenario 3. No matter what order I select them, the resulting report has #3 in first position, #1 in second, and #2 in last. I did a bulky workaround by adding a Helper Column in each sheet…
- Formula help - due dates falling on weekends
I've got formulas in my sheet that calculate due dates that fall on weekends, and I've used conditional formatting to highlight those dates to alert me to those dates that are on Saturdays and Sundays. Now, I want to move those dates to the Monday next. Is there a way to automate that? Ultimately, I need the best way to…
- Turn off display of weekends on Calendar view
I do not want weekends to display on the Calendar view of a task list, but I don't see any way to do this in the properties. How is this accomplished?
- Will we ever be able to assign a task to multiple resources?
Is there any update on when this feature will be implemented? I cannot believe it is still not possible to assign a task to multiple resources. We are going to need to move to another site soon if this issue is not resolved. It seems crazy that after 12 years, this essential feature still does not exist, while something as…
- Multiple people assigned to one task
If I have multiple people assigned to a task, could I create two "assigned to" columns (each with a slightly different name) and still use the notifications and reminders without issue? That would prevent me from having to create two duplicate tasks when I want to assign to multiple parties.
- Report view without access to underlying sheet
We are attempting to create a report view that is a subset of rows driven by a column flag. We have found that the report viewer will also have access to the underlying sheet with all of the details. Our goal it to provide a highlevel summary via the report and restrict access to the subtask details.
- Counting total specific drop-down option between 2 dates
Hello! The sheet that I am working with is used to track agreements my department works with. Two of the data points (among many) that we capture is the agreement type within a drop-down and the signature date. I would like to capture the total "Amendment"'s from the drop-down list with a signature date that fall in our…
