If this column is certain text, use this column plus this many days
Hello, I'm trying to create a formula showing if column A is the word On then use column B date + 75 days, if column A is the word Off, then use column B date + 120 days. All the formulas I'm typing in keeps showing up as #UNPARSEABLE. Help please!!!
Best Answer
-
Try something like this...
=[Column B]@row + IF([Column A]@row = "On", 75, 120)
Answers
-
Try something like this...
=[Column B]@row + IF([Column A]@row = "On", 75, 120)
-
Thanks Paul! Unfortunately that didn't work either :(
I wonder if it has anything with my columns setting. I put the "on" "off" as drop down single select. And the other two columns are set as dates only
-
Are you getting an error or an incorrect result?
-
#INVALID COLUMN VALUE
-
Double check to make sure that both columns are set to be date type columns in the column properties.
Exactly how is [Column B] populated?
-
Column A is a drop down list with either on or off. Column B is set as a date format, so anyone can go in an insert a date. Which should populate Column C into another date.
What I want it to do: Column A: On -> Column B: 02/24/21 -> Column C: 02/24/21 + 75 days
Column A: Off -> Column B: 02/24/21 -> Column C: 02/24/21 + 120 days
-
Yes. If columns b and c are both formatted as dates and column b contains date values, then you should be able to use
=[Column B]@row + IF([Column A]@row = "On", 75, 120)
in column c.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!