Want to compare values in 3 columns to return a value in 4th column

Trying to sum up all many active projects are over due. Can add up my active projects with formula: =if(and(type@row="project",status@row="in progress),1,0) but now I want to add the criteria of target completion date is late. Tried the following but get the dreaded "unparseable" message...

=if((and("target completion date",(Today())),(type@row="project",status@row="in progress"),1,0)

Find more posts tagged with

Accepted answers

Carson Penticuff

I am not sure I am interpreting your request correctly. Is this what you are trying to accomplish?

=IF(AND(type@row="project", status@row="in progress", [target completion date]@row < TODAY()), 1, 0)

All comments

Carson Penticuff

I am not sure I am interpreting your request correctly. Is this what you are trying to accomplish?

=IF(AND(type@row="project", status@row="in progress", [target completion date]@row < TODAY()), 1, 0)

BJTidi

Yes, thanks. I don't use formulas in smartsheet much (at all!) and was getting lost with adding a third "look up". Tried that and it gives me the desired result, appreciate the help!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.