-
Locking Hierarchy
Even if I lock parent rows, users I've shared my Smartsheet with are able to expand and collapse child rows. Is there a way for me to prevent that?
-
COUNTIFS of a text string based on a condition
I have two text columns. One column contains titles of documents. The second column contains specifies the document's "category." One of the categories in the "Category" column is "Presentations." However, in that category are two different types of presentation: "BDM" and "TDM". Whether a document is a BDM or TDM is…
-
Auto send a completed form to an email address
Hi, I am fairly new to Smartsheet, and was able to create a sheet and a linked form to replace our old HR blast process. My question is this, I created a form, and we have a list of users who needs to get an update/notified of all fields in the form when it is completed, however everytime the form is created I have to type…
-
Embedded IF(AND(OR Function Help
Hello, I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such that all three columns read either "Complete" or "Not required". I've tried to do this by embedding an "OR"…
-
Need help in AverageIf formula with 2 condition
Hi team, I need help with an AverageIF formula. I am working on the request tracking system for Import shipment. I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of transit (Air mode, Ocean Mode, Courier mode) + Average days in transit. Existing AverageIF…
-
Is there a way to limit the max number of characters in a text/number field?
I have a form that I want to use to capture telephone info. Is there a way to limit the max number of characters that can be input in a cell and perhaps show an error message to the user? Also, is there a way to limit input to numerical text only? Thanks. Bill
-
Best practices / templates to create an NPS Form and Dashboard
Good afternoon, I need to create a form to measure Net Promoter Score (NPS) for our PMO office. I have samples for the questions, but I would like to know if anyone has experience building a form specifically to measure NPS. Any ideas/suggestions are welcome. Thanks! Silvana
-
Report that not required to manually adding up new project
Hi Team, Can someone help me how to create a report that doesn't require to manually add when we have multiple projects...Is there a way.? Regards, Tanveer
-
Filtering Columns in Reports
I have a master sheet which has data pertaining to different departments. From this master sheet, I'd like to show only the information relevant to a department to that department, and none of the other data. 1) How do I restrict the datas in the columns that have to be shown 2) If out of 4 child rows, 3 pertain to one…
-
Nested SUMIFS each with multiple criteria
Hello, Diving right in to the problem at hand. I have one sheet that handles reagent requests from multiple departments and another sheet that contains all of the stock solutions these reagent requests are made from. I want successfully created a formula that works for 1 sumifs scenario. =[Request Vol (ml)]@row -…