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.
