In need of formula to check box using based on data from 2 columns

imtonydillard

imtonydillard ✭✭

12/05/21 in Formulas and Functions

My best try was: =IF(AND([To Be Filed]@row > 0, 1, [Days Since Close]@row < 60, 1))

Got any ideas?

check box formula.png

Tags:

Formulas

0 ·

Best Answer

Neil Watson Community Champion

12/05/21 Answer ✓

=IF(AND([To Be Filed]@row > 0, [Days Since Close]@row < 60), 1, 0)

1 · Share on Facebook Share on Twitter

Answers

Neil Watson Community Champion

12/05/21 Answer ✓

=IF(AND([To Be Filed]@row > 0, [Days Since Close]@row < 60), 1, 0)

1 · Share on Facebook Share on Twitter
imtonydillard ✭✭

12/05/21

Mega thanks Neil Watson. It worked. U DA MAN!

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 have been trying to figure out a formula to count days from a date column, Any help?
Example: Column A—————-Column B Date sent out———#of days out 06/20/25———————3 05/31/25———————23 05/23/25——————-30
Using COUNTIFS with CONTAINS as a Criterion
I have a multi select list column in Sheet 1, containing campuses. In sheet two I am trying to get a count of how many times each campus is listed in the campus column in sheet 1. Here is my current formula: =COUNTIFS({Event Campus}, CONTAINS("Cypress", {Event Campus})) The results are always "0" for each campus. Given…
Trying to change a cell value when a date is reached
I'm trying to change an invoice status to "Overdue" when the date is > 20 days later than the date in the Invoice Date column. I can't seem to find the automation conditions!