-
Re: SUMIF and INDEX/MATCH in one formula
=sum(collect({final total price},{site},@cell = site@row, {need by month year},[need by month year]@row)) You will have to make your other sheet references equal to the range you want to analyze.7 · -
Re: extra space and a comma to remove
you need to separate it out into 3 separate statements and use char(10) between them1 · -
Re: List of date formula I have used repeatedly
Returns the date that a specific day of the current week falls on. *you can change today() in the formula to a reference to a date Sun =today()-weekday(today())+1 Mon =today()-weekday(today())+2 Tue …1 · -
Re: Can I delink the Finish Date from Duration in a Schedule
In gantt view there is a gear in the top right. click that and you can change dependencies.1 · -
Re: July Question of the Month 💭 Join the conversation and receive a badge!
Hunting, fishing, 3d printing, robotics. I like making toys for my niece and nephews, and have made some fun ones. One of my favorite, albeit simpler, is a lithopane of the moon that has a color chan…1 ·