If than statement

Options

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
Options
=if([column 1]2 = "word", [column 2]2 * [column3]2

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

New Sheet Not Showing up in Existing Report
I have a folder and inside the folder I have 25 sheets and a report that produced a listing of all the sheets in that folder, somehow when I add a new sheet in that folder, the new sheet doesn't listed on the report. Please help. thank you.
Formula help if statement but want to include if blank
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)
Details Panel logic setup in Dynamic view not working
Hi, I am trying to add logic in details panel, to make few fields as read only, when Reviewed? column is "Reviewed". I'm not able to save this logic after I created. Am I doing anything wrong? Please help me 😐. Thank you!

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