Colin_James_Bel - profile

Colin_James_Bel · Jun 04, 2019

OK, I am building a personal relationship manager. I am trying to set a column to calculate a yes/no variable if 2 conditions are met (to tag a row “Overdue” if it’s been over 45 days since I last contacted them in the date column next to it). I ha...

Colin_James_Bel · Jun 04, 2019

JonathanBowen: SWITCH( Tags, ‘Family’, IF(DATETIME_DIFF(TODAY(), {Last Catchup}, ‘days’) > 45, ‘Overdue’), ‘Friends’, IF(DATETIME_DIFF(TODAY(), {Last Catchup}, ‘days’) > 30, ‘Overdue’), ‘Networking’, IF(DATETIME_DIFF(TODAY(), {Last Catchup}, ‘da...

User Statistics

User Activity

Issue with "And" Conditional Statements

Re: Issue with "And" Conditional Statements