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

how to get automated workflow to trigger when a new row is added from a form?
I've created the automation below and would like it to run whenever a new row is added from a form. I've tested it out and when i create a new row the automation doesn't trigger- where am I going wrong?
Restore previous version
Hi all - a poorly structured data shuttle update has deleted all my sheet data. I'm on hold to support but does anyone know how to restore a previous version of a sheet?
Creating daily work schedule for individual team members (from a master project grid).
Hello, I'm building a system in Smartsheet to manage work requests across all projects in my organization. The basic idea is for Project Managers to submit task orders to a common grid, which are then assigned to various team members. Ultimately, this new system will serve as the primary work scheduling tool. The system is…

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