To Calculate the count of New Entries

Hi,

I'm Uploading the Attachment 4 times in a Day, I need to calculate the new rows added every time. Kindly suggest some logic to achieve this.

Example: At 10 AM, while Uploading Data, 2 rows are newly added, now count will be 2.

Again 2PM, while Uploading Data, 3 rows are added, now count will be 3. it should not show 5.

Thanks,

Sandhiya P

Best Answer

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭
    edited 03/14/22 Answer ✓

    Hi @Sandhiya07,

    Try this way.

    You add a helper column "New row" and create 3 workflows.

    1st change cell value workflow will change "New row" to "checked" when new rows are added

    2nd change cell value workflow will run everyday on 11AM to unckeck all rows that have "checked" value

    3rd change cell value workflow will run everyday on 3PM to unckeck all rows that have "checked" value

    So before 11AM and 3PM, you can count all rows that have "checked" value

    Hope that helps.


    Gia Thinh Co. - Smartsheet Solution Partner.

Answers

  • Gia Thinh
    Gia Thinh ✭✭✭✭✭✭
    edited 03/14/22 Answer ✓

    Hi @Sandhiya07,

    Try this way.

    You add a helper column "New row" and create 3 workflows.

    1st change cell value workflow will change "New row" to "checked" when new rows are added

    2nd change cell value workflow will run everyday on 11AM to unckeck all rows that have "checked" value

    3rd change cell value workflow will run everyday on 3PM to unckeck all rows that have "checked" value

    So before 11AM and 3PM, you can count all rows that have "checked" value

    Hope that helps.


    Gia Thinh Co. - Smartsheet Solution Partner.

  • Hi @Gia Thinh

    Thanks for your reply. It's working.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!