-
Display Most Recent Created Date AND Time
I created a simple check-in form whereby the system Created Date field is to be the entry time. It will be a running sheet where all punches are stored so, for reporting purposes, need to pull out only their most recent date/time for display - the 'time' piece being my challenge. (Also have "Check-in / Arrival" criteria…
-
Cross Reference Sheet with Drop Down so I can use Conditional formatting
HI there, So I have a reference sheet, listing down all Australian Public Holidays by State (multiple drow-down). What I would like to do is to identify these holidays in my Destination sheet, and display if the holiday is either QLD, VIC or NSW or all three. I am currently using a helper column to identify if the dates…
-
COUNTIFS Formula with CONTAINS in a specific date range only.
Hi everyone. I have a sheet with multiple columns. One column indicates the status of a survey and another column indicates the date the survey was distributed. I want to have a formula that will count the number of rows that contains "Survey Closed" in the status column but only for rows that have a specific date (1/1/24…
-
Formula with multiple answers
Hello, Is there a formula for a row that can have multiple answers? I have one column A with names, and depending on that name in column A, I want a different number to appear in column B For example If column A=Mary, return 245 or column A=James, return 548…..etc. I have 5 names with 5 different values associated with…
-
What formula can I use in the Main Sheet to bring in a Status based on the Reference sheet?
Good morning all, I have tried Index, Index-match, IF, IF Error formula's and I can't seem to get this cross reference to work but none do. Here is the breakdown: In the main sheet I want a column to auto populate 3 statuses: Not Started: when the reference sheet task columns have not been checked off In Progress: when the…
-
Formula works in one sheet but not others (cross-refs are updated)
Hi there, I have a formula in one sheet, which looks at the task and calculates the dates for each task, excluding holidays and weekends. =IFERROR(WORKDAY([Task Start Date]@row, VLOOKUP([Product Version]@row + Task@row, {ConcatProdTaskLookupDerek}, 2, false), {TechTarget Holidays Range 2}), "") I then use this same formula…
-
sumif date range, category, and total amount
Hi! I need to total up a dollar amount spent with a date range (monthly), and that matches a category name. Can anyone help with a starting point formula for me to work with? =SUMIF({Smartsheet Range 1}, "Digital Advertising", {Smartsheet Range 2}, {Smartsheet Range 3}, >=DATE(2024, 7, 31), {Smartsheet Range 3},…
-
Trying to index match a formula for multiple sheets
What's wrong with this formula? =IFERROR(INDEX({Master Pipeline Name}, MATCH([Store #]@row, {Master Pipeline Store #}, 0), INDEX({Pipeline- OPEN Stores Name}, MATCH([Store #]@row, {Pipeline- OPEN Stores #}, 0) "")
-
If Function
I need a formula to assign people to a cell based on a person assigned in another cell. For instance: If the cell is assigned to Russ, Tyler or Kirk it needs to say Lauren. If the cell is assigned to Mason, Bryan or Will then it needs to say Cynthia. Column name is "Assigned To" and the first name goes in line 2
-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
