-
Linking two sheets
Hi! I have two sheets that need to be related. Some of the colums on sheet 1 have to be copied into sheet 2. The columns that need to be on both sheets don´t follow the same order. How do I link them, so that, when sheet 1 is populated, the info directly populates sheet 2´s selected columns? Thank you
-
Marking Successors Status as "Ready" when the Predecessors Status is changed to "Complete"
I am working with a large sheet and developing an automation to update task statuses: when one task is marked as "Complete," the subsequent task is automatically set to "Ready." While my formulas are functioning correctly on a smaller scale, the size of my new sheet is leading to performance issues. Currently, my sheet is…
-
Sending mails out of office through automation not working
Hi, I am trying to send mails to my vendors through my smartsheet. I have an automation workflow for this. When the value in column "Send Mail" is set to yes, it shall send a mail to people who are added in Supplier Contacts 1 column which is a contact list type. I get a notification saying "Not all recipients will receive…
-
Building a formula based on a check box
Good afternoon. I am trying to solve a problem with our projects (we do not have resource management). for projects that are escalated we have a check box that our managers then see with a report due to the check box. Once the project is back on track, the check box is unchecked and the project goes back to the PM. I want…
-
Status Change within a Cell Formula where it moves it to the next stage if true
Below is what I need in a formula string to generate these items from a dropdown list within the cell. Cancel WT = Yes, Status = Cancelled If Demand Planning/AMT Input Complete (AMT) = True, Status = Finance to Add Cost If Finance Input Complete (Finance) = True, Status = IC to Set Up TO IF TO# (Inventory Control) is not…
-
Automation Change Cell Value not working, but working when Test run
I have a Checkbox (Flag) which should change the Value in a Drop Down List to specific Value, which is with formula then referring to shorter Offset days according to a supporting sheet. When I do a Test run of the Automation it works, but when I manually check the Box, its not changing the Cell Value. INDEX(COLLECT…
-
Revert to previous versions of sheets instead of just the activity log snapshot
I just ran automation on an entire sheet instead of just the rows. I wanted to move tasks to a compact task repository, and it moved 364 subtasks that I wish it hadn't. Now, I have to go back and manually revert what I can. Luckily, most of the time, we upload comments and proofs to the parent tasks, which, because they…
-
Tracking & Reporting on Project Hygiene
Hi All! I am starting to explore the possibility of tracking the "hygiene" of each project being managed by our team. We have a control center solution so the artifacts all of us on the team are consistent/templatized and capable of collecting data for a rolled-up portfolio view. So I'd like to be able to leverage that to…
-
Analyze, translate, and summarize your sheet data instantly with AI-powered Smart Columns
May 28, 2026 Eliminate manual data processing and get instant insights into your data with Smart Columns. Instead of spending hours manually categorizing feedback, translating individual cells, or summarizing updates, Smart Columns bring the power of AI directly into your sheets, so you can synthesize and transform data at…
-
Automated update request without including any fields in the email
It would be great to automate an update request email with ONLY a link to the sheet, not also being required to select fields to include in the email.