-
Help with complicated Index If statement, want to flag a helper row
Hey friends, I'm finally figuring out a complex system to have a first sheet with a Dropdown data row, matched to a column with a helper row that only highlights the MAX (most recent) dropdown. I'm doing this so I can ask a dynamic dashboard to retrieve all data on Faculty across multiple sheets. It works great! Only…
-
"Substitute" Column Formula Inconsistency
Hello, I am using the column formula below to extract the time from the "Created Date" column. =SUBSTITUTE([Date Submitted]@row, DATEONLY([Date Submitted]@row), "") However, you can see in the screen shot below that it doesn't always work. Is this a bug?
-
Formula not working
Hi all, I can't understand why this simple calculation isn't working, or if it's my brain! I am trying to calculate in the highlighted cell, 29 * 73,000 Euro each time it returns zero. The 29 is a formula based on other figures on the same smartsheet, whilst the 73k is a SUMIFS based on a different smartsheet. What am i…
-
SUMIFS with multiple criteria per quarter
Hi! I need some help getting a formula to work for a sheet summary and have confused myself at this point. I need to get a sum of the reach our national events collected within Q1. Columns: National_local - want to only find those designated "national" Start_date - only need between 1/1/2025 - 3/31/2025 Reach - need the…
-
Dependency columns: Automations or Formulas in Start / Finish & Duration Columns
With so many posts about this why has this feature not been added or fixed? The fact that this is not a feature in Smartsheet makes it extremely difficult and inefficient to accurately determine schedules. We are utilizing Smartsheet to build out our schedule the production and forecast the completion of our products. All…
-
VLOOKUP Help - Incorrect Argument Set error
I am stuck with an "Incorrect Argument Set" error when I try to use VLOOKUP. On Sheet 1, I have a column called "User Name." I am adding a helper column tacked onto the right side of a large timesheet report pasted in from a .csv file. I'd like to use VLOOKUP to retrieve the user's name as it appears in my payroll reports.…
-
COUTIFS Formula help needed
Hi, I am trying to write a formula that will pick the right data to automatically fill the Actuals - Monthly cell (Row 11 in the description column). I have tried an INDEX MATCH formula (=INDEX([M1 2025/26 (£000's)]2:[M12 2026/27 (£000's)]2, MATCH(CurrentMonth2, [M1 2025/26 (£000's)]1:[M12 2026/27 (£000's)]1, 0)) and kept…
-
I need a modification on an IF THEN statmenet
I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and all children of that row will show "Task 2". I did that using this formula: =IF(Level@row = 2, LEFT([Task #]@row, 7),…
-
Due Date by Quarter
I need a formula that populates the due date based on the date that its approved. I want the date to be at the end of each quarter
-
Monthly Average-Quarterly Average-Yearly Average
Hello, I am new to Smarsheet and I am trying to figure out the formula that will get me a Monthly Average, Quaterly Average and Yearly Average of Markups that I have for each person on our Team. If someone could help me, I will really appreciate it. See screenshots examples below: Thank you!