你好,是否有办法与t共享工作区he whole company/domain without adding them all individually or in a group? I cannot keep the group up to date and asking teams to request access may be a deterrent to them trying (and even so - dependent on the owner accepting in time). I cannot publish the sheets/…
Hi, My Source sheet has the date format as dd-mmm-yyyy. The dynamic view however shows the values in dd-mm-yyyy and mm-dd-yyyy - How can I get the dynamic view to show the correct format? Report from the source file: Dynamic view:
Hi, I have a Program drop down in my projects sheet which currently is manually populated using a report from the programs list. With data shuttle, I have managed to get an extract of program names into the attachment and then data upload to the drop down. However, this is not alphabetical anymore and takes the literal…
Hi, please can someone help on this formula? Program Site Range - A different sheet with multi drop down column sites Program Phase Range - A different sheet with single drop down column =COUNTIFS({Program Site Range}, CONTAINS($Metric@row, @cell), {Program Phase Range}, Justify$1) If I remove the Phase criteria, it works…
Hi, We have a requirement for additional Status options than Red, Amber, Green - I also need Blue to mark complete and Grey for not applicable. Currently, I have to choose either Blue or Grey - just wondered if this came up as a requirement for anyone else and what did you do? I still want to see the circles - so, adding…
Hi, I am creating a form for our weekly status updates so we can see the history. However, it would be useful to have default values pre populated in the form from last week's update so the PMs can update it instead of writing it again - if applicable. This value needs to be pulled from a sheet based on the region/function…
