bisaacs
bisaacs
Reactions
-
Re: Exclude cells with no data?
Hey @holli.nunn, You can wrap the formula in an IFERROR/ISBLANK function like this: =IFERROR(NOT(ISBLANK(ASR@row)), WORKDAY(ASR@row, 14), "") Hope this helps!1 · -
Re: Trying to show the Saturday date of each week, which changes after the date is reached.
Hey @Remy V, This formula should work in a Date column: =IF(WEEKDAY(Date@row) = 1, Date@row + 6, IF(WEEKDAY(Date@row) = 2, Date@row + 5, IF(WEEKDAY(Date@row) = 3, Date@row + 4, IF(WEEKDAY(Date@row) =…1 · -
Re: Help with getting the SUM of multiple columns
Hey @Ty Werven, Actually I would wrap each cell reference in the SUM formula with the INT function, so something like this: =SUM(INT([Preceptor total points]@row), INT([Committee Chair total points]@…1 · -
Re: COUNTIFS formula to pull number of overdue tasks associated with owner
Hey @Abby Stanek, I just realized what the issue is! Remove all the brackets around your column ranges: =COUNTIFS(Owner:Owner, "jane doe", Deadline:Deadline, <TODAY()) You only use brack…1 · -
Re: what is the formula to collect Sprint no, based on the start date for a task from another sheet
Hey @Majduleen, Looks like you're missing a ')' between [End Date]@row and the comma: =INDEX(COLLECT({Project PI & Sprint-Primary Column}, {Project PI & Sprint-Start Date}, <=[Start Date]@…1 ·
