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

Can a metric widget be a hyperlink on a dashboard?
I have a dashboard where I am trying to include a metric widget that captures a hyperlink from a cell on a metadata sheet. The hyperlink is to a SharePoint document. The link does not carry over to the dashboard widget. Only the URL description. Is there something I am missing or forgetting to do?… or is this not possible…
Restrict view
I am using Smartsheet to create a ticketing system for our HR department. As inquires come in I will assign tickets to the appropriate person. I want each staff member to be able to view the tickets assigned to them without seeing tickets assigned to other people. The director and I need to be able to see the details of…
Dashboards
How can I get my names to appear without a company name and without a space between? I can delete the company name that appears below the name (ex: John and Jane) but then I have big space in between names. This is how my metric sheet looks:

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