Creating a IF(AND(ISDATE formula to check a box
Hi All,
I am trying to write a IF(AND(ISDATE formula to check a box I have read through several post but dont see and example of doing all three of these functions nested together. I get either unparsable or Invalid argument on my attempts.
Goal: in my data set I dont care what the date is just that it is a date (anydate) I am using a Vlookup in COLUMN2 to pull in the dates, and the rows with out matching Vlookup partners come back with #NO MATCH so I am trying to get those rows with part 2 of the formula. If COLUMN1 AND 2 dont meet the criteria then dont check the box.
If COLUMN1 = Foreign and COLUMN2 = a date then check the box
If COLUMN1 = Foreign and COLUMN2 = not a date then dont check the box
Others wise dont check the box.
Thanks
Lisa
Best Answer
-
Try something like this...
=IF(AND([Column1]@row = "Foreign", ISDATE([Column2]@row)), 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
Hi Lisa,
Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic weekend & Happy New Year!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Try something like this...
=IF(AND([Column1]@row = "Foreign", ISDATE([Column2]@row)), 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Hi again, I need to do something similar but my formula isn't working. I have one sheet with employees name (database) and another sheet (survey responses) where I need a column to be checked IF both names match and there is a date in the termination date column on the database. What am I doing wrong?
=IF(AND({EMPLOYEE NAME} = [FIRST & LAST NAME]@row, ISDATE({TERMINATION DATE})), 1)
-
@NikkiOno Are you able to provide screenshots for reference?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
-
@NikkiOno You would do something more like this:
=IF(COUNTIFS({Employee Name}, @cell = [Employee Name]@row, {Termination Date}, @cell <> "")> 0, 1)
This counts how many rows have the employee's name and a termination date then says if that count is greater than zero, check the box.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
@Paul Newcome That worked! Thanks so much.
-
@NikkiOno Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!