Trending in Formulas and Functions
Help with using Networkdays as a column formula
I want to create a column Formula that captures the Start Date and End Date in Networkdays but does not show the Invalid Data Type error for every unused column. Trying to do this without using dependencies since I want more freedom with the start/end dates to be driven by the status rather than input. I tried to use IF…
Compare two columns and input missing items into a third column
I need help with a formula that compares "Training Assigned" and "Training Attended". If they match then I would like the "To Be Completed" column to say "Complete" but if they do not match I would like the missing training to be listed. "Training Assigned" and "Training Attended" are both drop-down fields. =IF([Training…
SUMIF Count to current row possible?
Hello. Trying to make a formula that counts up until the current row in a column. Using =SUMIF([Month Value]:[Month Value], =MONTH(Date@row), Celebrations:Celebrations) allows me to count all the Celebrations that match the month of the date in the row, which is most of what I want to do. However, I want the total summed…