formulas

TVP ALAN

Hallo

i need a forumle which count the QTY hits of timing between 08:30 en 17:30.

So in colomn F i need to have YES when the timing is between 08:30 en 17:30

Thanks

kowal

it shall be something like

=IF(AND(begin@row>8:30:00, begin@row<17:30:00), 1, 0)

but this would be for Smartsheet formula not excel :)

TVP ALAN

I have 14800 lines and when i need to upload in Smarthseet i need to split up per 500 that is way i use in excel for this on :o(

i hope someone can help me out

kowal

but smartsheet can take up to 20k lines

you can use datashuttle to move the excel to smartsheet all at once.