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,
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
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?
Here you go. You must ensure that column3 is set as a Date type or it won't work...
Thank you so much. It works now
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
Hmmm.. Don't think this can be done. See: https://community.smartsheet.com/discussion/formula-returning-todays-date-if-column-value
Thanks a lot
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
