Count distinct values within cell

harrywhitehouse01

harrywhitehouse01 ✭✭

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

a

Tags:

0 ·

Answers

Mike TV ✭✭✭✭✭✭

07/12/22

@harrywhitehouse01
Sorry, you completely lost me. I don't at all understand what you're trying to accomplish.

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

Average of Color Symbols (RYG) on same row
I need to be able to create an average (In the Overall Status field) of the 3 filed to the right. As you Can see, they are symbols with the standard stoplight (RYG) colors. I have done this (with the help of the community) for parent/child, but now these fields are on the same row.
I am getting #circularreference and I am not sure how to fix it.
I am trying to get this calculation to work =IF(TODAY() < [Start]@row, "not started", IF(AND(TODAY() >= [Start]@row, TODAY() <= [Finish Date]@row, [% Complete]@row < 100), "In progress - on track", IF(AND(TODAY() > [Finish Date]@row, [% Complete]@row < 100), "in progress - delayed", IF(AND(TODAY() > [Finish Date]@row, [%…
% in formula issue
Good morning, I have a column which named "% Complete". The next column, I wrote: =IF([% Complete]@row = 100, "Complete", "Not Complete") That works if the % complete column is 100. But it doesn't work if I turn the "% Complete" column into a percentage format. How do I tweak my formula to state that if it's "100%", it's…