I have a complex formula which generates a value with double quotes (") in it. When I try to copy the field and paste it outside, the double quote is being copied twice.
For example,
if the text shows: Test"Test
the copied text once pasted shows: Tes...
@AM858 You can check if the date is empty first. If it is, you can assign a very early date like 1/1/1901. Now if all three are empty then it will return 1/1/1901 as max date. In this result, you can choose to leave the result empty. The following fo...
@Pascal_Vallet
You can probably use the WEEKNUM formula. The following formula should work.
IF(WEEKNUM(Date)>20,CONCATENATE(YEAR(Date),"-",YEAR(Date)+1),CONCATENATE(YEAR(Date)-1,"-",YEAR(Date)))
Where 20 is the week after which want to count it towa...
Andrew_Miller2:
And then just to close the loop here, it sounds like with this set up, I can then create a rollup in the Stories tab that displays note text for all note records whose note # value is less than or equal to 2?
You are right, thi...
