Sign in to join the conversation:
I'm making a project schedule for our construction company.
I would like to be able to have a filter that only shows "Start Date" that is equal to this week or this month.
Is that possible?
We are only human!
Hi @Andrée Starå
Looking at this topic as it would help me a lot.
I tried to paste the formula in my 'Check box' column:
=IF(WEEKNUMBER(Start@row) = WEEKNUMBER(TODAY()), 1)
Unfortunately I get the error 'UNPARSEABLE'. I live in SG, so I tried the other formula as well, but both gave the same error. Are you able to assist? Thanks!
Hi @Rob L
I'd be happy to take a quick look.
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
So sorry to resurrect an old post @Andrée Starå. Have you ever figured out how to do this from the report side? I have a feeling it's not possible without a helper column in the target sheet but alas I don't own the target sheet in my situation and cannot add a column to it. I need a way to run a report that pulls only rows from the target sheet that have dates the same week as "today". Figured you'd be a good person to ask! :)
I doubt this is the best place for this question, but it is related. I have a Status column with dropdown options that include Complete. I also have start/end dates, but IRL stuff may fall out of those or ahead of those, so they aren't really useful for what I need, which is a filter for "What's been done in the last week; the last two weeks."
So I need a filter that looks at when the Status column changed to Complete. Is this possible—as a saved, sharable filter?
Thanks!!!!!
Hi @Suzanne Raphael
You can use a Record a Date workflow to automatically record when your Status changes (in a new Date column). Then you can use that Date column for your filter!
See: Set the current date with the Record a Date action
Cheers,
Genevieve
Thanks a bunch, that is exactly what I needed.
Suzanne
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
