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.
If and checkbox
Comments
-
Dimitris,
Have you tried something like this?
=IF(Checkbox_column1, Value_column1, 0)
[if the checkbox in the 1st row of Checkbox_column is checked, it gives the value in the 1st row of Value_column; otherwise - if not checked - it gives zero.]
Atus
-
Setting the result to 0 will just show an empty checkbox. (1 = checked, 0 = not checked). If you want display an actual 0, add quotes around the zero in the formula Atus suggested, like this:
=IF(Checkbox_column1, Value_column1, "0")
-
Sorry, I wasn't clear. I put the formula in a new (third) column (Text/Number type). The check box just serves as a kind of switch to put a number from the Value_column to the Result_column (third colunn).
-
Thank you Atus and John,
If I put only one IF in my equation, it works, however my problem is that if the result of this column I want to add it in the next one (sum) and when the checkbox is not checked in the sum column it gives me an invalid or blocked message. I have tried many different solutions but I haven't managed to correct it!
What I want to do is in the first (number) column to write a number and then in the next next numbe column write the income I have and in the next one, if I have the checkbox checked, put the value of the first one and if not checked put zero. In the next column I have the difference between income and costs.
I have attached some screen shots
-
I have made it work if I use only one IF, both with checked and not checked, however I cannot make it work with both cases in one equation.
-
Dimitris,
What I first see is that the syntax of your IF formula is wrong, it misses ", 0" (the "else" part) from the end.
- Syntax: IF(logical_test, value_if_true, value_if_false)
Check out Smartsheet help for further info: http://help.smartsheet.com/customer/portal/articles/775363-using-formulas#logic
If you still have problems, please copy the formulas you use in each related colunn here in the discussion and we'll try to help.
-
Hi Atus,
I tried but I didn't make it and I decided to make it a little more manual.
Thanks for your help.Dimitris
-
Dimitris,
Can you elaborate on "a little more manual"?
Craig
-
Thank you for your interest Craig.
I have in a column the expenses that I have to take care of and in the next two columns I have all the incomes and expenses that I have received and paid. On the next column I have a column that calculates the what is the rest of the money I have to make other payments. I wanted to have a checkbox that when I would check it, it would copy the expense to take care of to the column with the expenses that I have paid. However when I do this, calculation in the next column does not work, so now I do manually and copy the number from the first column to the second by writting it.
-
So 5 columns
A Expenses Due - manual entry
B Incomes - manual entry
C Expenses Paid - manual entry?
D Remaining Expenses to be paid - = A - C
E Check box Paid in Full
Are you trying to populate C when the checkbox is checked but not when it is unchecked?
Craig
-
Thank you Craig for your help.
Yes! That's exatly what I want to do. But when I have the If equation in column C, the Remaining expenses from column D does not work for some reason I cannot find.
In some tries, I made it work, but if I had not checked a raw, the next raws did not work.
Dimitris
-
If you add a formula in column C, as soon as you enter data* then you have overwritten it.
I interpret the process as
A - total to be paid
C - might be partial payment (you want to enter an amount
E - check box for 'just pay it off' and save typing.
but that won't work for the reason stated above.
Craig
-
Ok! I understand, but this way, I will never easily be able to the what is my balance in order to be able to know which other payments I can make.
Is there another way doing that?Dimitris
-
Dimitris,
At the simplest, I would just type into column C instead of trying to save a few keystrokes.
From the images you provided previously, I don't see any dates or interrelation between the rows. Is there?
If there are, you might try to think vertically instead of horizontally.
row 1 - summary row
row 2 - expense row
row 3 - payment row #1
row 4 - payment row #2 (if needed)
etc...
for each expense.
I gotta say that if I look at your images, they are mostly Greek to me.
https://en.wikipedia.org/wiki/Greek_to_me
When you refer to the 'balance' do you mean remaining to be paid for each specific expense?
Craig
-
Hahaha!
Thank you once more for your help!
No there is no date interelation, so you promose me to have it as parent and children raws with the summary raw been the parent and the rest, the children ones?
I mean the total Balance. As I have it now it counts all incomes and outcomes and it gives me the total balance.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 382 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 291 Events
- 35 Webinars
- 7.3K Forum Archives