This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.
Log in to ask a question

How to count the number of jobs based on multiple conditions?

Posted on 02-01-2023 01:17 AM
jkevz07
Bronze 4
Bronze 4
Reply posted on --/--/---- --:-- AM

Hi! in excel I used the formula Countif. In the appsheet, I used the expression of Count and Select but its not working. Can you help me with my code below, the expression is fine but it's not counting based on the given data in the form.

COUNT(SELECT(Customer Log Sheet[Status], AND([Status] = [_THISROW].[Required Job],[Date & Time (Started)] = [Date (From)],[Date & Time (Ended)]=[Date (To)])))

 

jkevz07_0-1675243084771.png

 

0 1 288
Topic Labels
0 Likes
1 REPLY 1
Top Labels in this Space