IF AND Formula to auto populate a checkbox
Hello,
I am creating a report that references another sheet. I would like to know if a person from a certain organization attended a training. The formula looks at 2 different columns from the other sheet. One of the columns has the name of the organization, the other column indicates if they were in attendance. In my report I want to look at those 2 columns and if they were in attendance, I want my checkbox column to auto populate. This is the formula I created but get the "Unparseable" error message:
=IF(AND({IFRP Partners Attendance Range 2}, "Centro Romero", {IFRP Partners Attendance Range 1}, "In Attendance", "1, "0"))
Any assistance is appreciated.
Answers
-
Hi Marilu,
=IF(AND([IFRP Partners Attendance Range 2] = "Centro Romero", [IFRP Partners Attendance Range 1] = "In Attendance"), 1, 0)
- The
AND
function checks if two conditions are met: if the organization name in column[IFRP Partners Attendance Range 2]
equals "Centro Romero" and if the attendance status in column[IFRP Partners Attendance Range 1]
equals "In Attendance". - If both conditions are true, the formula returns a value of 1 which will check the checkbox. If one or both conditions are false, the formula returns a value of 0 which will leave the checkbox unchecked.
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
- The
-
@J Tech I updated the formula and now I am getting a "#Invalid Data Type" error message. I should note that the 2 columns where I am trying to pull information from are Text values.
-
Sorry it should be:
=IF(AND([IFRP Partners Attendance Range 2] = "Centro Romero", [IFRP Partners Attendance Range 1] = "In Attendance"), true, false)
Regards
J Tech
If my response has helped you in any way or provided a solution to your problem, please consider supporting the community by marking it as Insightful, Vote Up, or Awesome. Additionally, you can mark it as the accepted answer, which will make it easier for others to find a solution or get help with a similar issue in the future. Your support is greatly appreciated!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!