Hi Kat
If, for example, the name of your field is “States” with string value similar to AA AB AC AD etc this formula should work for you:
IF(LEN(States) > 0, (LEN(TRIM(States)) - LEN(SUBSTITUTE(States, " “, “”))) + 1,”")
It handles empty cells, dou...
You’ll need to do a compound filter.
Make the first line: Where | Date | is on or after | the first day of the month
Make the second line: Where | Date | is on or before | the last day of the month
This will return the results of days between the two...
I’ve always has issue with the length of the fields parameter, especially when you require only 20 out of 30 fields, you end up with a ridiculously long string. Does anyone know of a way to reduce the size so that you don’t end up with a string of en...
I think that’s just a simple >"" so,
IF({Finish Date} > “”, DATETIME_DIFF({Finish Date}, {Start Date}, ‘days’),DATETIME_DIFF(TODAY(),{Start Date}, ‘days’))
