How to uncheck a box

Catherine Shea

Catherine Shea ✭✭✭

11/16/20 in Formulas and Functions

Screenshot 2020-11-16 165234.png

0 ·

Best Answers

L_123 ✭✭✭✭✭✭

11/16/20 Answer ✓

left click on the checkmark.

5 · Share on Facebook Share on Twitter
Catherine Shea ✭✭✭

11/16/20 Answer ✓

thanks MY BAD. I was not aware I entered this as a discussion. Thanks for the quick turn around!😊

0 · Share on Facebook Share on Twitter

Answers

L_123 ✭✭✭✭✭✭

11/16/20 Answer ✓

left click on the checkmark.

5 · Share on Facebook Share on Twitter
Catherine Shea ✭✭✭

11/16/20 Answer ✓

thanks MY BAD. I was not aware I entered this as a discussion. Thanks for the quick turn around!😊

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

Can anyone tell me what's wrong with my formula?
I'm trying to set up a project plan that has color indicators for the timeline: RED=past due, Yellow=due in the next 5 days, Green=due in the next 14 days, Blue=due later. =IF([Due Date]2 < TODAY(), "Red", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 < TODAY(+5))), "Yellow", IF(AND([Due Date]2 >= TODAY(), [Due Date]2 <…
Help with a #UNPARSEABLE error
I want to reference the values in a column from another sheet (2025 IOE Procedure Assessments Equipment). And if any of them match any cell from the Equipment column from the sheet I'm working in then, I want the Audit on Equipment Completed column to return a "Completed" value. This is my formula. What is wrong with it?…
I have the Year and Month on a sheet. How can I have the summary look at both to count?
I would like to create a summary if the month is Sept AND the year is 2024 to count. I have found that I can use the and but keep getting an error message This is the Formula I have in the Summary that is coming up #Unparseable =COUNTIFS([Next Renewal Year]:[Next Renewal Year], "2024") AND(([Next Renewal Month]], "Sept")