I am looking to copy an attachment only between 2 sheets. I can't seem to figure out how to do this! I have even looked at Zapier as an option, but not that familiar with it yet, so not sure how to make it work.
Would the Copy Row automation work for you? (See here) This would create a copy of the entire row though, and you would need to adjust the cell content if you want it to be something different in the other sheet.
As an alternative, what about creating a Report (see here) to bring together rows with attachments from one sheet and display them next to relevant rows in the other sheet?
Let me know if either of these will work for you! If not, it would be helpful to know a bit more about your specific situation... screen captures would be great to see, but please block out any sensitive data.
@Genevieve P - we are using forms on both sheets to capture required information, so if we did the copy row, we'd end up with duplicate rows of registrants. Same with the report option. If i combine the sheets, i'm basically getting 2 rows for each person.
How the process is set up:
For a solution, I've revised the sheets so that the travel agency is inputing data into the registration sheet instead and adding attachments there. But curious to see if there's any other solutions that I just didn't think of!
@S_Karkhoff Thanks for explaining your process! I can't think of another way to automatically bring over those attachments (it would need to be manual).
It sounds like your adjustment of having the travel agency attaching their files in the registration sheet is a good solution for now!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
So, I'm looking to essentially trigger a value if a certain box is checked (indicating amount due was paid) to then transfer that due amount into the paid amount column. I'm struggling due to my limited knowledge, but the formula I've been working on is =IF(checked[Lift Paid@row6], =[Lift Amount Due]@row6). Is it an issue…
Hoping for either formula help or suggestions for how to restructure the data so that I can make this happen! Please let me know if I can clarify anything and thanks in advance to anyone willing to take a stab at this. Main sheet: list of events; one row per event, with the following columns: Event name (text) Attendee…
I have the following data where I am trying to parse the (ISPHUBS-6AAA) from the string below. Assets 1 = ORRR39-ORMOOO-BEACH (ISPHUBS-6AAA) I use the RIGHT formula ... =RIGHT([Assets 1]@row, FIND("(", [Assets 1]@row)) But I get the following string returned Result = -BEACH (ISPHUBS-6AAA) How do I get just the…
©2024. All Rights Reserved Smartsheet Inc.