-
Help with multiple IFContains Statements
Hi there, I'm trying to do a formula but it doesn't seem to be working. I basically want to put a Yes or No in a sheet if 2 conditions are met - if one column of another sheet contains the age group 20-30 AND if another column of that sheet contains a code. =IF(CONTAINS("20-30", {NELFT Talking Therapies - Message Request…
-
IF(AND formula Assistance with #Invalid Operation error
I am trying to pull in a status to separate grid , Criteria is as follows: When Initiative is Checked and Milestone is specific name "Tech Deployment", return value in Status column, else leave cell blank. =IF(AND({Initiative Checkbox} = 1, {Milestone} = "Tech Deployment"), {Status}, "") Appreciate any assistance anyone…
-
Help with IF / Then Subtraction
Hi All, For our Project Management team, we calculate the total duration or 'Cycle Time' of our projects which is working well. However, sometimes, projects are on hold for a number of days. I would like to create a formula that subtracts the number of days a project is On Hold( "On Hold Duration" Column) from the Total…
-
=IF(AND) formula issue
Hi All, I'm hoping that there may be somebody who can assist with a rather strange formula issue i'm having. We currently run a Smartsheet for a client who book large hotel room blocks. To ensure we are across the multiple changes that are made and that the allocation we have booked is met, we use the Smartsheet to count…
-
Index Match Copy email matching employee IDs
Hello, I need to fix my formula to copy an employee's email based on their Employee ID numbers matching. I have one sheet where the emails are stored I am abbreviating it as FN in the formula. and EID is employee ID. When I enter this I receive the "INVALID REF" error. =INDEX({Personal Email FN}, MATCH([Employee ID]@row,…
-
=IF formula question
Hi, I wanted to use a formula to input a Pass or Fail dependent on if one of the columns to the left of the score showed a f. If any of those columns show an f it would need to read Fail. Help?
-
How do I write a IF statement from one sheet to another
So pretty much, how do I get John Smith, Dean Smith with DCI product total of 7280+3952 into the sheet below with a IF statement? also for Jaden and Bobby Smith with ACI product total of 3952+3952 into the sheet below with a IF statement?
-
Masking/Restricting Access to Specific Rows
I have a sheet that multiple managers have access to; however, it contains specific human resource/labor relations information across several departments. We were wondering if there is a way to restrict certain users from seeing rows (and/or columns) that don't pertain to them or that we deem "private". Is that possible?
-
Schedule Health from End Dates and % Complete
Hello, I am currently trying to create a formula for my schedule health based off the red, yellow, and green symbols. I want green health to be if the % complete is 100% or the [End Date]@row > TODAY(). I want the red health to be [End Date]@row < TODAY() or if the % complete is less than 100%. I am not worried about the…
-
sort a project schedule to show only 6 weeks
Does anyone know how to sort a project schedule to show only 6 weeks of a particular date range ?