I’m trying to create a formula whereby :
IF [date 1] is after [date 2] OR [date 3] is after [date 4] to tell me “Needs Review”, otherwise “Updated”.
How do i do this? i’m not sure how to compare the date fields.
Thanks!
Would be great if we could truncate the above or hide it - it takes up so much space in a view where I’d want my team / users to be navigating to views rather than making them.
Thanks!
I’m trying to put together a formula IF statement to extract certain parts of a URL depending on what is found in a specific cell for that record.
In plain language: IF {Published on/by} is “Website.com” pull 6 characters after “post=” in the {URL or...
I’m trying to have a field formula yield the later year found between two date fields (even if one of the fields is blank). I’m completely confused how to add a IS_BEFORE function into the IF(OR) statement…
The fields I’m working with is: {Last Modif...
Hi! I’m trying to get a field to output one of 4 results based on what it finds contained in a single Formula Field (Date reformatted field to YYYY-MMMM, pulling from the MMMM portion).
If {Year/Month} is “Jan” or “Feb” or “Dec” or “Nov” = “WINTER”
I...
I tried @augmented 's formula and it said something was wrong with it. I will play with it on Monday when I’m back to work…
I also tried the “plain english” → “formula” using the advice from @Kamille_Parks and came up with this – and grrrr. AT still ...
When I input the formula you provided that checks for blanks, the formula yields nothing for records where the Last Reviewed Date is blank, but has a Pub Date.
I’m thinking it needs a revision to allow for one or the other being blank but not sure ho...
Hmm… for some reason that’s not working. The earlier formula (Without checking for blanks), would give me the false output “2017 and older” for any rows where one of the dates are blank.
I wonder, is there a way to state this formula so that i tell i...
Ah yes - I am starting to get my brain around the logic…!! Thank you!
However, if one of the date fields is blank, it doesn’t give me anything.
Tried this, but I can tell it’s wrong – not sure how to add another OR condition…
IF(OR(MAX(YEAR({Last Mod...
