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
Hi all. I'm trying to do something that I'm not sure if it's possible or not. We have a sheet that we are importing where the first column lists areas within our factory. Each column after that has a column name of a date. So 12/15/2025, 12/16/2025, 12/17/2025, etc. In each of the date columns is a target production…
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
Hello, I have a checkbox column that I would like to be checked when comparing 2 columns. I would like it to be checked if the 2 columns are not equal or if one of the 2 columns has an error. It's important to note that both columns are numbers. My original formula was: =IF([COLUMN A]@row <> [COLUMN B]@row , 1, 0) However,…
