PC1 - profile

PC1 · Oct 19, 2019

This formula from the blog produces the result with at time: 9/30/19 12;00am What part of the formula needs to change to eliminate the time? DATETIME_PARSE(DATETIME_FORMAT({Period},‘MM/DD’)&"/"&YEAR(NOW())) Thank You

PC1 · Oct 18, 2019

Hello, my first post to this community. This formula was entered and accepted with no errors. The issue is the second IF (in this case {Tax Type}='Sales Tax) does not produce a result. Here is the formula: IF({Tax Type}=‘Bank Rec’,IF({Qtr}=1,‘1/31’,I...

PC1 · Oct 21, 2019

Thank You! I tried replying to this with a thumbs up but it wouldn’t accept it?

PC1 · Oct 20, 2019

Not sure if this is your issue but here is a link to a similar problem I had. It was suggested (and worked) to add AND. Second "IF" in nested statement returning no result Formulas Hello, my first post to this community. T...

PC1 · Oct 18, 2019

Justin, it worked. I really appreciate not only the reply but the quick and concise explanation. The AND function allows for the comparison i was looking for. Also I am glad you mentioned about the single select field. i have been using the multiple ...

User Statistics

User Activity

How to remove "time" from this formula

Second "IF" in nested statement returning no result

Re: How to remove "time" from this formula

Re: IF formula not working to pull data from two columns

Re: Second "IF" in nested statement returning no result