Super newbie : sum-select pls help

[Accounts_Queenstown]

SO NEW and so LOST! HELP PLS!

I am trying to create a basic manual entry timesheet app

(Ideally there’s list of clients and each staff will be assigned to client/ different client per day- and so Ideally I can have the total hours they work for each day)

My Columns are:

STAFF

WORK HOURS (st on increments of .25 - represents every 15 minutes)

DATE

I just need to get the TOTAL HOURS of each STAFF they have done for each day

I am trying to put the formula on total hour as: the SUM on TEST shows correct SUM but the SUM on app preview is wrong) HEEEELP!

SUM(
SELECT(
ENTRY[WORK HOURS],
AND(
[DATE] = [_THISROW].[DATE],
[STAFF] = [_THISROW].[STAFF]
)

)
)

[Syamsudin]

Hi @Accounts_Queenstown

My suggestion is to change the formula to

SUM(SELECT(
ENTRY[WORK HOURS],
[STAFF] = [_THISROW].[STAFF]
))

then from ux select Group by then click add >> select the date or staff column to group by date or staff and from group aggregate select sum work hours. Hopefully this will solve your problem.

Just sample

[Steve]

Your key column, STAFF, is wrong. The values of the key column must be unique–only one of each value–but your STAFF column contains HOLLY twice. This will definitely cause problems.

What is a key? - AppSheet Help