-
IF Formula Help
=IF([% Complete]@row < 0.1, "Not Started", IF([% Complete]@row > 0.1, AND ([% Complete]@row < 0.99, "In Progress", IF([% Complete]@row = 1, "Complete")))) I need help with this formula. I need the row to say Not Started if % Complete is 0%, Complete if 100%, and In Progress otherwise. Help Please!
-
Summary formula
Hey I'm trying to do this in a Sheet Summary: If [Date] is today, then show me the value in the same row in column G. This works for an individual row (1) =IF([Date]1 = TODAY(), [G]1, 0) But I can't get it to work with @row to search all the way down the sheet to look for the current date, I've tried these: =IF([Date]@row…
-
Need better solution for multiple nested IF statement
Hello, I have a sheet that tracks sprint numbers based on their date ranges. How can I identify the sprint number for a task using the task start date? Right now I'm using this very long formula in the Return sprint number column, and I'm hoping there is a better way to do this. Thank you! =IF(AND([Task Start Date]@row >=…
-
Formula Help: Show Status looking left to right, of what milestone cells show
Have a HUGE team smartsheet that several departments update other sheets and feed to this one. Want to have a status column based on the condition of milestone cells (will skip some minor ones) to show where we are as a team. So only one status should show. Thanks in advance! This is what I have so far: =IF([Date…
-
Nested IF Fomula help
Hi! Can anyone tell me what is wrong with my formula below? I am having trouble identifying =IF(ISBLANK([Contractor Name]@row), "No", IF(OR([Contractor Name]@row = "NA"), "No", IF([Contractor Name]@row = "RLM"), "No", IF([Contractor Name]@row = "Danny"), "No", IF(ISBLANK(Phone@row), "No", "Yes")))
-
IF OR/AND Function - Considering Dates (Future, Past etc)
Hi Team - I have a bit of a doozy.. at least it is for me. I have a sheet that needs a status populated considering 2 different date columns. If either "Expiry Date" or "Expiry Date 2" is in the past we need a "Red" status If either "Expiry Date" or "Expiry Date 2" columns are within the next 30 days "Yellow" Status If…
-
IF ERROR help for a nested IF AVG formula
Hi there! I have an IF followed by AVG formula that is working ok- looks at multiple columns and averages them (frankly it is problematic, because it returns an average even when not all 6 columns are filled out, help? Is there a way for it to only calculate the average once all 6 columns have a value added? Honestly if…
-
Will IF(MAX(Collect work?
Hello community, I am using a MAX(Collect( formula to pull in a number from another sheet where I calculate the number of days we have to lock a project's files after completion - this is pulling into our project tracker. The origin sheet is calculating the countdown number based on one particular type of work request and…
-
How to use if contains with similar words
I want to use if contains to find a word and classify it The problem I have is they are to similar it will always Classify it as A and not B. the description is to long for Has or just a regular if Statement. =IF(CONTAINS("EOR", description@row), "A", IF(CONTAINS("BOR", description@row), "A", IF(CONTAINS("CBOR",…
-
Need a formula to fill in a column based on a date column
Hi! I have a date column and i would like a forumla in another column to complete that cell with the word "completed" when the date is added. Im creating an exterior report that i want to show just the info for the completed rows but the only way we know its completed is by this date being added. If the date column is…
