-
Duplicate data formula which references two values
Hello Community, I am trying to find duplicate invoice numbers for the same client within two of my sheets. I need to show if there have been any duplicate invoices for clients using two criteria but am unsure how to create the formula. I want this information to show in a checkbox form. =IF(COUNTIF([Invoice #]:[Invoice…
-
How can I subtract a changing number of days from a date?
Hi there, I have a "Due Date" column and an "Order By Date" column. The Order By needs to reflect a date that is the Due Date minus our lead time (reflected in a third column and listed as a number of days). The issue is that the lead times change and vary from product to product. So I'm trying to create a formula that…
-
How can I view who makes changes to a grid if 2+ people have edit rights?
Greetings- How can I view who makes changes to a grid if 2+ people have edit rights? I have a grid with 2+ people granted edit+ rights to make changes to anything. Concern from both parties is one person will change something wo the others knowledge. Any way to track or see what user did what? Thank you!
-
Is there a way to combine these two formulas? IF and NETDAYS, use of TODAY function
I would like to return a value based on the total number of Medicare Days used prior to admission, plus the total days elapsed since admission to calculate day 100, or benefit exhaust date. I've worked out the individual pieces but I'm having trouble combining the two. In the Days Remaining Column, I have this: =100 -…
-
Combine COUNTIF and OR
Trying to count "Activity" by State, with the Activity Column formatted as a drop down column with multiple selections. Formulas are on a separate worksheet, and I am referencing cell ranges. I have all states listed in one column, and referencing the "State" range an Individually, the two formulas below work successfully.…
-
if and statement with concat cells
[R4R] - green or red [Adjusted] - green or yellow if green and green cell = [MS1] if green and yellow cell = [MS2] but the data in MS1 & MS2 are concat from multiple cells in the same row. the formula says the argument is wrong. Does anyone know if possible?
-
Join & Collect Children: 1 Occurrence
Smartsheet Community: How can I modify this formula where it only Collect 1 Child Occurrence? Existing Formula: =JOIN(COLLECT(CHILDREN(), CHILDREN(), <>""), ", ") Children: Chrome, Chrome, Firefox, Safari, Safari Thanks
-
COUNTIFS- Sheet Summary
I had several Sheet Summaries entered and pulling in to a dashboard. Not sure what happened, but they are all non functioning. I am having a total brain lapse on how I accomplished the summaries below. I had a summary formula to COUNT the total "ASA's" expiring each month. I can't even remember if I used the Month and Year…
-
Need a formula to compare 3 columns and return value
Source sheet has 3 columns Test, System, Impact. In Target sheet i need individual Impact value by comparing values in Test and System columns. Formula is not working, it is considering blank count. i dont want blank to be considered: By the below formula blank is considered. =COUNTIFS({Test}, "Sony", {Impact}, "Critical",…
-
Formula that changes status symbol based on check box checked/un-checked
I'm trying to create a formula that changes my status column to the red or green symbols. I looked at some examples on the site, but wasn't able to get it to work on my sheet. I was trying to set up a formula around the following parameters.. If check box is checked then green If check box is un-checked then red I have…
