HeyHansVogelaar, I'm now trying to edit the formula to look at referrals from the last year rather than still waiting. I've tried substituting theApr24Apr25[Status], "Waiting"forApr24Apr25[CAMHS NDC Referral Date],">"&TODAY()-I760with I760 holding the number of days back the user wa...
Apr24Apr25[CAMHS NDC Referral Date],\">\"&TODAY()-I760with I760 holding the number of days back the user wants to go (e.g. 31 for a month, 365 for a whole year). This works for all the other formulae on the tab, but this one is not happy. What I'm trying unsuccessfully is...
The research question askedhow can mental health service providers meet young people’s needs for mental healthcare?Accordingly, the aim of this research study was to improve understanding on young people’score needsin mental healthcare through evaluative inquiry of their help-seeking experiences to ...
Ford T, Sayal K, Meltzer H, Goodman R: Parental concerns about their child’s emotions and behaviour and referral to specialist services: general population survey. Br Med J. 2005, 331 (7530): 1435-1436. 10.1136/bmj.331.7530.1435. Article Google Scholar McGorry PD, Goldstone S: Is thi...
HeyHansVogelaar, I'm now trying to edit the formula to look at referrals from the last year rather than still waiting. I've tried substituting theApr24Apr25[Status], "Waiting"forApr24Apr25[CAMHS NDC Referral Date],">"&TODAY()-I760with I760 holding the number of days back the user wa...
, I'm now trying to edit the formula to look at referrals from the last year rather than still waiting. I've tried substituting theApr24Apr25[Status], "Waiting"forApr24Apr25[CAMHS NDC Referral Date],">"&TODAY()-I760with I760 holding the number of days back the user wants to go (...
It should be =INDEX(Apr24Apr25[Forename], XMATCH(1, (Apr24Apr25[PW]=MAXIFS(Apr24Apr25[PW], Apr24Apr25[CAMHS NDC Referral Date],">"&TODAY()-I760))*(Apr24Apr25[CAMHS NDC Referral Date]>TODAY()-I760)))