-
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…
-
Merged: Update functions list to include regular expressions
This discussion has been merged.
-
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!
-
Sheet Summary Formula to Rollup Parent Statuses
Hi, I have a working formula in my sheet that works beautifully to rollup/count the status within the sheet: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(), "Not Started") = COUNT(CHILDREN()), "Not Started", IF(COUNTIF(CHILDREN(), "In Progress") > 0, "In Progress",…
-
Best Practice for Multiple Sheets with Column Formulas
On my Smartsheet I have multiple sheets. Requests come in on the Request sheet, then move to an Approved, Hold, or Rejected sheet. I'm wondering if some of the column formula's I have should be removed from the all but the Request sheet. Those formula's are meant to provide guidance on what action should occur with a…
-
how to change Parent status based on Child row checkbox?
= "Not Started" if NO boxes checked = "In Progress" if SOME boxes are checked = "Complete" if ALL boxes are checked for the attached example I manually changed status based on checked boxes, but I'm hoping to find a way to do it automatically with a formula. I've only had success with formulas changing status within the…
-
Cross Sheet Formula
Trying to do an if and statement. If the PO# matches on sheet one with PO# on sheet 2 and the Count of POs (a count helper column restars at 1 with each new PO) equals 1 then post the Inv amount. =IF(AND({FY25 Payables Tracker PO#} = [PO #]@row, {FY25 Payables Tracker Count POs} = 1),{FY25 Payables Tracker Invoice Totals…