Sign in to join the conversation:
I have charts to show progress by week to date, month to date, and year to date. I reference another sheet to indicate the date range for each chart. Is there a way to automate my reference sheet so I don't have to change the dates manually?
if you want to show the current period I recommend using a helper column then using that as criteria in your formulas
if(weeknumber([date ref]@row) = weeknumber(today()),1,if(month([date ref]@row)= month(today()),2,if(year([date ref]@row) = year(today()),3)))
then in your criteria you can use something like
current year
[Helper C]1 >0
Current month
[Helper C]1 < 3
Current Week
[Helper C]1 = 1
This is also nice for filtering data. I often use a next period helper column to quickly navigate my larger sheets.
Thanks!
In a sheet, in the primary column (Task Name), I have multiple parent rows with all of the same child rows beneath each parent row. A simplified example is each Parent Row is a new lot number, with two associated child rows called "Date of Shipment" and Date COA". There is also a drop down Status column. I want to create…
I've rebuilt my form at least five times and for the life of me cannot figure out why it will not trigger. I've tried to test and run it several times to no avail. Any tips would be very helpful. I was able to successfully trigger once, now nothing at all for a week.
I have an automation that will send a request for an update to a supplier about a complaint. There are fields that the supplier needs to see to understand the issues. But, I would like to be able to lock those down so that the supplier cannot change the information in those fields. Is this possible? Freda
