Jyo_D - profile

Jyo_D · Oct 19, 2021

Hi Everyone, I have been trying to accomplish an error check and I have syntax issue on the below formula. May I please know what is the issue with my formula? Thank you so much in advance. IF(AND({est_filing_date_range_start},{est_filing_date_range_...

Jyo_D · Feb 27, 2020

Hi there, I am trying to figure out a formula to extract max year for a specific company based on the fields below. Max year should pick a max year for that particular company in the field. I tried using MAX function but it didn’t appear to work, is ...

Jyo_D · Nov 30, 2021

@Jordan_Scott1 - Interface designer is amazing by itself. Quick question though, can we embed interface designer into html?

Jyo_D · Oct 20, 2021

Justin_Barrett: IF( AND( {est_filing_date_range_start}, {est_filing_date_range_end}, {actual_or_estimated}, NOT({review_type}) ), " ERROR...review_type CANNOT BE BLANK when est_filing_date_range_start...

Jyo_D · Oct 20, 2021

Jyo_D: IF(AND({est_filing_date_range_start},{est_filing_date_range_end},{actual_or_estimated} Thank you so much @Justin_Barrett . I have modified the formula to include the BLANK() condition and it worked. IF(AND({est_filing_date_range_start},...

User Statistics

User Activity

Multiple conditional formula with IF, AND

Extracting maximum year grouped by another field

Re: Introducing Interface Designer 🎉

Re: Multiple conditional formula with IF, AND

Re: Multiple conditional formula with IF, AND