-
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.
-
Balancing governance and flexibility as Smartsheet adoption scales
Over the past year, I’ve been building Smartsheet systems in a multi-partner environment supporting project management, reporting, and operational workflows. As adoption has grown internally and across partner organizations, one challenge I’ve been thinking more about is balancing governance and standardization with…
-
Copy rows to other sheet as values only?
What are some tips please to copy/move rows to other sheet as values only? Specifically, rows which contain column formulae. Is there a known workaround, or should I just use DataMesh? My main issue with this is that I can't copy columns containing column formulae. Thanks for your help, Matt
-
Dynamic View for Approval
Hi, My intake form has a variety of requests and I am using Dynamic View to show only the relevant fields for the request type. The approvers will be using a Dynamic View to select an approval status of approve, deny, or needs revision. I am having trouble figuring out the automations when it gets denied or needs revision.…