Help

Trouble with IF formula to return blank cell

1523 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jill_Schoff
5 - Automation Enthusiast
5 - Automation Enthusiast

I have a column called “Type” with a single select for different options. I have another column that I would like to return a value for ONLY if the Type is “Video: PPT”. Otherwise, I’d like the cells in that column to remain blank. I’ve got the following formula:

DATEADD(
{PPT Blank Due},
IF(
{Type}=“Video: PPT”, 7, BLANK()
),
‘days’
)

It’s working correctly in that it is adding 7 days to the rows with “Video: PPT” but it’s still adding a value for all the other rows too. How do I get those cells to be empty? Is that possible?

Thanks in advance for any guidance.

1 Reply 1
Jill_Schoff
5 - Automation Enthusiast
5 - Automation Enthusiast

Just adding the solution here, in case anyone else had the same question:

IF({Type}=“Video: PPT”, DATEADD({PPT Blank Due}, 7, ‘days’), BLANK())