What is wrong with this formula =IF([Tech Check in Time]@row), >0, ="Yes")

Weston Johnson

Weston Johnson ✭✭

10/10/23 in Smartsheet Basics

I need to have cell in one column deliver "yes" if the other cell has data.

0 ·

Best Answers

SPIPMO ✭✭✭✭

10/10/23 Answer ✓

Hi @Weston Johnson
Please try this
=IF([Tech Check in Time]@row > 0, "Yes")

Thanks!

0 · Share on Facebook Share on Twitter
Weston Johnson ✭✭

10/11/23 Answer ✓

Perfect thank you......

0 · Share on Facebook Share on Twitter

Answers

SPIPMO ✭✭✭✭

10/10/23 Answer ✓

Hi @Weston Johnson
Please try this
=IF([Tech Check in Time]@row > 0, "Yes")

Thanks!

0 · Share on Facebook Share on Twitter
Weston Johnson ✭✭

10/11/23 Answer ✓

Perfect thank you......

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

WORKSPACE PANEL - Automatically open when going to a new sheet / report / dashboard
This panel seems to automatically be open when navigating to a new sheet / report / dashboard in the directory. Is this a change? Is there a way to deactivate that being open automatically? thank you, Dave
Controlling Asset Permission Levels
I have a feeling the answer is NO, but wanted to confirm. We are considering upgrading our Enterprise plan, but need to consider the significant price increase if we upgrade, so we are looking to cost structure variations based on what our users are doing in Smartsheet. We want to control the assets being shared not only…
Is there a way to start a task as soon as possible with a FF dependency?
What I'm looking to do is create a finish-to-finish dependency where the end date is extended but not the duration for a given task. This way a task can start immediatly but it may finish later than the duration. This way the duration of the task can outgrow the FF dependency but never be less than the FF dependency end…

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