If than statement

Teodora

Teodora ✭

08/30/19 edited 12/09/19 in Smartsheet Basics

I need help with determining the right formula - Scenario:

If the value in colum 1 row 2 is "word" , than multiply (column 2 row 2, column 3 row 2, etc)

Thank you in advance for your help!

0 ·

Comments

L_123 ✭✭✭✭✭✭

08/30/19 edited 08/30/19

=if([column 1]2 = "word", [column 2]2 * [column3]2

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

IF logic formula
Hello, need help. I created formular for two outputs - "OTD" or "Not". See attached snip for details: A) Test 2 and 3 with date = Correct outputs, but for b) Test 4 without date = Same fx, still output "OTD" doesn't make sense. What do I need to do? C) For Test 1 formular seems working. But I'd like to incorporate into one…
Chart Column and line
Hello I Need to combineted the chart if column and line like attached. Coul you please help me? Thanks again
how can i set up an automation that triggers when a form is submitted?

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