Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

simple Excel fumula does not work

Reto Fröhlich

Reto Fröhlich ✭

09/29/15 edited 12/09/19 in Archived 2015 Posts

hi

Has andbody an idea to trasform this simple excel formula into smart sheet?

=IF(A1=0;"Red";IF(A1=100;"Green";"Yellow"))

thanks for your help

0 ·

Comments

Travis Employee

10/05/15 edited 10/05/15

Try this:

=IF(A1 = 0, "Red", IF(A1 = 100, "Green", "Yellow"))

Just make sure you change A1 for the correct cell reference.

Here is information from our Help Center on formulas in Smartsheet: http://help.smartsheet.com/customer/portal/articles/775363-using-formulas

One more note: If you are referencing a % Complete cell, change 100 to 1. (1 = 100%. 100 = 10000%)

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

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
Multiple Criteria Formula - Metric Sheet
I am looking for a formula to calculate the number of APPROVED projects with Technology Impact. I am able to get the number of all projects with technology impact, but cannot figure out the second part of the formula to only include APPROVED projects. Current formula which includes information from the Technology Impacted…
Data reference from one sheet to another Formula not working
Hello community, I was trying to reference some data from one sheet to another via formula but it doesn't seem to work error in cell: " #unparseable" , here a breakdown of my goal and the formula I am trying to use: have 2 separate sheets, in the main one named request for information where people will submit their request…