-
using OR function with long formula
I have a "ledger" sheet that I use to calculate real-time budgets based on any changes and shifts that come through a request system. Currently, it's built for F24, however as we move towards F25, I want to add in options to include F25 budget change requests/shifts. In order for my sheet to calculate correctly, I need to…
-
Return a value from a cell based on today's date
Hello everyone, I am creating a metric sheet to track the total hours, attendees, and person hours of meetings and would like to track it based on today's date. In the example above, I would like to use TODAY() in the top row under the "Date" column. Then if the date in the rows below are in the past, return the…
-
How to count reference stored daily to a sheet storing weekly.
I have a sheet that stores records daily (several per day) of installations categorized as either "Res" or "Com". I'm trying to count the "Res" category above based on week ending dates (Sat) below in "Meters Installs Actuals (RES)". So for Week Ending 01/14/24 the formula would count all Res from 01/08/24 to 01/14/24.…
-
Index/Match not working when the Match column in source doc is a 'RIGHT' formula
I have a column in my source sheet where Store # is a RIGHT formula. When I index match in my Target sheet I get 'NO MATCH' when trying to find Store #.
-
Avoiding Overbooking using Smartsheet Calendar/DataShuttle
Hello! I am trying to create a booking system for a room with multiple stations. Stations: 1 - 5. Time slots: Morning, Afternoon, All Day So far I have a dashboard with a calendar/form and separate sheet for the form submissions. With the calendar, people are able to see other bookings, but ideally, I want to use…
-
Formula for This week, Next week, etc.
Someone helped me with these, but I cant get them to work. Can someone let me know the error of my ways? This formula would be for last week =If(YEAR([Projected Start date]@row=YEAR(TODAY(-7)),IF(WEEKNUMBER[Projected Start date]@row=WEEKNUMBER(TODAY(-7)),1,""),"") This formula would be for this week =If(YEAR([Projected…
-
Index(Match()) Returning incorrect row
Hello! I'm hoping to get some help in finding an error in my index(match()) formula. I'm trying to pull a contact name for a customer from one sheet into another based on the customer name. The original sheet has customer name and contact email; the sheet I'm trying to fill in has customer name and I'd just want to fill it…
-
Two checkbox columns to drive checkbox in 3rd column.
I have a pair of checkbox columns, which you can check for different criteria. I have a third column, also a checkbox column. I am trying to have the 3rd column be checked based off one of the 2 preceding columns being checked. I tried a formula "=COUNTIFS([Registered (DL)]:[Registered (DL)], 1, [Registered…
-
Restricted Task Dates in Office Timeline Pro+?
I use Office Timeline Pro+ to create all my corporate project timeline slides by importing source Sheets or Reports. Is there a way to show project timelines restricted by a certain date? For example, I want to show all tasks that are in progress as of 1JAN2024, regardless of the actual start date (e.g., if the start date…
-
Counting user login between 30-89 days
The data set tracks each time a user logs in. I need metrics on users who have logged in between 30-89 days, but I only need to count the most recent instance. Also, I am using data shuttle to bring it in, so I'd like to filter out the duplicate emails keeping only the most recent instance.