I manage 30 production projects across three Smartsheet sheets: one main sheet (Project Management) and two spin-off sheets (for Ordering and Install Certification tracking after a project ships). All sheets use a unique 4-digit job number for each project. What’s a formula or function I can use to quickly identify if any…
Is it possible to include Conditional Formatting in a Report? I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional Formatting in Reports. Thanks!
I am working on a schedule and have a row with no predecessor, however the "start date" won't let me manually change it. It keeps auto-correcting back to the same date that has been in it from the beginning. Any thoughts?
I was working on a sheet and before I started I knew it was going to take me all day and I had this thought that I wish I could throw an "Under Construction" Banner accross the top so people knew that the sheet was undergoing some serious changes. I felt like these banners could also communicate other useful notices to…
Hello all! I did a search, but can't find this exact situation in the community. I'm currently creating and updating a schedule in MS Projects and then importing it into Smartsheet. I've found that when I'm in the schedule in Smartsheet, select "import" and choose the MS Project file, it seems to create an entirely new…
Greetings, Field Settings - Validation - Phone. If you select Canada and save it. The form will display the United States. I went back into settings to double-check the settings were still set to Canada, while the manage form view displayed the United States. Ultimately, my goal is to automate a dropdown with logic that…
Hello! I would like to be able to have multiple values per cell in either dropdown or contacts column, & to still be able to use that column as a swim lane in card view. eg: I have 2 people to assign to 1 project. When I select multiple names in the 'Responsible For' column then switch to card view, I can't view by my…
I would love to have either: A way to save a particular sort, so that if I add rows via forms I can click a button and sort all my rows with a default sort (rather than go through the process of sorting by three different columns every single time I need to sort my sheet An option to enter the row in chronological order by…
I'm working on a global update where I want to add a column to reflect the project name so all the automations include the correct project reference. We use a template that is consistent for every (new) project created. My goal is to add this new column to the overall admin template so both existing and future projects…
