-
Automatically add dated rows to a sheet
We manually create metric summaries to report out monthly metrics to more easily chart monthly measure data. That summary sheet has a format like below and each row contains SUMIF formulas that aggregates data from other sheets: Month_Ending (Date) : Metric1: Metric2: Metric3: Metric4 Currently, this process requires that…
-
Cell linking and removing cell links
Hi I have a client that has created cell links on her sheet, however now she wants to remove the cell links but is unable to remove them in one big Column highlighted feature, she needs to go into every single cell and remore/delete the links. Am I missing something here, is there a way to remove cell links per column and…
-
Autonumbering including sub-items (indented/outdented)
Hi, I am fairly new to Smartsheet, and would like to autonumber as shown in the image; I have found this possible solution (https://community.smartsheet.com/discussion/4050/auto-numbering-sub-items), but I is this the ONLY option? It seems like a basic task to me.
-
IF Formula calculation Error
Hi I have the following formula, which works up to a certain point. Let me explain. =IF(ISBLANK([Original Total Cost]@row), "No", IF([Actual Total Cost]@row > [Original Total Cost]@row, "Yes", "No")) When the Original Total Cost value is >the Actual Total Cost, the answer is "Yes" - perfect, that's what I need. When the…
-
Formula for date when a box is checked
I am trying to write a formula that will enter the date when a checkbox is checked. I have an automation set up but it needs to be updated every month so I thought I could write a simple formula to enter the date (approval date) when the box is checked by the approver
-
I am trying to sum a set of columns if one condition does not exist.
I have tried a couple of formulas with no luck. If the first three criteria have "Fail" then the overall score should be Fail; however if not then I want to add the scores of the other columns together. Here's what I've tried so far. and I get #INCORRECT ARGUMENT for the if statement and #UNPASEABLE for the sum statement.…
-
Counting specific values in multi select cells
Hi All, I am trying to count how many offices have certain engagements (choices are Calls, Email, Weekly PF call, FB gorup, Other, Texts). These cells are linked cells from another sheet. I tried these formulas: =countif([Office Engagement:Office Engagement], contains("Calls", Office Engagement@row)) =countif([Office…
-
Calculate Time to Schedule Weekly Averages
I want to calculate weekly averages for scheduled appointments. I want to show that weekly averages are taking longer to schedule over time. This is the formula I have so far: =AVERAGEIF({Average Time to Schedule}, COLLECT({OBOT Referrals Month}, @cell = 11, {OBOT Referrals Year}, @cell = 2022, {OBOT Referrals Day},…
-
Help with merging 2 "IF" segments.
I'd like to merge these into one formula for Schedule Health, so I can convert into a column formula. =IF(Level@row < 2, IF(COUNTIF(CHILDREN(), "Blue") = COUNT(CHILDREN()), "Blue", IF(COUNTIF(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", "Yellow")))) or =IF(Level@row >= 2,…
-
Countifs and Contains Formula Help
Hello Smartsheet Community, There are several departments that each have a number of different users. Each user has a combination of software preferences: Word, Powerpoint, Miro, Smartsheet etc. How can I create a formula that tells me how many users in the Math department selected an options that contains powerpoint? The…