-
Pulling data from another sheet based on two criteria
Hello! I am having trouble getting this formula to work.. The goal is to pull the quantity of an item from a reference sheet to this sheet if the Spec #@row on this sheet matches an EAN on the reference sheet, and only if the Disposition value reads "Released". This is the formula I have cooked up, but get an…
-
I am not able to create a folder in sheets
I am trying to create a folder in sheets so i can organise the sheets i have been made an admin on. Every time i try to create a folder, it comes up with this message. 'The workspace you are trying to modify is not currently available. It may have been deleted, or your permission may have been removed from it'. Why is this…
-
Smartsheet Template for ADDIE Model of ID
Has anyone created a Smartsheet template that follows the ADDIE (Analysis, Design, Development, Implementation, Evaluation) model of instructional design? I'm looking to use Smartsheet to manage our ID process, which is based on that model. Thanks!
-
How to find how many sheets are using forms in my account?
Is there any way to find out how many sheets in my account are using forms? (Short of opening up each sheet and clicking on Manage Forms! We have way too many sheets for that!) We need a way to estimate how many surveys our organization has out there. Thanks for any help.
-
Group Rows in Sheet, not just in Report
I would like to view rows grouped by their category (from a dropdown column) in Sheet form, so that I can add new rows while viewing my data in an easier-to-read format. Currently it seems grouping can only be achieved in a Report which does not allow me to add new rows. I am new to SmartSheet but have intermediate…
-
Data table/sheet connection error notification
We have a data table connected to hundreds of sheets with a look up connection. Until this week, the connection between the sheets and the data table has been functioning just fine. between yesterday 15-Jul-25 and today the sheet connections are showing a "This Sheet is no longer available" error for multiple users. The…
-
Error message when opening a sheet
Recently started having trouble opening some sheets on my account. Thought I may have gone over some limit or something so I upgraded. I also added a licensed user to be available for a new avenue I'm taking with my job. I am still getting the an error message. Status shows that the site is operational. Message states…
-
Capability to quickly grab Folder/Sheet Property Info from Workspace Panel
I often have to grab Folder URL when I'm working on projects. (It helps to not grab each reports/sheets URLs when I have lots to reference to several reports/sheets. Since we have so many, I usually try to locate the sheet/report to find out where they exists, then I have to back track where they are in "Browse" mode. If I…
-
blocking entries in forms
is there a way to block or reject specific email addresses from being entered on a form? For context, we use the form for our facility maintenance requests, and I would like to restrict it to company emails only, while also blocking a handful of specific company email addresses
-
Merged: Email Hyperlink in Sheets
This discussion has been merged.