-
Child Auto Numbering per Parent Row
Help! In a Time Crunch! I was wondering if anyone could help me. I am so thankful for Brian Richardson original post from 07/2024 showing the breakdown, I think it is the answer that I have been looking for. But I can't get the formula to work. Can you help me? Columns: Parent Formula I have: Child Number Formula I have: I…
-
Question about Workday Formula
Hi there - I'm looking for some assistance with a WORKDAY Formula. I am trying to: Look at a date in a cell - let's call that "Program Date" and add 12 days to that date Then reference another sheet that has a column of dates and pull back the earliest date (that's later than Program Date plus 12 days) Exclude holidays I…
-
Formula to Calculate Building Age from Opening Date
Hello All, I'm trying to create a formula that will automatically calculate the age of a building based off the Opening Date. I have two columns "Opening Date" and "Building Age". In the Building Age column I've tried a few formulas but keep receiving various errors. =TODAY-([Opening Date}@row) One thing to point out is…
-
COUNTIF Formula not returning correct values...
I am using a helper sheet to create a dashboard and want to find how many of each value is in a certain column in the source sheet, and it is returning the incorrect values. There are values such as Col A, Col B, Systems, etc. In this example I show I am using =COUNTIF({BT Migration Master Sheet Range 2}, "Col B") and it…
-
Sheet Summary formula COUNTIFS with two criteria in one column
I am trying to make a sheet summary formula to generate the total number of cells that are either blank or have Submitted within them. So far I have tried multiple different formulas and this is the one I am currently testing however it comes back as #UNPARSEABLE =COUNTIFS([Site Supervisor Approval]:[Site Supervisor…
-
max(startdate) function in Countifs.
Hi all, I am looking if someone cane help me in writing an expression, I am creating a calculation sheet in my smart sheet, I have a multiple teams (5 separate sheets) sheets with Project name, description, effort points, Status(dev, test, uat, done) weekstartdate and weekenddate In my calculation sheet, I have columns…
-
What is the function of number one at the end of this formula?
=INDEX(COLLECT({Column to return}, {Column 1 with value to match}, "Value 1", {Column 2 with value to match}, "Value 2"), 1) Thank you!
-
Formula question - isblank, sums?
Trying to figure out how to make this work. I'm terrible with advanced formulas like what I'm trying to accomplish, and have no idea how to make it work. The extension rate needs to be multiplied by 12, then divided by 13 to give the cost per period (13 periods of four weeks, versus 12 months). Then I would apply/drag this…
-
Is It Possible To Have Automations Triggered By People Visiting The Sheet?
We are building a smart sheet system that includes one base sheet along with several reports that break up columns, depending on which stakeholder is viewing the report. The goal is for no one to actually edit or review the main underlying sheet, but to only view and edit the corresponding reports. Is it possible for me to…
-
Can I index/match multiple criteria in one cell?
I have a column that is a multi select dropdown of project codes. The codes are matched with a description on another sheet. Some rows have multiple project codes in the cell that has the multi select dropdown. Is there a way to have the description come in for each selection, not just the first? My suggestion to the team…
