In need of formula to check box using based on data from 2 columns
My best try was: =IF(AND([To Be Filed]@row > 0, 1, [Days Since Close]@row < 60, 1))
Got any ideas?
Best Answer
-
Neil Watson ✭✭✭✭✭✭
=IF(AND([To Be Filed]@row > 0, [Days Since Close]@row < 60), 1, 0)
Answers
-
Neil Watson ✭✭✭✭✭✭
=IF(AND([To Be Filed]@row > 0, [Days Since Close]@row < 60), 1, 0)
-
Mega thanks Neil Watson. It worked. U DA MAN!
Help Article Resources
Categories
Check out theFormula Handbook template!
{Cross Sheet Reference}<\/p>
<\/p>
with<\/p>
[Column name]:[Column Name]<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":112222,"type":"question","name":"Count Days and Durations","excerpt":"I am looking to count days used in my schedule per task. I am set up with start and finish date columns along with a duration column. I am trying to calculate days on site from start date to today, but to stop counting days when finish date is reached.","snippet":"I am looking to count days used in my schedule per task. I am set up with start and finish date columns along with a duration column. I am trying to calculate days on site from…","categoryID":322,"dateInserted":"2023-10-26T17:03:59+00:00","dateUpdated":null,"dateLastComment":"2023-10-27T15:15:39+00:00","insertUserID":164388,"insertUser":{"userID":164388,"name":"Caleb W","title":"Operations Leader","url":"https:\/\/community.smartsheet.com\/profile\/Caleb%20W","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AFdZucpGLwolOKyzvAL1Qwa-C_qqnmxB9j9mfmL4qM8Hnw=s96-c","dateLastActive":"2023-10-27T17:19:12+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":113581,"lastUser":{"userID":113581,"name":"Matthew J McAteer","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20J%20McAteer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zDFUs7dXyHo!7bFXOzNnVPw!fm5dCHPC2D9","dateLastActive":"2023-10-27T16:03:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":39,"score":null,"hot":3396762578,"url":"https:\/\/community.smartsheet.com\/discussion\/112222\/count-days-and-durations","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/112222\/count-days-and-durations","format":"Rich","lastPost":{"discussionID":112222,"commentID":402031,"name":"Re: Count Days and Durations","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/402031#Comment_402031","dateInserted":"2023-10-27T15:15:39+00:00","insertUserID":113581,"insertUser":{"userID":113581,"name":"Matthew J McAteer","url":"https:\/\/community.smartsheet.com\/profile\/Matthew%20J%20McAteer","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zDFUs7dXyHo!7bFXOzNnVPw!fm5dCHPC2D9","dateLastActive":"2023-10-27T16:03:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/JDZDOA0P3L7I\/image.png","urlSrcSet":{"10":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=10\/https:\/\/us.v-cdn.net\/6031209\/uploads\/JDZDOA0P3L7I\/image.png","300":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=300\/https:\/\/us.v-cdn.net\/6031209\/uploads\/JDZDOA0P3L7I\/image.png","800":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=800\/https:\/\/us.v-cdn.net\/6031209\/uploads\/JDZDOA0P3L7I\/image.png","1200":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1200\/https:\/\/us.v-cdn.net\/6031209\/uploads\/JDZDOA0P3L7I\/image.png","1600":"https:\/\/us.v-cdn.net\/cdn-cgi\/image\/fit=scale-down,width=1600\/https:\/\/us.v-cdn.net\/6031209\/uploads\/JDZDOA0P3L7I\/image.png"},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-10-27T17:19:33+00:00","dateAnswered":"2023-10-26T22:22:24+00:00","acceptedAnswers":[{"commentID":401941,"body":"
