IF/Then

RicoCastro

RicoCastro ✭

01/17/24 in Smartsheet Basics

I need help with the following:

If Column 1 has text, then column 2 says ABC.

Thank you.

0 ·

Answers

Nic Larsen ✭✭✭✭✭✭

01/17/24

This would be in Column 2:
=IF(ISTEXT([Column 1]@row), "ABC", "")

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Report does not display sheet dates or dropdown menu items
Hi there, I used the "Project Management Office" template to set up different projects and then a report that pulls the information from all the projects into a central report document. I have noted that if you have drop-down options in your original sheets, or dates, these are not displaying in the report. How do I…
Is there a way to merge user groups?
Two teams at my company have recently merged into one, and I was wondering if there's an easy way to merge their Smartsheet user groups into one group. I don't see a "merge" option available in the Group Management portal.
Attendance reports
I am trying to create a sheet for attendance reports. We take daily attendance of our students, but it is done on a form which is part of a bigger report. I would like to provide the front office with a monthly report of just the students that were absent and which days. How would I do this? Hyperlink? Condition? Please…

Help shape the future of Smartsheet.
Share your ideas and feature requests.