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 Community Champion

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

Report Editing
How do I change the font size, color, etc.. on a report to make it look nice?
Standard Size Dashboard from Expanded Dashboard
I have a Dashboard that is in Expanded Size, but am making a similar Dashboard that I need in Standard Size. Without having to recreate all of the widgets and start from scratch, is there a way to convert an Expanded Dashboard back to Standard Size?
Why would line breaks NOT present in the Report View be present in the Dashboard Widget view?
I have a field I am pulling from Salesforce into Smartsheet that has often has a lot of line breaks in it. I used a CHAR formula to remove the line breaks, and it shows correctly without the line breaks in both the Sheet and the Report. However, as soon as I pull the report into a Dashboard widget, line breaks appear…but…

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