-
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…
-
Update functions list to include regular expressions
GSheets and Excel have these formulae as standard. It would be useful to have the ability to use RegEx to parse through strings.
-
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…
-
Auto filling quote number column using automations?
I want my quote number to auto populate a quote number only when a new job row (parent row) is added. We use the quote number NV25-0xxx (ex: NV25-0258, NV25-0259). Multiple clients requesting the same job go in children rows, the children rows get the same number as the parent row so I do not need new quote numbers(I added…