-
How to make a form add a new row each time it is completed?
I have a form set up with an automated request every two weeks. However, after the first time a user has filled out the form, the next time they see it they see the data from the row they created last time. How can I make it so that each time a user completes a form it adds a row to the table? I'm tracking progress updates…
-
Need Help Automating Copy of Historical Values
Hello, I have a sheet that shows Annual Sales Forecast data in two columns - one column for current month forecast, one column for previous month forecast. I use those columns to calculate a third column to show variance from previous to current month. The current month column is pulling values from a separate sheet that…
-
I want a formula that specifies the lowest child of an ancestor, parent, child hierarchy.
I am using the Hierarchy formula, =COUNT(ANCESTORS()), to label my project tasks. A lot of the child tasks have tasks below that, going to a hierarchy of 5. I want to create metrics sheet that shows the estimated completion date for the lowest level child. Because the levels vary by task, I cannot choose a specific…
-
Power BI Report Builder
Hello, Could SmartSheet data feed into Power BI Report Builder? Thanks, Michael
-
Automation enhancement - create complex workflows
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…
-
Merged: Automation enhancement - allow for the ability to copy data from one column to another colu…
This discussion has been merged.
-
Change Cell Value Automation/Workflow
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…
-
Work flow - multiple cell change
Hello, I'd like to learn how to create a multi cell change workflow. See below. Thank you in advance
-
Merged: Automations to copy certain columns
This discussion has been merged.
-
Is it possible to create a workflow to transfer indented rows to a separate sheet?
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…
