Login

u/Significant-Army-502

r/CarTalkUK r/TaskRabbit r/PowerAutomate r/sharepoint r/sheets r/Tottenham
Filtering a table onto another sheet based on dropdown
▲ 2 r/sheets

Filtering a table onto another sheet based on dropdown

I have a table which is essentially an inventory, what I would like is another sheet that only shows me items in the table that have been listed for over 30 days. The key is the dropdown in column G as I would only want this to happen where that is set to "Listed". Then once something is sold and I change that dropdown I would like it to be deleted from the filtered table

I've created a test sheet which shows the table

https://docs.google.com/spreadsheets/d/1v_8cxNmUQqiSgYjKV_X1_06iO1WPVzmIX2kH4aCOImE/edit?usp=sharing

Basically a filter on the table but have it appearing in another sheet so I have on demand access to it

Hopefully makes sense!

u/Significant-Army-502 — 6 days ago
▲ 2 r/PowerAutomate

Filtering a SharePoint list if today is between two dates

Evening all

This is driving me mad - probably a combination of me overthinking it and not having much patience.

I have a SharePoint list that has info like:

Destination Travel From Travel to
Spain 20/08/26 29/08/26
Italy 28/08/26 30/08/26

What I would like to do is create a view which only shows me records that are in progress; so when todays date falls either on or between the travel From/To dates.

So today (25/08/26) it would just show the Spain record.

I can't seem to do this in SharePoint itself, so I figured I could use Power Automate to edit the records and then I'll filter it from that. I was thinking I could just add a new column called "in progress" and use Power Automate to run once a day and either set each record to either yes or no.

Is this possible?

I figured I could create a variable for todays date and use that in the filter, I'm just not sure how to get the filter part right.

reddit.com
u/Significant-Army-502 — 2 months ago
▲ 1 r/sharepoint

SP List: How to calculate whether todays date is between two columns

I have two date columns

From Date To Date
17/08 20/08
23/08 29/08

What I would like to do is to be able to filter the list to show me only rows where "today" is either on or between the two dates.

So using todays date, for example, it would only show me the first row.

I figured I could create a calculated column and then filter based from that, but I am hitting a brick wall on writing the formula.

In plain text it would just be:

If today is greater or equal to "from date" and less than or equal to "to date"

Any advice?

reddit.com
u/Significant-Army-502 — 2 months ago
▲ 2 r/TaskRabbit

Question about errands (USA)

I need to pay somebody to drive to a couple of stores, buy some items and ship them to me. Can I do this on TaskRabbit? I'm not sure how I would give the Tasker the money to purchase the items (as one of the shops does not have click and collect or online ordering). Then I would need to also pay them for the shipping.

reddit.com
u/Significant-Army-502 — 3 months ago
▲ 1 r/CarTalkUK

Where can I find this wire?

My new reverse cam is missing the circled wire (red one with the black end)

Any idea where I can order it?

Place I ordered it from is beyond useless

u/Significant-Army-502 — 4 months ago
▲ 3 r/Tottenham

Would like to go to the Leeds game with my auntie, we're not members so not sure if it'll be possible to get a ticket. I think I saw tickets for the Brighton game went into general sale but nothing showing for Leeds, would it be just a couple of days before if at all?

reddit.com
u/Significant-Army-502 — 6 months ago