-
Formula issue
Hi Brain Trust We have a formula set up to report when two columns don't have the same drop-downs selected. =IF([Candidate Compliance & Training Check]@row = [Job Compliance & Training Requirements]@row, "Low", "High") The team now want to use the following symbols What or how can I set up a formula that will give me :-…
-
Trying to set up options to fill cell itself or from a formula in another column.
To track staff attendance, one column (Call Out Type) we have is a drop-down with 5 options. We want to have a separate column (Call Out) that would be included in the form the staff fill out when calling out that would include 3 of the 5 options. I set up a formula that would copy the value in the Call Out column into the…
-
Make a checkbox that is used on 2 sheets show the same value.
I have a checkbox called "Pause" that is located on a sheet called "Schedule Sheet" that needs to be the checked/unchecked based on a "Pause" checkbox located on a sheet called "Periscope Request Tracker". if the checkbox is checked on the Periscope Request tracker then I need the checkbox to be checked on the Schedule…
-
Report includes the Latest Comment field, updates from report do not flow to source sheet.
Created report for our RAID log. The report includes the Latest Comment. If updates are made to the source sheet the report correctly updates the Latest Comment field. However, if an update is made to the report field Latest Comment, that update will not pass back to the source sheet. Before the Latest Comment was released…
-
COUNTIFS for Escalation Tracking
I am looking to create a formula that counts the how many times over the last 12 months escalations of a certain deal size occurred. Deal size is represented as range of AUM in text format. The current formula I'm using is =COUNTIFS({Escalations Range 1}, "75M - 150M", {Escalations Range 2}, >TODAY(-365)) I created a…
-
Assistance with returning cell data base on most recent day in specified year.
I am trying to create a formula on a sheet summary that returns the information in my row titled Total that corresponds with the most recent date within a specified year. I came up with the following formula but it is returning #No Match =INDEX([Total]:[Total], MATCH(MAX(COLLECT([Report Date]:[Report Date], [Report…
-
Need a column formula to pull balance from last row
I have looked at multiple questions and threads on the community and not found an answer that works. I am trying to create a column formula that pulls the [Balance] from the previous row into the current row entry. I was getting a #circular reference error, I tried IFERROR and some recommendations on other posts, but…
-
Average Time for Chart
Hi all, I'm having trouble calculating an average duration of a time to resolve per quarter. This information is in two columns on a sheet: Time to Resolution (data type Duration) and Incident Year/Quarter (dropdown list). I've looked in the time articles and downloaded the formula template, and still missing the right…
-
How to share contacts in a published sheet?
I have contacts in my published sheet. I have it as Read Only - Full so the names can show and the emails if one hovers over it. But it doesn't allow external people to quickly copy the emails. Other than creating more columns to display the email, what other ways could I easily show the email address for others to copy,
-
Index Match for Contact List
I'm using an IFERROR formula with INDEX MATCH to pull names from two separate sheets, both of which use a contact list column type. However, for some entries, I get a contact list icon (with the email attached), while for others, I only see the individual’s name as plain text. I can't figure out why there's an…
