-
Automation to change cell value based on checkbox not working
I've set up an automation to change a cell value to "Complete" when a checkbox is checked. It either changes all cell values (whether the checkbox is checked or not) OR doesn't make any change at all (when checkbox is checked). I've tried a start from scratch automation and a template. Can someone explain what I'm doing…
-
Automations
Looking to see if anyone else has experienced a similar problem or might have some insight into why the below isn't working right for the team I'm working with. We've setup a grants tracking database that will send automated alerts for various things including if an end date has passed and the grant manager hasn't updated…
-
Tracking changes
Hi, I'm wondering how to track changes that other team members have made in our shared sheets, if someone could let me know how to do this or if there's a report I can pull down, that'd be great.
-
Some clarification to clarify
I have a few questions that I need clarification on: This is a question about multiple selection able to run report and auto counted and group in report I asked this question before, but hope things might be updated, we currently only can run report based on a single section in the column, correct? or can we run report in…
-
Does anyone have a project plan used to bring Smartsheet into your company?
Looking for a project plan that I could use to bring Smartsheet into my company. We are going to be needing SSO Control Center Building Templates for Control Center Building out connectors (mainly for Azure DevOps) Creating Reports (for projects but also for users to see open tasks by project assigned to them) anything…
-
Collecting info via forms, but cells are getting too full: What's the best solution?
Hi all, Here's a quick description of my set-up. We're collecting project progress updates via workflow automations. These forms get sent to various people and the main 'ask' is for them to fill in a free text entry called 'latest update' field. These entries then appear in the 'latest update' field on the main sheet. This…
-
Portfolio WorkApps Not Displaying Projects in Project List
So I am working with building out a Portfolio WorkApp for one of my programs that I have built. When I get it all set up, I can see the projects that I have created for the program on the projects list, but when I hit preview to look to see if it's looking the way I need it to based on the roles, none of the projects show…
-
User Subscription Model - NEED a static VIEWER ONLY option (interns, temps etc.)
User Subscription Model - NEED a static VIEWER ONLY option (interns, temps etc.) In the new User Subscription Model, what options exist if we need a user to ALWAYS ONLY be a VIEWER ONLY? Meaning no action can make them become an Editor/Provisional Member. This new User Subscription Model leaves the department that pays the…
-
Assistance on Calculating Target % Complete & Understand %Complete calculation
I need assistance with understanding how the % Complete for parent tasks in Smartsheet. Specifically, I’m trying to understand how Smartsheet computes these percentages at higher hierarchy levels when using formulas. Even though the Actual%Complete and my calculate column of "Developed %" values for child tasks are…
-
Top board view enhancements to help you quickly find and organize your data
Hello Community, Board view has quickly become the Smartsheet view of choice for users who prefer taking a more visual and interactive approach to task management. We’ve heard your suggestions around how to make finding and organizing data in board view even more intuitive and delightful, and we’re excited to share some…