Help Using "IF" condition

Yazid

Hi There,

 

I need your help regarding "IF" condition. I want to create an "IF" condition to do the following job:

 

" IF column 1 is checked, then show today date in column 2" 

 

 

Thanks in advance, 

Ricardo Saroyan-James

Try this:

 

=IF([Column2]1 = 1, TODAY(), "")

 

Column 1 is the description of the thing (Text)

Column 2 is the Checkbox (Checkbox)

Column 3 is the Date (Date)

 

The second "1" is the contents of the checkbox field.  1 = checked, 0 = not checked

Yazid

Thanks Ricardo. i've tried yours, but it doesn't work with me.

 

Do you mind to tend a screen pic when you applied it on sheet? 

Ricardo Saroyan-James

Here you go.  You must ensure that column3 is set as a Date type or it won't work...

 

Yazid

Thank you so much. It works now 

Yazid

Hi Ricardo or anyone sees my comment,

 

Regarding to my previous question. I need the today date to still fixed, beacuse in this condition the date is updated everyday based on today date. Therefore, i need it to be fixed for checked day only.

 

I hope you get my idea.

 

preivous qiestions 

Ricardo Saroyan-James

Hmmm.. Don't think this can be done.  See: https://community.smartsheet.com/discussion/formula-returning-todays-date-if-column-value

 

 

Yazid

Thanks a lot

J. Craig Williams

Update: 

 

I do this now using Zapier (www.zapier.com)

I have a Zap that watches for an empty date column and a completion check box - when the check box is checked by the user, today's date is entered into the date column.

Later, if someone makes another change elsewhere in the row, which triggers the Zap, it does not do anything because the date column is not empty.

 

Craig