Sheets

How to determine how close I am to linking limits
Hi all, Is there a reasonable way to know if I'm getting close to the cross sheet link limits? Thanks, Darrell
Report Features
Hi, may I know can I add any bar or pie chart and customize the design of the smart sheet report just like the widget in the dashboard? Thank you.
Creating a Purchase order spreadsheet
Wondering what template might be the best way to create and share a purchase order system for our construction projects. I want to add links, pictures, pricing quantities etc. Can anyone help with this
Activity Tracker
Hi, I have lots of sheets with different stakeholders who update these sheets, I want to check which row items have not been updated after their due date or Actual End date. How can I schedule report like that?
Building a Dashboard from a Report
Is this possible? I went to try and create a metrics sheet from the report but it doesn't show up. Building the report was supposed to group all of my similar items together, why can i not then build a metric sheet to create my Dash based upon that report?
Send Request for Approval Again
Hi: I have a column set up that an instructional designer changes as the status of a project changes, and I have another column that indicates the status of approval. When the ID changes the status of the development to "In Review", a trigger sends the Program Chair a request for approval. If approved, the ID can change…
SUM or COUNTIF across sheets
I have a Smartsheet for each fiscal year, and will continue to add new sheets for each FY. On a separate sheet, I want to find the sum of values that appears in all of the FY sheets. For example, if I want to sum the total amount an employee makes on my Summary Sheet, referencing data on multiple FY sheets, I know I can…
How do Link a Column w/ drop down items between separate forms/sheets?
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the information I needed and…
Can I set a dynamic default value in a form?
I use a form to help my team record a log of completed work but I have an issue with recording the date. There's a date field on the sheet and I've added it to the form but I want it to default to today's date (whatever that may be when someone uses the form) and I can't find a way to do so. I can set a default value in…
Notification Options when Saving as New
Is there a way to have all the Notification & Sharing Options checkboxes when saving as new? Is there a setting that can be 'turned on' to do this?

Sheets

Discussion List