I need a if else formula
I am trying to create a formula that returns 1 if the value in the cell is created, then 1 else it returns that value that was originally in the cell.
=IF([Total Sessions Attended]:[Total Sessions Attended] < 1, "1", [Total Sessions Attended]@row)
[Total Sessions Attended] is the column I am looking at in the formula to see if the value is greater than. I tried to use @ row to return the original value, but that did not work.
Best Answer

Hello @mwb , I think your formula should be =IF([Total Sessions Attended]@row < 1, 1, [Total Sessions Attended]@row), if you put the 1 in quotes, it will behave as a string instead of a number, so don't do that.
Answers

Hello @mwb , I think your formula should be =IF([Total Sessions Attended]@row < 1, 1, [Total Sessions Attended]@row), if you put the 1 in quotes, it will behave as a string instead of a number, so don't do that.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.2K Get Help
 358 Global Discussions
 198 Industry Talk
 427 Announcements
 4.4K Ideas & Feature Requests
 135 Brandfolder
 127 Just for fun
 128 Community Job Board
 444 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!