Trending in Formulas and Functions
Date formula help
Hi, I have a start date column and a complete date column. I am trying to track number of days since the start date (to today) that stops counting when the complete date column is filled in. If I use NETDAYS, it does not give me a count until the second date is filled in. Thanks!
Text Join Formula
Hi there, I created this formula: =JOIN(Course@row) + " " + [Course Date]@row that worked but I need assistance on changing the order of it. Course Date with Parentheses around the date and Couse Name Formula that I have: =JOIN(" ", "(" + [Course Date]@row + ")", [Course]@row) that will not work Example what I want:…
Formula won't recognize cell data
Hi, I have several formulas in sheet summary that reference a single person in an assignment column in my sheet. The formulas are repeated multiple times and work just fine, however I seem to have issues with this single person. Any formula that includes this person, does not work. Any insight on how to fix this? I've…