-
Maintaining multiple sheets with the same format
I created a tracker that I then created 20 copies of and each one is used by a different team. The sheets all have the same workflows/conditional formatting. The business owner keeps wanting to make tweaks to the sheet (like to add a column or something) and it is very time consuming to do that to each individual sheet. Is…
-
Conditional Logic Forms
We have a form that will have yes/no logic. If Yes(problem is resolved with the previous information provided in logic) is selected we want them to back out of the form or display a "thank you, please submit if you have any additional questions" It doesn't appear the functionality is there, but does anyone have work around?
-
Higher Education Campus Reopening Webinar: July 15 (10:00am PST, 1:00pm EST)
This one-hour session is free to join and features a review of our new template set on Return-to-Campus Planning, customer insight on how they use Smartsheet, a short dashboard demo from our Sr. Global trainer, and ending with an open forum to discuss your own use case or ask questions. Check out the "Upcoming Events"…
-
Creating a form with Multiple Logics
I have a very large worksheet - almost 80 columns wide. Of those, about 20 are formula "Only" columns where personnel will not enter data. I would love to use the same form, select from the drop down and the fields auto-populate. But I am getting this error. Is there a limit? Or is the error because I am selecting the same…
-
Audit Compliance and Security Smartsheet
I'm looking for the smartsheet template that was shown in the Audit, Compliance & Security Solution Guide. The guide links to a site that no longer works - I was hoping to locate the template for the pre-audit checklist on page 5 and the project plan on page 6. Does anyone have a similar template to share? I'm starting…
-
Updating (e.g. formatting) Sheets - Is there a better way?
Good Afternoon! I am 2 months new to Smartsheet and enjoying the journey thus far. Project Background: I am working on developing a "master template" of tracking Objectives & Key Results (OKRs). In doing so, using the Master template which contains alot of formulas and conditional formatting, etc. Once I get it designed as…
-
Value in one sheet create a "populate" trigger in another sheet
Good afternoon We have a bid invite sheet that we fill out with prospective jobs (each row is a prospective job) to bid on. It has multiple columns of Data that if we decide to bid on the job would need to be transferred to our sales/estimating sheet. If we had a YES/No drop down column and we choose YES is there a way to…
-
Is it possible to set up your own template sets?
Hello everyone! 👋 I've created a workspace for a project which includes multiple sheets, reports and dashboards which all link together. It's something I've put a good bit of work into for a while! Is it possible to use this as a template set for other projects? As far as I can see, I can only create a template from a…
-
Sheet Linking - Project sheets to single metrics sheet
Hi, I have about 80+ projects running simultaneously. In each project sheet, I have some basic project information & metrics (duration of each milestone calculated from actual start & finish dates) which needs to be tracked and analysed. The information & metrics from all projects should be collected in the Metrics sheet.…
-
Display Logo at the sheet level
Hi, is there a possibility to display 2 logos at the sheet level? I know that I can include a logo image to the workspace and that will replace the "smartsheet" logo from all files within that workspace. But what I am trying to do is to personalise at the sheet level because within the same workspace I have sheets that…