I'm trying to work a formula that will change a given value in one based on dates going into several different cells. Example. If I pour a concrete slab and enter date in that cell another cell would populate to 20% and so on. Would probably have 6 different cells that would trigger a chance in percentage as the job progresses in that one cell that keeps track of percentage . Date in roof installed cell other cell goes from 20%to 45%. I've tried everything I know and have searched this all day. Thanks for any help.
I encourage you to stick around, because we may know of a couple things about the building process, and timelines, and materials, and automatic triggers of such!
I have said it once, I will say it again. IT!