---
title: "Ashish Srivastava (@ashishsrivxl) | Hashnode"
description: "Excel, Google Sheets & automation templates (AI-assisted). Read the latest articles by Ashish Srivastava on Hashnode."
url: "https://hashnode.com/@ashishsrivxl"
---

@ashishsrivxl

# Ashish Srivastava

@ashishsrivxl · Kolkata, India · Joined October 2026

Excel, Google Sheets & automation templates (AI-assisted)

### [How to Add an Order Status Dropdown That Colours Itself](https://ashishexcelnotes.hashnode.dev/order-status-dropdown-conditional-formatting?utm_source=hashnode&utm_medium=feed)

Subtitle: Data validation, conditional formatting, counts per status, a "stuck" flag, and a check that catches statuses typed by hand Written with AI assistance. A status column is the simplest way to

4 min read · [ashishexcelnotes.hashnode.dev](https://ashishexcelnotes.hashnode.dev/order-status-dropdown-conditional-formatting?utm_source=hashnode&utm_medium=feed)

[Oct 21](https://hashnode.com/posts/order-status-dropdown-conditional-formatting/6ad8de754b07a8fe952a4432)

### [How to Set Up Payment Due Date Reminders in a Spreadsheet](https://ashishexcelnotes.hashnode.dev/payment-due-date-reminders-workday-networkdays?utm_source=hashnode&utm_medium=feed)

Subtitle: Due dates that skip weekends and holidays, working days left, and a "Remind now" flag with WORKDAY and NETWORKDAYS Written with AI assistance. Chasing an invoice after it's late is awkward.

4 min read · [ashishexcelnotes.hashnode.dev](https://ashishexcelnotes.hashnode.dev/payment-due-date-reminders-workday-networkdays?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/payment-due-date-reminders-workday-networkdays/6ad8de32ecdd6c2a73c3c907) [Oct 21](https://hashnode.com/posts/payment-due-date-reminders-workday-networkdays/6ad8de32ecdd6c2a73c3c907)

### [Freelancer invoice tracker in Excel: track clients, projects and who still owes you](https://ashishexcelnotes.hashnode.dev/freelancer-invoice-tracker-in-excel-track-clients-projects-and-who-still-owes-you?utm_source=hashnode&utm_medium=feed)

Most freelancers start with invoices scattered across email, a notes app and a bank statement. That works until you have five clients and can't say who has paid. A simple freelancer invoice tracker in

5 min read · [ashishexcelnotes.hashnode.dev](https://ashishexcelnotes.hashnode.dev/freelancer-invoice-tracker-in-excel-track-clients-projects-and-who-still-owes-you?utm_source=hashnode&utm_medium=feed)

[Oct 21](https://hashnode.com/posts/freelancer-invoice-tracker-in-excel-track-clients-projects-and-who-still-owes-you/6ad87a8ae00ade65e9d1e7cb)

### [How to make a 30-day social media content calendar in Excel](https://ashishexcelnotes.hashnode.dev/how-to-make-a-30-day-social-media-content-calendar-in-excel?utm_source=hashnode&utm_medium=feed)

Most small shops don't stop posting because they lack ideas. They stop because each day starts from a blank page. A 30-day calendar in Excel fixes that: you plan themes once, and every day already has

4 min read · [ashishexcelnotes.hashnode.dev](https://ashishexcelnotes.hashnode.dev/how-to-make-a-30-day-social-media-content-calendar-in-excel?utm_source=hashnode&utm_medium=feed)

[Oct 20](https://hashnode.com/posts/how-to-make-a-30-day-social-media-content-calendar-in-excel/6ad7af1f6d8aedcfef1b3500)

### [How to track multiple income streams in one Excel dashboard](https://ashishexcelnotes.hashnode.dev/how-to-track-multiple-income-streams-in-one-excel-dashboard?utm_source=hashnode&utm_medium=feed)

Once you have more than one small income source (a digital product, some freelance work, affiliate links, a newsletter) it gets hard to answer simple questions. Which one actually earns? Is this month

4 min read · [ashishexcelnotes.hashnode.dev](https://ashishexcelnotes.hashnode.dev/how-to-track-multiple-income-streams-in-one-excel-dashboard?utm_source=hashnode&utm_medium=feed)

[Oct 20](https://hashnode.com/posts/how-to-track-multiple-income-streams-in-one-excel-dashboard/6ad7af0877a844e0f3d939a0)