-
Copy row automation/keeping rows linked
Is there a way to keep rows linked from the parent sheet to destination sheet? So if we make changes to the row after the copying takes place to make sure that the destination sheet is also updated with any updates that happen in the row from the parent sheet?
-
I need a formula that allows the following:
If Modified B has “automation@smartsheet.com” then use Modified By column data but if Modified B is anything else place Modified B data in New Modified By column.
-
I need a formula that allows the following
If the Created By is Blank then insert the Create By data in the New Created By Column but if Created By is Not Blank then insert the Created By data into the New Created By column.
-
Workflow Automation changing cell contents
I have 2 'check' columns that indicate Start Confirmed and End Confirmed. I have 2 Workflow automations; When 'Start Actual Confirmed' is checked then 'Status' changes to 'In Progress'. When 'End Actual Confirmed' is checked then 'Status' changes to 'Complete' The issue I am running into is that when a user checks 'Start…
-
Delay automation trigger
Hello, Is there a way to change cell value after the request update entered? - what's happening is once this automation triggered, the cell value changed and that changed trigger another automation to send info to other people but the update has not opened yet for this request Does that make sense?
-
Do automations have an inactivity limit?
We realised that almost all of our automations, at random times, would freeze. We assumed due to no activity for over a month. Is that a thing? If so, is there a way to switch this feature off? I've only just been able to look into it and I don't see any time settings. I'm starting to suspect the reasons might have been…
-
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
