CanadaJim✭

Sorry, I just checked and got the same result. Try making the NumYesNo column a checkbox column and see if that works.

Hi Dan, It seems like you'll need to add a column for ISNUMBER in your sheet, because it won't accept a range and does require parameters. So adding the column (NumYesNo, for example) would allow you to do this: ="Approved Opportunities" + SUMIF([NumYesNo]50:[NumYesNo]61,TRUE,[DCAPS Opportunities]50:[DCAPS…

If you're trying to find the date of a Friday of a given week when starting with a particular date, then this will work: =IF(WEEKDAY([DateColumn]1) = 6, [DateColumn]1, IF(WEEKDAY([DateColumn]1) = 7, [DateColumn]1 - 1, [DateColumn]1 + 6 - WEEKDAY([DateColumn]1))) It basically says if it's already a Friday, you're good. Then…

You could also use a form, and send a reminder with the form link each week. Then every time the form is filled out it will create a new row.

I understand what you're after, Christian, that if you have a key task with SF against 4 tasks, each which has a different start date, then the key task must finish before any and all of the 4 tasks start. However, Craig is right that the formal SF logic says that the predecessor must start before the task is finished. To…

Hi Mark. Sent offline.

Great! Then did the formula above work?

你好乔伊。确保你的列类型[Site Walk Schedule Date] is "Date". It's probably set for Text/Number right now. Regards, Jim

There are formulas by which you can do this manually. You can use the NETWORKDAY function to calculate how many work days are between your start and today, and divide it by another NETWORKDAY using the start and finish dates. Use it in your child rows. =NETWORKDAY([StartDate]1,TODAY())/NETWORKDAY([StartDate]1,[EndDate]1)…

Hi Mark, You can also count the N/A's as "Approved" by adding a separate COUNTIF statement. Something like: IF((COUNTIF([ColumnA]#:[ColumnF]#,"N/A") + COUNTIF([ColumnA]#:[ColumnF]#,"Approved"))=6,"Approved","Not Approved") Jim