How do I write a formula that returns a circle if a PO value in another column is greater than $100

RPlaud

=IF(["PO Amount"] > $10, "Circle", ["PO Amount"] <$10, "Square")

Mark.poole

@RPlaud

Smartsheet is intelligent enough to where you would not need the $ in your formula.

=IF(["PO Amount"]@row > 100, "Easy", IF(["PO Amount"]@row < 100, "Intermediate"))

How Ever if your Column Name does not actually have the "" in it I would remove those or the formula will not work

=IF([PO Amount]@row > 100, "Easy", IF([PO Amount]@row < 100, "Intermediate"))

RPlaud

Thank you Mark. Does the column column properties need to have the symbol selected?

RPlaud

Also when I put this formula in it reads #Invailddatatype

Mark.poole

Sorry It took so long to reply. Yes you need to select symbol you want. IF you want circle and squares You would have to go lower down the list. Then you would put the formula in the Column that is using the symbols.