Rohit_Gandrakot - profile

Rohit_Gandrakot · Jan 04, 2020

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...

Rohit_Gandrakot · Jun 24, 2021

Waiting to see the solution here!

Rohit_Gandrakot · Jun 23, 2021

@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...

Rohit_Gandrakot · Jun 23, 2021

Great. Please take a minute to mark the reply as the solution. Much appreciated!

Rohit_Gandrakot · Jun 22, 2021

@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...

Rohit_Gandrakot · Jun 22, 2021

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...

User Statistics

User Activity

Error in copying values from AT rollup field

Re: How to import name and url from text file?

Re: Find the maximum of three date fields on one table

Re: Formulas for Date

Re: Formulas for Date

Re: Using Rollups to Return Text, Specific Records