Silver 3
Since ‎05-04-2022
Thursday

My Stats

  • 341 Posts
  • 25 Solutions
  • 15 Likes given
  • 54 Likes received

desmond_lee's Bio

Badges desmond_lee Earned

View all badges

Recent Activity

Hi AllT create 7 days in future after a define date is easy (IF(OR([CCNX]=0,[CSGK]=0,[CTWN]=0,[CCNZX2]=0,[CCNZX1]=0,[CCNKB]=0,[CCNZB]=0,[CMYP]=0),WORKDAY(DATE([SHARING DATE]), 7),"")).Is is possible to create last 7 workday of every month?
Hi ExpertsI don't know how to workaround on this. See Below table.In the OE Lead Table, I want to send 2 emails to & on the condition that when another table i.e. Survey Matrix table (Col H until O that any row show 0 value) After 7 days from the d...
Hi GuysSee those project name is way too long. I set this 40 character length? Does it really work? I tested does not seems to work to me.
Hi ExpertsI manage to successfully update Q1 Site Score table (In fact there are 3 other similar table like this) value base on PROJECT SITE NAME as key with this expression below.COUNT(FILTER("Test Record",AND([ANSWER 1]="BARELY",[RPT Q_ID]=1,[PROJE...
Hi ThereIn the below expression I use 1 and 0 as expression. Is it possible to replace this with a special tick character in appsheet?IF((COUNT(FILTER("Test Record",AND([PARTICIPANT`S SITE NAME]="CCNX",[PROJECT ID] = [_THISROW].[PROJECT ID]),)))>=1,1...