Is there a formula for this?

Options

Crystal A

Crystal A ✭

07/29/22 edited 07/29/22 in Formulas and Functions

So I am needing to have a column decrease - (QTY) - for every "crtl+enter" line - (NOTES) - of the following cell. Is this something that is possible, or do I need to change my notes column?

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

08/01/22
Options
Are you able to provide a screenshot for reference?

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

I am trying to get the percentile of responses that return "1-2" if the responded "4 Months" in
I am trying to get the percentile of responses that return "1-2" in a column if the response is "4 Months" in another column. =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, "4 Months", 0.5)) or =PERCENTILE(COLLECT({Preceptors}, {Preceptors}, ="1-2", {Survey Time}, {Survey Time}, "4 Months", 0.5))…
COUNTIF where counting if cell contains "Super" but "Superstar"
I have a formula where I'm counting how many products are at a certain status and where they have a title of Super, Super & more or Super & Design (B&W) - but want to make it scalable. Is there a way to create a formula where I can tell it to count any cell where "Super" is the prefix? And secondarily, not count anything…
COUNTIFS with multiple OR dates
Im trying to use a formula that counts the number of projects where it fulfills certain criteria that then checks whether the startdate was after a beginning date range or the end date was before the end date range. (basically that work was performed within the date range). This is what I have: =COUNTIFS({Marcom Portfolio…