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.
Help Using "IF" condition
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,
Comments
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 454 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives