Formulas
Discussion List
- Hi Smartsheet Community, I'm having trouble with a COUNTIFS formula and hoping you can help. I'm trying to count all rows that are assigned to a specific person. Because it's possible to have multiple…
- The following is our brochure requests sheet. Right now we manually update our inventory each time we receive a request. Here is a snapshot of the new inventory sheet. I'd like to create a formula tha…
- I'm not even sure if this is possible but I invite all the formula wizards to take a crack at it! I have this intake sheet with 10 rows, all that have a corresponding auto-generated Row ID from the sy…
- I'm trying to write a formula to return a value based on multiple criteria. I've gotten other similar to work, but this one is not returning the correct value for some reason (or not clearing the valu…
- Hi all, I am trying to create a conditional formatting to mark a row Red if the ID# has been used before. I have plenty of conditional formatting experience however I just can't seem to figure this pa…
- Hello Everyone! I would like to create a formula that says If the value in the "Variable" column is "HIGH" AND the date in "Column 1" has a year less than today's year, return that date with TODAY"S y…
- Hello- I am trying to write a formula that includes sheet references, and two conditions. I need to count the number of students in each category and how many of those students chose a specific availa…
- This is a simple one but just having a hard time getting it to work. I have multiple clients who purchase a variety of products per invoice. I need a Sum of the Product Type per Client. I've attached …
- Hello, Hoping somebody can make my life easier please. I'm currently using the following countifs formula: =COUNTIFS({CoCode}, "114", {Status.}, "Not Started") What can I change it to so I don't have …
- How is the data supposed to be formatted when a formula has quotes within it such as =IF(X=1,"One,"") ? I am getting just slashes in place of the quotes when I export a formula using the API, but when…
