IF(
Discussion List
- Hello Everyone. I'm after help making this work in a single column if possible I'm wanting to create a Due Column that will tell you if the end date of the task you are working on is in "This week", "…
- =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…
- 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 g…
- 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 th…
- 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 sho…
- 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]@ro…
- 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 …
- 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…
- 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…
- 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 St…