Marina_Michaels - profile

Marina_Michaels · Sep 05, 2018

Goal: I want to have a cell display a date only if another column has a date. If I use an IF statement, the date is formatted oddly. Here’s the formula I’m using for my “Next update due” column: IF({Last update sent},DATEADD({Last update sent}, 30, '...

Marina_Michaels · May 20, 2020

I, too, would love to have alternating row shading. That would make the tables more usable and accessible.

Marina_Michaels · Sep 05, 2018

I found the answer. I need to use BLANK() instead of “”. So the proper formula is IF({Last update sent},DATEADD({Last update sent}, 30, 'days'),BLANK())

User Statistics

User Activity

Showing date with IF statement

Re: Alternating Row Color for Read-ability

Re: Showing date with IF statement