nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

Basing a count formula off of the current date for the day

Dawn DeLuca

I am trying to create a formula where I can total up certain fields each day. Does anyone know of the formula that would allow the use of today's date in a countifs situation?

Comments

Tony Coleman

Hi Dawn I think I've got it, depends on your use case. I quickly mocked up a sheet to show me my orders, when they were entered and when the sale date is, with order 3 happening in the future. So my actual sales is calculated at the top

Dawn 2.PNG

Dawn DeLuca

Thank you so much!! This was a big help. I was able to do =sumif(date:date, Today(), Value:Value) so this way it totals everything for todays date.

Sign in to join the Community!

Quick Links

Find more posts tagged with

Formulas