Melissa Yamada
Melissa Yamada
-
Re: Forumla To Sum up Goods in and Out from a seperate Sheet
Hello @WWARRIOR2018 Try this: =INDEX(COLLECT({Cost},{Product},Product@row),1)*[Current Stock Level]@row1 · -
Re: Date rollup formula
Hello @Elayne Smith Try: Start Date: =MIN(CHILDREN()) End Date: =MAX(CHILDREN())1 · -
Re: COUNTIFS & VALUE FUNCTION not providing OUTPUT
Hello @NCNWIncData Try: =IF([Deliverables Count]@row=9, COUNTIFS([Deliverables Count]:[Deliverables Count],9),"")1 · -
Re: Forumla To Sum up Goods in and Out from a seperate Sheet
Hello @WWARRIOR2018 Try this: Goods In Column: =SUMIFS({QTY},{Movement Type},"Goods In") Goods Out Column: =SUMIFS({QTY},{Movement Type},"Goods Out")1 · -
Re: Mutiple Project Status
Hello @Enoch Mak I'd recommend having the table of list of project statuses and duration thresholds on a different sheet. Then try this formula on your Project Status Health column: =IF([Duration (Su…1 ·
