Formula for a column vs cell
I have this formula but would like it to be a column formula.
=IF(ISBLANK([Entry ID]1), "Desktop Form", "Mobile App")
The syntax isn't right for me to use it as a column formula, can someone help?
Goal:
Submission Method column will say Desktop Form if the Entry ID column is blank
Submission Method column will say Mobile App if NOT blank.
Thanks!
Best Answers

Hi Ruth!
Try this:
=IF([Entry ID]@row = "", "DesktopForm", "Mobile App")
Christine

You're receiving a 0 in your formula since you are adding together different IF statements with the + symbol. This means that if the first IF statement is false, it will return "" or Blank, which is seen as 0:
IF([Payment To_From]@row = "Denver Water", "Utilities")
Then if this is "", or 0, you're adding this to the beginning of the next statement:
0 + IF([Payment To_From]@row = "Xcel Energy", "Utilities")
Instead, try embedding the IF statements together for a Nested IF statement, like so:
=IF([Payment To_From]@row = "Denver Water", "Utilities", IF([Payment To_From]@row = "Xcel Energy", "Utilities", IF([Payment To_From]@row = "Corey Dobbs", "Rent Received", IF([Payment To_From]@row = "Westerra Credit Union", "Mortgage"))))
Cheers!
Genevieve
Answers

Hi Ruth!
Try this:
=IF([Entry ID]@row = "", "DesktopForm", "Mobile App")
Christine

Worked perfect, thank you!

I have another row formula that maybe you can help with.
=IF([Payment To_From]@row = "Denver Water", "Utilities") + IF([Payment To_From]@row = "Xcel Energy", "Utilities") + IF([Payment To_From]@row = "Corey Dobbs", "Rent Received") + IF([Payment To_From]@row = "Westerra Credit Union", "Mortgage")
It auto fills the cells properly but I start getting a zero before the text. What is causing the 0?

You're receiving a 0 in your formula since you are adding together different IF statements with the + symbol. This means that if the first IF statement is false, it will return "" or Blank, which is seen as 0:
IF([Payment To_From]@row = "Denver Water", "Utilities")
Then if this is "", or 0, you're adding this to the beginning of the next statement:
0 + IF([Payment To_From]@row = "Xcel Energy", "Utilities")
Instead, try embedding the IF statements together for a Nested IF statement, like so:
=IF([Payment To_From]@row = "Denver Water", "Utilities", IF([Payment To_From]@row = "Xcel Energy", "Utilities", IF([Payment To_From]@row = "Corey Dobbs", "Rent Received", IF([Payment To_From]@row = "Westerra Credit Union", "Mortgage"))))
Cheers!
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!