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
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8  10, Seattle, WA  Register now
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!