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

Dashboard Assistance
Currently, I have a dashboard that reports on our Current and Completed jobs (two unique sheets). There's two fields I'm looking to add together and return the sum onto the dashboard to display our dynamic Currently Billed to Date number. Datapoint 1 - exists in the Sheet Summary for the Current Projects sheet. This…
Holiday exclusion in a Workday formula
I am trying to write a formula using the workday function that excludes certain holiday. is there a way to have it know the holiday(s) without putting in the actual date? Otherwise, every year I will have to update the formula with each holiday's new date. Here is an example of what I am currently using:…
Move Row Automated Workflow moving ALL rows regardless of criteria
I set up a workflow to move rows that are marked Closed to a Closed sheet. However, the trigger does not seem to work and when I force run the workflow, it moves all of the rows regardless of what is in the cell. What am I doing wrong?