As of now, the automation feature is good but we are limited to only a few levels down in our flows. We cannot create a flow that can change a cell value in one column, clear the value in another column, add a date stamp in a third column all within the same flow. Request - please allow for complex workflows so we can…
This discussion has been merged.
Hi Community - I feel like this is simple, but Im not sure how to make it happen inside of one automation. I keep making individual but I don't think that's good form. On our newsletter sign-up form, we ask "Sector of Work" on a multi-select field. From those results I want it to add a tag in another column (change cell…
Hello, I'd like to learn how to create a multi cell change workflow. See below. Thank you in advance
Is there any way for the workflow to trigger and move the indented row independently from their parent row to a separate mirrored sheet (exact same set up)? My specific scenario: Tracking form numbers that fall under different categories (series/subseries). The forms are indented to be nested under their respective series…
In our schedule file, we have 3 date columns: Baseline Finish Date, Planned Finish Date, and Actual Finish Date. The Baseline Finish Date is what is originally planned but may not always be accurate, so we use the Planned Finish Date to drive up-to-date planning and reporting. This column is linked out to the high-level…
We manually create metric summaries to report out monthly metrics to more easily chart monthly measure data. That summary sheet has a format like below and each row contains SUMIF formulas that aggregates data from other sheets: Month_Ending (Date) : Metric1: Metric2: Metric3: Metric4 Currently, this process requires that…
Hi all Going to try and explain my question but to word it seems difficult. I work within resourcing and i am trying to build an automation that will automatically answer the request after all the dates are fulfilled with resource, however i DONT want it to send individual rows when the request has been sent as a group of…
I have seven (7) sheets that track dates for activities in our facilities. Not all seven sheets have the exact same columns but they all have certain columns that I would like to consolidate onto a master sheet for reporting and metrics. The copy row automation, as you already know, copies the data for all of the columns.…
