Meri_Wilson - profile

Meri_Wilson · Oct 07, 2021

Hi there! I’m trying to do a fairly simple formula but it has quite a lot of conditions. I’m a beginner and not sure where I’m going wrong, could someone help? The board is a basic project overview. I’m trying to set a column to display “on track” or...

Meri_Wilson · Oct 08, 2021

So I found a workaround for this as I noticed that the fields do autofill if you have grouping turned on, but not for the filter criteria. In your chosen filtered view, just set a new ‘group’ to be the field you want to autopopulate, and drag it to t...

Meri_Wilson · Oct 07, 2021

augmented: IF( AND( IS_BEFORE(Due,TODAY()), OR( Status = 'In Progress', Status = 'With Client', Status = 'Not yet started', ) ), 'Overdue!', 'On track' ) Ah perfect! Thank you so much for your help, and this has helped me...

Meri_Wilson · Oct 07, 2021

Hi augmented, thank you so much! That is exactly what I’m attempting yes. Unfortunately this is still giving me an error saying invalid formula - any ideas? I also checked the capitalisation of the Status options in case that was messing with things,...

User Statistics

User Activity

AND OR + IS BEFORE IF statement help

Re: Smart Defaults with Grouped and Filtered Views

Re: AND OR + IS BEFORE IF statement help

Re: AND OR + IS BEFORE IF statement help